Cannot Create New Database
Posted: Fri Jan 11, 2019 12:00 pm
I cannot create a new database in phpmyadmin. When loggin in to phpmyadmin I get the following error messages at the bottom of the page:
The phpMyAdmin configuration storage is not completely configured, some extended features have been deactivated.
To find out why click here.
Connection for controluser as defined in your configuration failed.
I have not changed the root password for Mysql.
I have checked the stored password in:
/usr/local/vesta/conf/mysql.conf
/root/.my.cnf
They are both same original password.
I cannot login to mysql via SSH, mysqladmin -u root -p using the password in the above files, I get the error:
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
When I log into phpmyadmin via a browser using the user admin_root I can gain access but get the error messages at the top of my post. I have tried skurudo's autofix but when doing so the last line reports:
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
Delete temp files
I'm now struggling to find a fix for this, can anyone help?
The phpMyAdmin configuration storage is not completely configured, some extended features have been deactivated.
To find out why click here.
Connection for controluser as defined in your configuration failed.
I have not changed the root password for Mysql.
I have checked the stored password in:
/usr/local/vesta/conf/mysql.conf
/root/.my.cnf
They are both same original password.
I cannot login to mysql via SSH, mysqladmin -u root -p using the password in the above files, I get the error:
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
When I log into phpmyadmin via a browser using the user admin_root I can gain access but get the error messages at the top of my post. I have tried skurudo's autofix but when doing so the last line reports:
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
Delete temp files
I'm now struggling to find a fix for this, can anyone help?