Thanks
Now I am able to get back the cursor
but I can't change the password
[EMAIL PROTECTED] parminder]# /usr/local/mysql/bin/mysql -u root
mysql
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 3 to server version: 4.0.16-log
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql> SET PASSWORD FOR [EMAIL PROTECTED]('353715');
ERROR 1132: You must have privileges to update tables in the
mysql database to be able to change passwords for others
mysql>
On Wed, 2003-10-29 at 18:49, [EMAIL PROTECTED] wrote:
> to help the mysqld_safe 'finish' you'll need to append an '&' to your
> command, which will have the process start in the background and give you
> your prompt back.
> /usr/local/mysql/bin/mysqld_safe --skip-grant-tables &
>
> now you can hit the enter key, and you'll get your prompt back and
> the server will still be running.
>
> although i'd heed the warnings about runnign your server as root.
>
> hth
> Jeff
>
>
>
>
> Parminder Singh
>
> Chauhan To: MySql <[EMAIL PROTECTED]>
>
> <[EMAIL PROTECTED] cc:
>
> t.com> Subject: RE: Change of root password
>
>
>
> 10/29/2003 01:30
>
> PM
>
>
>
>
>
>
>
>
>
> I can't get through
> I am doing as follow. Is it right or I am doing something wrong?
>
>
> [EMAIL PROTECTED]
> parminder]#
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
