Re: Error 1044 & Error 2003 on 4.0.13 and RH9

[Nils Valentin]

2003年 7月 8日 火曜日 10:25、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.
>
Server has started up and is running. (which is fine)


> 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>

Try this:

mysql> GRANT ALL ON *.* TO 'root@localhost' IDENTIFIED BY 'password' WITH
 GRANT OPTION;

Note the ' before and after root@localhost.

However it is a bit unusual that you dont get an error 1064  - wrong sql 
syntax. How did you install the mysql server (rpm or tar.gz ) ?

Best regards

Nils Valentin
Tokyo/Japan

>
> 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

-- 
---
Valentin Nils
Internet Technology

 E-Mail: nils@stripped
 URL: http://www.knowd.co.jp
 Personal URL: http://www.knowd.co.jp/staff/nils