Cannot Create New Database
Cannot Create New Database
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?
Re: Cannot Create New Database
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
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
Patch your ubuntu 16 or mysq5.7 -> viewtopic.php?f=20&t=13239
Transfer accounts from cPanel -> viewtopic.php?f=19&t=11075
Transfer accounts from cPanel -> viewtopic.php?f=19&t=11075
Re: Cannot Create New Database
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
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
Hijgwhite66 wrote: ↑Mon Jan 14, 2019 12:02 pmHi 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
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
Patch your ubuntu 16 or mysq5.7 -> viewtopic.php?f=20&t=13239
Transfer accounts from cPanel -> viewtopic.php?f=19&t=11075
Transfer accounts from cPanel -> viewtopic.php?f=19&t=11075