MySQL Root Access Denied

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

[caustino]

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