[EMAIL PROTECTED]@bellsouth.net on 08/14/2001 10:03:13 PM
Internet mail from:
Please respond to [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
cc: [EMAIL PROTECTED], [EMAIL PROTECTED]
Subject: Re: I blew it big time... locked myself out of mysql
On Tue, 14 Aug 2001 12:16:59 -0700, [EMAIL PROTECTED] wrote:
>>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.
--
Chip
Mike(mickalo)Blezien
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Thunder Rain Internet Publishing
Providing Internet Solutions that work!
http://www.thunder-rain.com
Tel: 1(225)686-2002
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
---------------------------------------------------------------------
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