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

[Barry Titmarsh <barry@xxxxxxxxxxxxxx>]

At 19:09 25/11/00 -0800, cLive hoLLoway wrote:
> > ----- 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

Interesting I did all that but when I restarted mysqld normally I get this 
and cant use the Db

[root@boobox /root]# mysql
ERROR 1045: Access denied for user: 'root@localhost' (Using password: NO)

This has been the case since I installed the .pkg from cobalt.

I have red the faq's but this is not covered.

I must admit have no idea about Db's etc..

Barry


> 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';
>
> _______________________________________________
> cobalt-developers mailing list
> cobalt-developers@xxxxxxxxxxxxxxx
> http://list.cobalt.com/mailman/listinfo/cobalt-developers


---------------------------------------------------------------------------------------------------------- 

Barry Titmarsh BMT1-RIPE           Nacamar Ltd (Sheringham Office)
                                                  Knole House 38 Cromer Rd
                                                  Sheringham Norfolk NR268RR
e-mail: barry@xxxxxxxxxxxxxx      voice: +44-1263-821-844
www: www.nacamar.net.uk           fax:    +44-1263-820-271
----------------------------------------------------------------------------------------------------------