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: > > [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. > Server has started up and is running. (which is fine)
> 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> Try this: mysql> GRANT ALL ON *.* TO '[EMAIL PROTECTED]' IDENTIFIED BY 'password' WITH GRANT OPTION; Note the ' before and after [EMAIL PROTECTED] 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: > > [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 -- --- Valentin Nils Internet Technology E-Mail: [EMAIL PROTECTED] URL: http://www.knowd.co.jp Personal URL: http://www.knowd.co.jp/staff/nils -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]