Werner Stuerenburg <[EMAIL PROTECTED]> on 08/14/2001 11:55:37 PM
Internet mail from:
Please respond to Werner Stuerenburg <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED]
cc:
Subject: Re: I blew it big time... locked myself out of mysql
I think it is
grant all on *.* to 'root'@'localhost' identified by 'xxxxxx' with grant
-----------------------------------------
Here's what I tried - what could possibly be wrong with this?
mysql> grant all on *.* to 'root'@'localhost'
-> identified by 'xxxxxx'
-> with grant option;
ERROR 1047: Unknown command
mysql> grant all on * to 'root'@'localhost'
-> identified by 'xxxxxx'
-> with grant option;
ERROR 1047: Unknown command
Still not working.
--
chip
--------------------------------------
[EMAIL PROTECTED] schrieb am Dienstag, 14. August 2001, 22:54:48:
> [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
--
Herzlich
Werner Stuerenburg
_________________________________________________
ISIS Verlag, Teut 3, D-32683 Barntrup-Alverdissen
Tel 0(049) 5224-997 407 · Fax 0(049) 5224-997 409
http://pferdezeitung.de
---------------------------------------------------------------------
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