Parminder Singh Chauhan <[EMAIL PROTECTED]> wrote:
> 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>
>
You should use UPDATE command and then FLUSH PRIVILEGES or you can also execute FLUSH
PRIVILEGES and then use GRANT statement.
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensita.net/
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Victoria Reznichenko
/ /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED]
/_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net
<___/ www.mysql.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
