i dont think that the init.d script will accept the argument. you need to run /usr/bin/mysqld_safe --init-file=clouds.sql &
(or whatever the path to mysqld_safe is) 2009/4/29 Jason Todd Slack-Moehrle <mailingli...@mailnewsrss.com> > 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 > >
