> >>Thanks for all the replies, I have followed the instructions in the
> manual
> >>and am still getting
> >>an error, here is the message:
> >>-------------------------------------------
> >>simrad_4# safe_mysqld --skip-grant-tables &
> >>[1] 57953
> >>simrad_4# Starting mysqld daemon with databases from /var/db/mysql
> >>simrad_4# mysql
> >>Welcome to the MySQL monitor. Commands end with ; or \g.
> >>Your MySQL connection id is 1 to server version: 3.23.38
> >>Type 'help;' or '\h' for help. Type '\c' to clear the buffer
> >>mysql> grant all privileges on *.* to root@localhost identified by
> 'xxxxxx';
> >>ERROR 1047: Unknown command
>
> that should be:
> grant all on *.* to root@localhost identified by 'xxxxxx' with grant
> option;
>
> Turns out I get the same error message when I try the command
> that way too.
Sounds to me like mysqld has gone completely foobar.
Try doing a reinstall. Your data are probably all
rigt. Don't forget to make a copy of your data dir
after shutting the server down & before reinstalling,
though ;-)
/ Carsten
--
Carsten H. Pedersen
keeper and maintainer of the bitbybit.dk MySQL FAQ
http://www.bitbybit.dk/mysqlfaq
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
