[cobalt-developers] Re: cobalt-developers digest, Vol 1 #396 - 1 msg

[cLive hoLLoway <clive@xxxxxxxxxxxxxxxxxxx>]

> ----- Original Message -----
> From: "Rodney" <pzo@xxxxxxxxxxxx>
>
> > 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?
> >
> > I had also purchased the software from http://www.abriasoft.com/ for my
> > raq.
> > I was hoping that it would overwrite the old files and start it clean.
> > Did I waste my money with this product knowing that it was already
> > installed on my machine. Or should I still install it when it gets here.

It's in the MySQL manual:

http://www.mysql.com/documentation/mysql/commented/manual.php?section=Resetting_permissions

as root:

1) kill the mysqld daemon
2) type mysqld --skip-grant-tables   (you may need to put full path to daemon)
3) type mysql, and then type:
    mysql> FLUSH PRIVILEGES;
    mysql> set password for root = password('new_password');

    Then quit and you're done.

nb - replace 'new_password' above with the new root password, and "mysql>" 
refers to the mysql prompt (just in case you're as confused as I was at the 
time :)

later

cLive ;-)

-- 
E-commerce developer - Perl dude etc...
JP Interactive / Get Trolleyed    http://www.get-trolleyed.co.uk
print pack 'H56', '4a75737420616e6f7468657220636f72706f726174652077686f7265';