Current time: 11-01-2024, 09:44 AM Hello There, Guest! (LoginRegister)


Post Reply 
mysql root password
Author Message
ralph Offline
Junior Member
*

Posts: 17
Joined: Jun 2008
Reputation: 0
Post: #1
mysql root password
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 ?
08-20-2008 03:43 PM
Find all posts by this user Quote this message in a reply
ralph Offline
Junior Member
*

Posts: 17
Joined: Jun 2008
Reputation: 0
Post: #2
RE: mysql root password
bump.
where is the password written, andhow do i crypt a new password?
09-11-2008 06:04 PM
Find all posts by this user Quote this message in a reply
gurge Offline
Junior Member
*

Posts: 92
Joined: Mar 2007
Reputation: 1
Post: #3
RE: mysql root password
It is very easy, just look her: http://www.google.de/search?q=mysql+set+...t+password
09-11-2008 06:14 PM
Find all posts by this user Quote this message in a reply
DecIRC Offline
Banned

Posts: 15
Joined: May 2008
Post: #4
RE: mysql root password
Isn't there any problem for ispcp to change the root password ?

cEd
10-17-2008 04:51 AM
Find all posts by this user Quote this message in a reply
joximu Offline
helper
*****
Moderators

Posts: 7,024
Joined: Jan 2007
Reputation: 92
Post: #5
RE: mysql root password
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
10-17-2008 05:06 AM
Visit this user's website Find all posts by this user Quote this message in a reply
DecIRC Offline
Banned

Posts: 15
Joined: May 2008
Post: #6
RE: mysql root password
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...
10-22-2008 04:37 PM
Find all posts by this user Quote this message in a reply
BeNe Offline
Moderator
*****
Moderators

Posts: 5,899
Joined: Jan 2007
Reputation: 68
Post: #7
RE: mysql root password
--> http://www.trap17.com/index.php/what-for...t8462.html

Greez BeNe
10-22-2008 05:06 PM
Visit this user's website Find all posts by this user Quote this message in a reply
DecIRC Offline
Banned

Posts: 15
Joined: May 2008
Post: #8
RE: mysql root password
BeNe = I have changed my password without problem. The problem is now ISPCP refuses to work due to this change...

cEd
10-22-2008 05:11 PM
Find all posts by this user Quote this message in a reply
BeNe Offline
Moderator
*****
Moderators

Posts: 5,899
Joined: Jan 2007
Reputation: 68
Post: #9
RE: mysql root password
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
10-22-2008 05:17 PM
Visit this user's website Find all posts by this user Quote this message in a reply
Post Reply 


Forum Jump:


User(s) browsing this thread: 1 Guest(s)