Cindy wrote:
>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.
>
Then don't use the -p option to mysqladmin.
It only asks for the password when you tell it to.
>
>
>So what am I missing?
>
>Thanks,
>--Cindy
>
---------------------------------------------------------------------
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
