Cannot Create New Database

[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?

[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

[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

[skamasle]

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

[GrantGrace]

And so, as I understand it, it is very difficult to create a database. I've read a lot of articles about this and people keep getting configuration and data configuration errors. My company is engaged in marketing and due to the big problems with creating our own database, we decided to use the existing no data at https://www.uscompanieslist.com/. Fortunately, the proposed list of companies fully meets our needs and every day we are suitable companies that will be interested in our products. Perhaps over time we will still be able to create our own database in which we ourselves will update the lists of new companies that entered the market.

Could you tell me some more information about it? Let’s talk in PM