Re: [cobalt-users] MySQL Password

["Twooly" <twooly@xxxxxxxx>]

> ----- Original Message -----

>
>
> > 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
>
> hey Todd,
>
> 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.
> Restart mysqld with the --skip-grant-tables option.
>
> Connect to the mysqld server with mysql -h hostname mysql and change the
> password with a GRANT command. See section 7.35 GRANT and REVOKE Syntax.
You
> can also do this with mysqladmin -h hostname -u user password 'new
password'
>
> 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.
>
> Also, you may have to use 'safe_mysqld --skip-grant-tables'. At least with
> my setup, 'mysqld --skip-grant-tables' complained about being run as root
> and terminated
>
> chuck
>
Ok I have tried both things on this page and both don't work.  I can't seem
to get mysql to start.
http://list.cobalt.com/pipermail/cobalt-users/2000-October/023700.html

I have also tried other suggestions given to me by others (ie changing
permissions) but still the same thing

"Starting mysqld daemon with databases from /var/lib/mysql
mysqld daemon ended"

I don't have any databases setup yet so I am not worried about loseing them.
Juse worried about screwing Chiliasp up.  Anything will help.

Thanks again
Todd