Vesta Control Panel - Forum

Ubuntu 16.04 at Digital Ocrean
Latest VestaCP

https://new.siteviewer.us/phpmyadmin/

Try to log in with username and password after creating database in vesta.

[/b]
This also happens when i create new users as well.


This is a new vesta installation and the only things i've done are.
Installed configured and activated vesta-lets-encrypt

I'm not sure exactly what it was but i found two things.

I have a installer script for ubuntu that sets up my preferred configurations.
I started from scratch installing vesta first and ran that after installing vesta.

Also the password for the user i was creating had a single quote in it.

Apparently when creating passwords that have single quotes, they aren't escaped.
Doubling single quotes allows you to escape and use them.
would let you log in with

I solved it in this simple way
***** restore user root mysql *****
mysql -u root -p mysql
MariaDB [mysql]> update user set plugin='' where user='root';
MariaDB [mysql]> flush privileges;
MariaDB [mysql]> exit
***********************************

to disable user root again ....
update user set plugin='unix_socket' where user='root';