Re: MYSQLyog

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