Hi Guys,
i am still lost here:
GRANT ALL ON mysql.* TO 'root'@'localhost' IDENTIFIED BY 'XXX';
GRANT ALL ON mysql.* TO 'root'@'173.8.172.53' IDENTIFIED BY 'XXX';
FLUSH PRIVILEGES;
Here is the command that I am executing:
[r...@server1 ~]# /etc/init.d/mysqld restart --init-file=~/cloudsql.sql
Stopping MySQL: [ OK ]
Starting MySQL: [ OK ]
[r...@server1 ~]#
In cloudsql.sql I have:
GRANT ALL ON mysql.* TO 'root'@'localhost' IDENTIFIED BY 'xxx';
GRANT ALL ON mysql.* TO 'root'@'173.8.172.53' IDENTIFIED BY 'xxx';
GRANT ALL ON mysql.* TO 'root'@'67.23.34.37' IDENTIFIED BY 'xxx';
FLUSH PRIVILEGES;
commit;
When I try to connect from my machine in my apartment I get:
Unable to connect to host 67.23.34.37.
Be sure that the address is correct and that you have the necessary
privileges.
MySQL said: Host '173.8.172.53' is not allowed to connect to this
MySQL server
Can I start over some how or how do I fix? I have never had this much
trouble, but I guess historically for me, I have not done a setup from
scratch.
-Jason
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org
