Page 1 of 1

Cannot Create New Database

Posted: Fri Jan 11, 2019 12:00 pm
by jgwhite66
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?

Re: Cannot Create New Database

Posted: Sun Jan 13, 2019 6:14 pm
by skamasle
Hi

You use ubuntu ? or what system ?

Why you not create databases from vestacp for not break integration., if you make out of vesta a database that not included in vesta backups

Re: Cannot Create New Database

Posted: Mon Jan 14, 2019 12:02 pm
by jgwhite66
Hi skamasle

Thanks for your reply to my problem. I'm using Ubuntu 14.04.5, Vesta CP.

When I try to create a database in Vesta CP I recieve the error: Error: Connection to localhost failed.

When I login to Phpmyadmin as admin_root I then cannot browse existing database tables, I revieve the error: #1142 - SELECT command denied to user 'admin_root'@'localhost' for table 'pma__table_uiprefs'

I'm sure there is a password somewhere which is wrong but I cannot find it and am stuck as to how to debug this.

Thanks

John

Re: Cannot Create New Database

Posted: Sun Jan 20, 2019 5:10 pm
by skamasle
jgwhite66 wrote:
Mon Jan 14, 2019 12:02 pm
Hi skamasle

Thanks for your reply to my problem. I'm using Ubuntu 14.04.5, Vesta CP.

When I try to create a database in Vesta CP I recieve the error: Error: Connection to localhost failed.

When I login to Phpmyadmin as admin_root I then cannot browse existing database tables, I revieve the error: #1142 - SELECT command denied to user 'admin_root'@'localhost' for table 'pma__table_uiprefs'

I'm sure there is a password somewhere which is wrong but I cannot find it and am stuck as to how to debug this.

Thanks

John
Hi

You say the password stored here is original: /usr/local/vesta/conf/mysql.conf

Can you try to connect from cli with that password ?

Also you need check than user is working, so, check if the user stored in /usr/local/vesta/conf/mysql.conf is correct and have privileges, I not see never than vesta set a user as admin_root as I know always is root instead of admin_root

But I cant say you surelly because I not use ubuntu to much, check it, user, and password, if not works reset root password, set it in all vesta files and change user admin_root for root