Re: Error 1044 & Error 2003 on 4.0.13 and RH9

[Kevin H. Phillips]

Hi, Nils
OK, here's a copy of the terminal screen I am getting after killing the 
mysqld daemon and then re-starting it:

[root@mail 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
[root@mail 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 root@localhost IDENTIFIED BY 'password' WITH 
GRANT OPTION;
ERROR 1047: Unknown command
mysql>

Here's the screen I'm getting when I start the daemon:

[root@mail root]# ps ax |grep mysqld
32308 pts/0    S      0:00 grep mysqld
[root@mail root]# mysqld_safe --skip-grant-tables &
[1] 32309
[root@mail 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