+- ispCP - Board - Support (http://www.isp-control.net/forum)
+-- Forum: ispCP Omega Support Area (/forum-30.html)
+--- Forum: Usage (/forum-34.html)
+--- Thread: pma Password - Incorrect ! (/thread-5327.html)
pma Password - Incorrect ! - c0urier - 01-04-2009 06:08 AM
So after I installed a new server and moved all users etc over, I have been having constant error with the pma user.
It seems like the passwords dont match in the config.inc.php vs. mySQL.
Is there a way to change the password both for the mySQL and the config.inc.php - So that the password's match and if so how do I do that? - Since I imagine you use some kind of cryptation. I have tried to run the ispcp-db-passwd but it seems not to help at all - Sure that is for the root user.
But since the pma user does not work I cant log in via pma anymore, have to do all changes manually in console which is rather anoying. So any help would be dearly appreciated !
RE: pma Password - Incorrect ! - coper - 01-04-2009 04:20 PM
Try this.
Edit /etc/ispcp/ispcp.conf -- Remove the current password
DATABASE_PASSWORD =
Run this script to put a new password
/var/www/ispcp/engine/ispcp-db-passwd
Please Enter Your New Database Password:
Please Repeat Your New Database Password:
Database Password Updated Successfully!
You need to do this with the script because it is a md5 password.
The pma user and password you can change it editing the file you said /var/www/ispcp/gui/tools/pma/config.inc.php
You can try to do this running again the ispcp setup script (I would do that)
/var/www/ispcp/engine/setup/ispcp-setup
greetings.
c.
RE: pma Password - Incorrect ! - c0urier - 01-04-2009 09:04 PM
Hi coper,
Well I did something else, I used the same pw as I do for the root which is also md5 hashed, so now the user can login again. I will change the password when I moved to a new platform, to much trouble now.
Now I just want to get rid of this line in pma:
Connection for controluser as defined in your configuration failed.
RE: pma Password - Incorrect ! - coper - 01-05-2009 01:01 PM
Hello.
I think you need to change the following in config.inc.php
Inside the config file what it says on this line?
Code:
$cfg['Servers'][$i]['controluser'] = 'pma';You need to put 'root' there instead 'pma'
greetings.
c.
RE: pma Password - Incorrect ! - c0urier - 01-05-2009 04:37 PM
As far as I know, the pma user is created when you make the installation of ispCP - With the point of being the controluser.
RE: pma Password - Incorrect ! - coper - 01-05-2009 04:54 PM
Yes but you said this:
"I used the same pw as I do for the root"
So your are using the root password and not the pma password. You need to change the user in the config file to rid of the line in pma, from 'pma' to 'root'.
RE: pma Password - Incorrect ! - c0urier - 01-05-2009 09:43 PM
(01-05-2009 04:54 PM)coper Wrote: Yes but you said this:
"I used the same pw as I do for the root"
So your are using the root password and not the pma password. You need to change the user in the config file to rid of the line in pma, from 'pma' to 'root'.
If you read it a bit more closely I write that I, or said in another way, changed the pma password to the one which the root user is using, so I didn't have to do the md5 hashing again!
But it doesn't matter now - It is working.
RE: pma Password - Incorrect ! - coper - 01-06-2009 02:01 AM
I told you, you must change the user to root in the configuration file to remove that message. The pma will work well without that change, but that message will show.
So we can say this issue is resolved?