Re: MYSQLyog

Stut wrote: > Jochem Maas wrote: >> Stut wrote: >>> Jonathan Kahan wrote: >>>> As part of PHP, I have downloaded a windows program called SQLyog which >>> ^^^^^^^^^^^^^^ -> Yeah, but it's not really is it?!! >>>> is supposed to a free web program I can use to run against MYSQL >>>> located in a remote Linux server. My problem is that I can not seem to >>>> connect to it. I am attempting to use a SQL account I created. I typed >>>> in the below commands of course the passwords here are fake. >>>> >>>> GRANT ALL PRIVILEGES ON *.* TO 'jonkah'@'localhost' IDENTIFIED >>>> BY >>>> 'newpassword1' WITH GRANT OPTION; >>>> GRANT ALL PRIVILEGES ON *.* TO >>>> 'jonkah'@'ip-208-109-85-170.ip.secureserver.net' IDENTIFIED BY >>>> 'newpassword2' WITH GRANT OPTION; >>>> GRANT ALL PRIVILEGES ON *.* TO 'jonkah'@'*' IDENTIFIED BY >>>> 'newpassword2' WITH GRANT OPTION; >>>> >>>> Locally using putty I was able to successfully use the 1st of these >>>> accounts. I am unable to connect remotely using SQLyog. We use SSH, >>>> and I attempted to do this with my firewalls turned off-still did not >>>> work. Any help would be greatly appreciated. >>> The wildcard for the hostname is not * it's %. >>> >>> -Stut >> >> your being friendly today Stut, wassup with that ;-) > > New job. Too happy. anything we can do to remedy that? ;-) > > -Stut >