Koozali.org: home of the SME Server

Legacy Forums => Experienced User Forum => Topic started by: heho on February 18, 2002, 05:56:07 PM

Title: mysql default root password ???
Post by: heho on February 18, 2002, 05:56:07 PM

I changed manually the mysql root password,
but now when i try to use the e-smith-manager
web interface, he dont know the new password ...

Please tell me how to change the mysql password
in e-smith db configuration files .

Title: Re: mysql default root password ???
Post by: Dan Brown on February 18, 2002, 06:05:34 PM

First, why did you change it?  There's no reason to change the root password, as there's rarely any reason to use it.  Second, the e-smith-manager page doesn't do anything with MySQL, so it shouldn't cause any problem.

Title: Re: mysql default root password ???
Post by: heho on February 18, 2002, 06:11:29 PM

First : well, security reason ...

Second : yes, the e-smith-manager page use mySQL,
when i tried to enabled imp, it's trying to add
a new user and database .

So is there anyway to change this default root password ?

Title: Re: mysql default root password ???
Post by: Dan Brown on February 18, 2002, 06:18:06 PM

You changed a 70+-character random password for security reasons?  Go figure.  It's not a standard, default password; it's randomly generated at install time.

In any case, if you changed it, you'll also need to change it in /root/.my.cnf.

Title: Re: mysql default root password ???
Post by: heho on February 18, 2002, 06:43:08 PM

It's ok now, i add the horde table manually,
and i also set back the root password using
mysql database and .my.cnf

Thanks for your help

Title: Re: mysql default root password ???
Post by: Ari on February 18, 2002, 07:30:55 PM

For future reference, complete documentation of MySQL can be found at:

http://www.mysql.com/documentation/index.html

The command line to change the root password (lord only knows why you'd want to do this...) is:

>    mysqladmin -u root password newpasswordhere

for example, if you were going to set up the new root password to be G321hq94, you would enter:

> mysqladmin -u root password G321hq94

there you go.

Though, just like Dan, I would question your reasoning for changing the default 75+ character password for 'security' reasons...

Cheers!
Ari

Title: Re: mysql default root password ???
Post by: heho on February 19, 2002, 11:02:11 AM

yes i already know this ...
the pb was not changing password but
set back the RIGHT password for
the e-smith config panel ...

but i didnt know it was a 75+ char ,
that's why i changed it ...

excuse me for my "stupidity" ... ;-)