MYSQLyog
| From: | Jonathan Kahan | Date: | Tue, 20 Mar 2007 15:45:40 +0000 |
| Subject: | MYSQLyog | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-250921@lists.php.net to get a copy of this message | ||
Hi all,
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.
Kind Regards
Jonathan Kahan
--------------------------------------------------------------------
Systems Developer
Estrin Technologies, inc.
1375 Broadway, 3rd Floor, New York, NY, 10018
--------------------------------------------------------------------
Email: jonathan@estrintech.com
Web: http://www.estrintech.com