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]