We are happy to announce that Vesta is back under active development as of 25 February 2024. We are working on v1 candidate and expect to engage more with the community over the coming months. We are committed to open source, and we encourage contributors to help us build the future of Vesta.
MySQL Root Access Denied
MySQL Root Access Denied
Hi there,
I am having issues connecting with the root database user to MySQL in the CLI. I have gone and found my root password here in this file:
/usr/local/vesta/conf/mysql.conf
I have been able to successfully connect to MySQL. However the moment I try to create a MySQL user. I get permission issues.
I have tried mysql_secure_installation to fix it but I then get this issue:
The problem is in Vesta I can create database users and databases without issue. I do however need to create a System User account that has the ability to create databases and users from the CLI and I cant get access after I install Vesta.
Is it possible to install Vesta on a system I have already set up MySQL or does it have to be a fresh box?
Any help for this would be greatly appreciated.
I am having issues connecting with the root database user to MySQL in the CLI. I have gone and found my root password here in this file:
/usr/local/vesta/conf/mysql.conf
I have been able to successfully connect to MySQL. However the moment I try to create a MySQL user. I get permission issues.
Code: Select all
mysql> CREATE USER 'linentdba'@'%' IDENTIFIED BY '451325b8890ece';
ERROR 1036 (HY000): Table 'user' is read only
Code: Select all
root@linenswop:~# sudo mysql_secure_installation
Securing the MySQL server deployment.
Segmentation fault
Is it possible to install Vesta on a system I have already set up MySQL or does it have to be a fresh box?
Any help for this would be greatly appreciated.
Re: MySQL Root Access Denied
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';
viewtopic.php?t=14658
***** 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';
viewtopic.php?t=14658