Re: MYSQLyog

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 ;-) >