We are happy to announce that Vesta is back under active development as of 25 February 2024. We are working on v1 candidate and expect to engage more with the community over the coming months. We are committed to open source, and we encourage contributors to help us build the future of Vesta.
Can't connect to MySQL localhost (how to)
-
- Posts: 1
- Joined: Mon Jan 14, 2019 1:08 pm
- Os: CentOS 5x
- Web: apache + nginx
Re: MySQL: DATABASE ERROR: CONNECTION FAILED!
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.
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