mysql root password

[ralph]

I guess i let the installer set my root mysql password for me since i was using a clean install. Now i cant remember this, i guess this isnt stored in any install log?
Eventually, how do i crypt a new password, and where do i need to change the crypted string in config files? any other than ispcp.conf ?

[ralph]

bump.
where is the password written, andhow do i crypt a new password?

[gurge]

It is very easy, just look her: http://www.google.de/search?q=mysql+set+...t+password

[DecIRC]

Isn't there any problem for ispcp to change the root password ?

cEd

[joximu]

I'd suggest to use a second mysql root account for ispcp - how to change this: see http://www.isp-control.net/ispcp/wiki/howto_dbchangepw

afterwards you can do what you want with the normal mysql root account.

/J

[DecIRC]

After changing the root password, I'm unable to connect to ispcp :

Connection failed: SQLSTATE[28000] [1045] Access denied for user 'root'@'localhost' (using password: YES)

So It's using root password but don't know where defined...

Please help...

[BeNe]

--> http://www.trap17.com/index.php/what-for...t8462.html

Greez BeNe

[DecIRC]

BeNe = I have changed my password without problem. The problem is now ISPCP refuses to work due to this change...

cEd

[BeNe]

Ah ok - sorry!

Quote:5.) Delete your MySQL Password in the Config (/etc/ispcp/ispcp.conf) about line 92 like this:

DATABASE_PASSWORD =

6.) Start the ispcp-db-passwd Script

/var/www/ispcp/engine/ispcp-db-passwd

Now type your new MySQL root Password

Please Enter Your New Database Password:
Please Repeat Your New Database Password:
Database Password Updated Successfully!

7.) That´s it!
Now the GUI should work again.

Greez BeNe