MySQL Root Access Denied
Posted: Fri Nov 29, 2019 12:46 pm
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.