OK, here's a copy of the terminal screen I am getting after killing the mysqld daemon and then re-starting it:
[EMAIL PROTECTED] root]# ps ax |grep mysqld
32309 pts/0 S 0:00 /bin/sh /usr/bin/mysqld_safe --skip-grant-tables
32334 pts/0 S 0:00 /usr/libexec/mysqld --basedir=/usr --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/mail.9-5usa.org.pid --skip-locking --skip-grant-tables
32383 pts/1 S 0:00 grep mysqld
[EMAIL PROTECTED] root]# mysql -u root
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 1 to server version: 4.0.13-log
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql> SHOW GRANTS FOR root;
ERROR 1047: Unknown command
mysql> GRANT ALL ON *.* TO [EMAIL PROTECTED] IDENTIFIED BY 'password' WITH GRANT OPTION;
ERROR 1047: Unknown command
mysql>
Here's the screen I'm getting when I start the daemon:
[EMAIL PROTECTED] root]# ps ax |grep mysqld 32308 pts/0 S 0:00 grep mysqld [EMAIL PROTECTED] root]# mysqld_safe --skip-grant-tables & [1] 32309 [EMAIL PROTECTED] root]# Starting mysqld daemon with databases from /var/lib/mysql
I hope this information helps.
Thanks very much, Kevin
Nils Valentin wrote:
Hi Kevin;
Try to start it as
mysqld_safe --skip-grant-tables &
to start the service in the background, you will then be able to continue in the same window. Sorry I didn't mention this.
Can you post the grant command you try exactly as it is to the mailing list please (without password of course ;-)
Best regards
Nils Valentin Tokyo/Japan
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
