Page 1 of 1

MySQL Root Access Denied

Posted: Fri Nov 29, 2019 12:46 pm
by traven
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.

Code: Select all

mysql> CREATE USER 'linentdba'@'%' IDENTIFIED BY '451325b8890ece';
ERROR 1036 (HY000): Table 'user' is read only
I have tried mysql_secure_installation to fix it but I then get this issue:

Code: Select all

root@linenswop:~# sudo mysql_secure_installation

Securing the MySQL server deployment.

Segmentation fault
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.