I seem to be destined to become an expert on restarting mysql and dealing with passwords despite myself :-). This time I'm working on a slight variation: restarting mysql on a machine that we haven't been using for some 18 months and that I myself have never used.
Mysql appears to be installed on it, but no one remembers its root password. Now, if I understand this correctly: a) If you've never installed a root password (ie, you've hopefully just installed it), then you can start it up with safe_mysql --user=mysql & and then use mysqladmin -u root password "whatever" to set it. b) BUT if previously set, this does not work. If you don't remember the password, then you need to stop the mysql server (if applicable), and (re)start it using safe_mysqld --skip-grant-tables & [and then presumably change the password, stop that insecure server & restart normally with --user] But when I do the latter (since that is the situation I have), it's still asking for a password when I start up mysqladmin and doesn't accept anything I give it. So what am I missing? Thanks, --Cindy -- [EMAIL PROTECTED] --------------------------------------------------------------------- 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
