Hi Mark,
I am all set now, The log said it could not find the sql file, so I
put it in /tmp and hard coded the path to /tmp/cloudsql.sql and it
works now!
Weird because I had used ~/cloudsql.sql and /root/cloudsql.sql as
paths too....
Thank you so much for your help! John and Andy too!
-Jason
On Apr 29, 2009, at 1:20 PM, mark konetchy wrote:
Jason,
It looks like mysql is erroring out when you try to start it from
the command line. What does the error log say?
2009/4/29 Jason Todd Slack-Moehrle <mailingli...@mailnewsrss.com>
OK, I have done this:
[r...@server1 ~]# mysqld_safe
A mysqld process already exists
[r...@server1 ~]# /etc/init.d/mysqld stop
Stopping MySQL: [ OK ]
[r...@server1 ~]# mysqld_safe --init-file=~/cloudsql.sql
Starting mysqld daemon with databases from /var/lib/mysql
STOPPING server from pid file /var/run/mysqld/mysqld.pid
090429 20:12:30 mysqld ended
[r...@server1 ~]# mysqld_safe stop
Starting mysqld daemon with databases from /var/lib/mysql
STOPPING server from pid file /var/run/mysqld/mysqld.pid
090429 20:12:54 mysqld ended
[r...@server1 ~]# /etc/init.d/mysqld start
Starting MySQL: [ OK ]
[r...@server1 ~]#
I tried to connect and still same error message of:
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
I must be a dunce, I know you guys know what you are talking about!
-Jason
On Apr 29, 2009, at 12:28 PM, mark konetchy wrote:
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
