Hi all, Please forgive the elementary question but I am new to MySQL and DBs in general.
I have inherited a MySQL DB to which the root password is not available, I have read the documentation on the subject but my best efforts have failed to elicit the desired result from MySQL. Could some one out there please tell me what I am missing or what form of advanced muppetry I can committing with the information below. I can stop the sever without any difficulty using the instructions, next I restart the server with; # /usr/bin/safe_mysql --skip-grant-tables & the response to which is; [2] 7494 [1] Done /usr/bin/safe_mysql --skip-grant-tables # starting mysqld daemon from /var/lib/mysql Then I use mysqladmin command thus; # mysqladmin -h localhost -u root password 'new_password' The response to which is; mysqladmin: unable to change password; error: 'You must have privileges to update tables in the mysql database to be able to change passwords for others' AFAIK my syntax seems correct but knowing so little about MySQL at this point I confess to being stuck. Thanks to anyone willing to help me out in advance. Peace Jim --------------------------------------------------------------------- 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
