Topic: mysql default root password ???

[heho]

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 .

[Dan Brown]

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.

[heho]

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 ?

[Dan Brown]

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.

[heho]

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

[Ari]

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

[heho]

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" ...