Hi,
try putting the full path to the init file, and also try putting
the update command after the two grant commands (if you put it first
and the user r...@173.8.172.53 didn't already exist then the password
will not be set for that user) and put a flush privileges as the last
line ,
To me the update seems fairly pointless, unless there are other users with
the name 'root' in addition to the the two specifiied in the grant
commands.
Specifiy the full path in the '--init-file=' option.
Issue the Flush Privileges command after the two GRANT statements not in
between them.
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
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
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
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!
I am trying to start MySQL with --init-file but i get that it is an
invalid option. the 'man' page and --help dont help me decide what is.
Here is what I am doing:
r...@server1 ~]# mysql start --init-file = cloudsql.txt
mysql: unknown option '--init-file'
Thoughts?
-Jason
--
MySQL General
hey jason,
you need to restart the *server* with the init-file option, have a look at:
http://dev.mysql.com/doc/refman/5.0/en/server-options.html
2009/4/28 Jason Todd Slack-Moehrle mailingli...@mailnewsrss.com
I am trying to start MySQL with --init-file but i get that it is an invalid
Hi,
I am trying:
[r...@server1 ~]# /etc/init.d/mysqld restart --init-file=cloudsql.sql
Stopping MySQL:[ OK ]
Starting MySQL:[ OK ]
the cloudsql.sql file contains:
UPDATE mysql.user SET