Re: [cobalt-users] MySQL Password

["Charles Williams \(CEO\)" <hosting.mailing.list.account@xxxxxxxxxxxxxxx>]

----- Original Message -----
From: "TWooly" <twooly@xxxxxxxxx>
To: <cobalt-users@xxxxxxxxxxxxxxx>
Sent: Friday, April 20, 2001 11:08 PM
Subject: [cobalt-users] MySQL Password


> Hey I installed the MySQL pkg from http://pkg.nl.cobalt.com a couple of
> weeks ago and I went through steps just like on the site.  That all went
ok
> but since then I have been busy and forgot what I changed the root pass
to.
> Is there any way to recover this?  If not what is the best thing to do to
> get mysql back up and running.  Thanks for the help.
>
> P.S. I installed the RaQ3-RaQ4-MySQL 3.22.32-1 pkg onto a RAQ4

hey Todd,

Take down the mysqld server by sending a kill (not kill -9) to the mysqld
server. The pid is stored in a .pid file, which is normally in the MySQL
database directory:
kill `cat /mysql-data-directory/hostname.pid`

You must be either the Unix root user or the same user the server runs as to
do this.
Restart mysqld with the --skip-grant-tables option.

Connect to the mysqld server with mysql -h hostname mysql and change the
password with a GRANT command. See section 7.35 GRANT and REVOKE Syntax. You
can also do this with mysqladmin -h hostname -u user password 'new password'

Load the privilege tables with: mysqladmin -h hostname flush-privileges or
with the SQL command FLUSH PRIVILEGES.

Note that after you started mysqld with --skip-grant-tables, any usage of
GRANT commands will give you an Unknown command error until you have
executed FLUSH PRIVILEGES.

Also, you may have to use 'safe_mysqld --skip-grant-tables'. At least with
my setup, 'mysqld --skip-grant-tables' complained about being run as root
and terminated

chuck