We are happy to announce that Vesta is back under active development as of 25 February 2024. We are working on v1 candidate and expect to engage more with the community over the coming months. We are committed to open source, and we encourage contributors to help us build the future of Vesta.
cannot login to new mysql database after upgrade vestacp and mysql server
-
- Posts: 3
- Joined: Wed Nov 12, 2014 7:45 am
cannot login to new mysql database after upgrade vestacp and mysql server
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
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
Your root password to mysql correct? Sure?
There too? -> /usr/local/vesta/conf/mysql.conf
There too? -> /usr/local/vesta/conf/mysql.conf
-
- Posts: 3
- Joined: Wed Nov 12, 2014 7:45 am
Re: cannot login to new mysql database after upgrade vestacp and mysql server
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 accountskurudo wrote:Your root password to mysql correct? Sure?
There too? -> /usr/local/vesta/conf/mysql.conf
-
- Posts: 3
- Joined: Wed Nov 12, 2014 7:45 am
Re: cannot login to new mysql database after upgrade vestacp and mysql server
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
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
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
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
Code: Select all
select user, password from mysql.user;
Code: Select all
+----------------+-------------------------------------------+
| user | password |
+----------------+-------------------------------------------+
| root | *59BE4A458113BD97A44EB5B30C************** |
| admin_default | *0AEE3251A3770C01D72078262************** |
| roundcube | *2B0971C1B86481D223F5C16BA0**************0 |
| admin_skamasle | *675A9FC026A91936F9B00E************** |