Re: [cobalt-developers] Mysql Password Problem

[Steven Werby <steven-lists@xxxxxxxxxxxx>]

On Wed, 22 Nov 2000, Rodney wrote:

> I had some company install php3 and mysql on a raq3i. It looks like it
> has been completed.
> 
> which mysql = /usr/local/bin/mysql
> 
> The problem is that this guy, or company that I found through elance.
> will not return my calls or anything. He didnt tell me the password or
> user name to MYSQL. I have tried the instructions from cobalt with no
> avial. Is there any other way to reset this information?

It's been a few days, but in the event you haven't found a way in (notes
begin with "//":

1. Kill MySQL.
> ps aux | grep mysql // note the PID
> kill -9 [PID_HERE]
2. Start MySQL bypassing grant tables.
> mysqld -Sg
3. Change MySQL password for user root (below prompt is MySQL prompt)
> USE mysql;
> UPDATE user
> SET password = password("NEW_PWD_HERE")
> WHERE user = "root";
> flush privileges;
> exit;
4. Repeat step 1 and step 2.
5. Restart mysqld without -Sg flags to restart using grant tables (access
control system).


--
Steven Werby {steven-lists@xxxxxxxxxxxx}