Re: [cobalt-users] MySQL Password

[Hendrik Runte <cobalt@xxxxxxxxxx>]

> 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
> ------------------------
> Todd Woolums
> Wescris Solutions
> http://www.wescris.com
> twoolums@xxxxxxxxxxx
> 
> _______________________________________________
> cobalt-users mailing list
> cobalt-users@xxxxxxxxxxxxxxx
> To Subscribe or Unsubscribe, please go to:
> http://list.cobalt.com/mailman/listinfo/cobalt-users
> 

Hi Todd,

at first you need to shutdown the mysql server. Telnet (SSH) into your
machine as admin and do the following:

[admin @raq]# su -
Password

[root @root] /etc/rc.d/init.d/mysql stop

Now you need to restart your mysql server as root:

[root @root] safe_mysqld --skip-grant-tables

You can now connect to your mysqlserver with:

[root @root] mysqladmin -hlocalhost -ucobalt-mysql password 'new password'

Reload your privilige tables with:

[root @root] mysqladmin -hlocalhost flush-privileges

Now, you'd better shut down this mysql server again, as it's running in
free-for-all mode. After shutting down run safe_mysqld without any
arguments.

Regards,

Hendrik.