Can't connect to MySQL localhost (how to)

[josephpereira10]

Hello
this error is very easy to solve, open your panel vestacp, and server, go in mysqld, configure, and advanced options,
and in the second line below [mysqld] add this code, skip-grant-tables
done that it will return to normal access to all the DBs, and but remember to remove the code again, because all the DBs of the users were visible to all.

Code: Select all

skip-grant-tables

Code: Select all

[mysqld]
skip-grant-tables
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
symbolic-links=0

skip-external-locking
key_buffer_size = 16M
max_allowed_packet = 16M
table_open_cache = 64
sort_buffer_size = 512K
net_buffer_length = 8K
read_buffer_size = 256K
read_rnd_buffer_size = 512K
myisam_sort_buffer_size = 8M