Vesta Control Panel - Forum

Community Forum

Skip to content

Advanced search
  • Quick links
    • Main site
    • Github repo
    • Google Search
  • FAQ
  • Login
  • Register
  • Board index Main Section Database Server
  • Search

MySQL Root Access Denied

Questions regarding the Database Server
MySQL, PostgreSQL, MariaDB, Percona Server, phpMyAdmin, phpPgAdmin
Post Reply
  • Print view
Advanced search
1 post • Page 1 of 1
traven
Posts: 1
Joined: Wed Nov 27, 2019 11:59 am

Os: Ubuntu 18x
Web: nginx + php-fpm
MySQL Root Access Denied
  • Quote

Post by traven » 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.

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


Post Reply
  • Print view
1 post • Page 1 of 1

Return to “Database Server”



  • Board index
  • All times are UTC
  • Delete all board cookies
  • The team
Powered by phpBB® Forum Software © phpBB Limited
*Original Author: Brad Veryard
*Updated to 3.2 by MannixMD
 

 

Login  •  Register

I forgot my password