Page 1 of 1

Phpmyadmin

Posted: Wed Dec 31, 2014 10:30 pm
by Allan
What is the default password for phpmyadmin upon install?

Re: Phpmyadmin

Posted: Wed Dec 31, 2014 10:39 pm
by joem
Allan wrote:What is the default password for phpmyadmin upon install?

Code: Select all

 nano /usr/local/vesta/conf/mysql.conf

Re: Phpmyadmin

Posted: Wed Dec 31, 2014 11:01 pm
by Allan
I changed the password and still can't access phpmyadmin.

Re: Phpmyadmin

Posted: Wed Dec 31, 2014 11:27 pm
by joem
Allan wrote:I changed the password and still can't access phpmyadmin.
You asked for the password not how to change it. To change it,

mysql
UPDATE mysql.user SET Password=PASSWORD('NewPass') WHERE User='root';
FLUSH PRIVILEGES;
exit
Make sure you update the password in this file,

Code: Select all

    nano /usr/local/vesta/conf/mysql.conf

Re: Phpmyadmin

Posted: Wed Dec 31, 2014 11:48 pm
by Allan
Thank you for trying to help, but new to VPS commands so was wanting to know what I should put into putty.


No worries I got it, thank you.

Re: Phpmyadmin

Posted: Wed Dec 31, 2014 11:51 pm
by joem
Allan wrote:Thank you for trying to help, but new to VPS commands so was wanting to know what I should put into putty.
Post all the code from my post above into putty one line at a time.