Page 1 of 1
cannot login to new mysql database after upgrade vestacp and mysql server
Posted: Thu Jun 30, 2016 6:03 am
by ordinaryegi
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
Re: cannot login to new mysql database after upgrade vestacp and mysql server
Posted: Thu Jun 30, 2016 6:21 am
by skurudo
Your root password to mysql correct? Sure?
There too? -> /usr/local/vesta/conf/mysql.conf
Re: cannot login to new mysql database after upgrade vestacp and mysql server
Posted: Thu Jun 30, 2016 6:48 am
by ordinaryegi
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
Re: cannot login to new mysql database after upgrade vestacp and mysql server
Posted: Thu Jun 30, 2016 7:28 am
by ordinaryegi
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
Re: cannot login to new mysql database after upgrade vestacp and mysql server
Posted: Sun Jul 10, 2016 3:23 pm
by joeleo
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..
Re: cannot login to new mysql database after upgrade vestacp and mysql server
Posted: Sun Jul 10, 2016 7:38 pm
by skamasle
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
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************** |