Re: [cobalt-users] MySQL default password

["Andy Clyde, oxfordmusic.net" <andy.clyde@xxxxxxxxxxxxxxx>]

> Hi All,
>
> I've just installed MySQL on a new server from the PKG at pkgmaster.com.
> I'm trying to reset the root password.  It says at the top of the
pkgmaster
> page that the password is:
>
> cobalt-mysql
>
> I've tried this and it won't let me in.  I've also tried not using a
> password at all.  Nothing seems to work.  It's a new server and hasn't had
> MySQL installed on it before... or so I believed when I took out the
> contract on it!
>

How to Reset a Forgotten Password

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.  Connect to the mysqld server with mysql -h hostname mysql and change
the password with a GRANT command. See GRANT.  You can also do this with
mysqladmin -h hostname -u user password 'new password'

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

there's a really good MySQL help file for stuff like this you can download
from www.mysql.com (or else just search the online version on the website).

andy