cannot login to new mysql database after upgrade vestacp and mysql server

ordinaryegi · Post by **ordinaryegi** » Thu Jun 30, 2016 6:03 am

Hi guys
yesterday i had upgrade vestacp to latest version and also upgrade mysql-server to 5.7, today i make new database for client but somehow i can't login to that new database, there's no mistake with user and password but i'm still can't login in phpmyadmin and mysql cli, it's something wrong with my mysql?

regards

Post by **skurudo** » Thu Jun 30, 2016 6:21 am

Your root password to mysql correct? Sure?

There too? -> /usr/local/vesta/conf/mysql.conf

ordinaryegi · Post by **ordinaryegi** » Thu Jun 30, 2016 6:48 am

skurudo wrote:Your root password to mysql correct? Sure?

There too? -> /usr/local/vesta/conf/mysql.conf

no, i'm not using root account but user created from panel, i'm able to login to mysql with root account but not with new account

ordinaryegi · Post by **ordinaryegi** » Thu Jun 30, 2016 7:28 am

update
i try to add user in same database i created from panel in phpmyadmin, i can login successfully but failed with user created from panel, maybe bugs in user database creation in panel

joeleo · Post by **joeleo** » Sun Jul 10, 2016 3:23 pm

Having same issue here... Can't connect to phpmyadmin from panel. The phpmyadmin page launces but not accepting the username/pw created for the account in panel. Also, the page is loading in http not https - I think phpmyadmin page should use default https for access. Please help as I'm looking to get fix for this! FYI, Just did NEW install today and should have installed new fixes from previous issues from new version16..

Post by **skamasle** » Sun Jul 10, 2016 7:38 pm

joeleo wrote:Having same issue here... Can't connect to phpmyadmin from panel. The phpmyadmin page launces but not accepting the username/pw created for the account in panel. Also, the page is loading in http not https - I think phpmyadmin page should use default https for access. Please help as I'm looking to get fix for this! FYI, Just did NEW install today and should have installed new fixes from previous issues from new version16..

Can you connect to your mysql from ssh ?

mysql -u user -p

I Have new vestacp and all working fine whit data bases and users.

Also try connect to your mysql from ssh as root and check if vestacp create your user:

Just connect to mysql as root, type from your root account

Code: Select all

mysql mysql

then

Code: Select all

select user, password from mysql.user;

There will be a list of user you have crated:

Code: Select all

+----------------+-------------------------------------------+
| user           | password                                  |
+----------------+-------------------------------------------+
| root           | *59BE4A458113BD97A44EB5B30C************** |
| admin_default  | *0AEE3251A3770C01D72078262************** |
| roundcube      | *2B0971C1B86481D223F5C16BA0**************0 |
| admin_skamasle | *675A9FC026A91936F9B00E************** |

Vesta Control Panel - Forum