Re: [cobalt-users] Mysql

[Bruce Timberlake <bruce.timberlake@xxxxxxx>]

> > Ive forgotten my mysql root pass
> > could some1 pls let me know how do i go about changing it
> >
> Just telnet/ssh in, and type:
> mysqladmin -u root -p password 'new-password'
> It'll prompt you for your old password

That's the problem - he's forgotten that old password! :)

Excerpted from the MySQL documentation
(http://www.mysql.com/doc/R/e/Resetting_permissions.html):

If you have forgotten the root user password for MySQL, you can restore
it with the following procedure:

1.  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.

2. Restart mysqld with the --skip-grant-tables option

3. mysqladmin -h hostname -u root password new-password

4. Load the privilege tables with

mysqladmin -h hostname flush-privileges

--
Bruce Timberlake
Sun Cobalt Technology Engineer
Sun Microsystems, Inc.