Hi Jim, > > 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.
No one seems to have (publicly) replied to you. RTFM: A.4.2 How to Reset a Forgotten Password Regards, =dn --------------------------------------------------------------------- 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
