Re: MYSQLyog

On Tue, March 20, 2007 10:45 am, Jonathan Kahan wrote: > As part of PHP, I have downloaded a windows program called SQLyog > which 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. Errrrr. You could just download mysql for Windows, and use the MySQL command line client to connect remotely. mysql -h REMOTESERVERIP -u USERNAME -p DBNAME I also suspect that you may be having trouble with your permissions on the remote side of things, because maybe MySQL can't do a reverse DNS to find your domain name from the IP address. Try adding your user in with IP address instead of domain name. -- Some people have a "gift" link here. Know what I want? I want you to buy a CD from some starving artist. http://cdbaby.com/browse/from/lynch Yeah, I get a buck. So?