ot error: 1045: Access denied for user 'root'@'localhost'

ri

ricardofh Aug. 11, 2018, 6:04 p.m. #1

When I try to:
mysqlcheck --all-databases -r #check
mysqlcheck --all-databases -r #repair
mysqlcheck --all-databases -a #analyze
mysqlcheck --all-databases -o #optimize

This appears:
mysqlcheck: Got error: 1045: Access denied for user ‘root’@‘localhost’ (using password: YES) when trying to connect

How can I fix it?

ri

ricardofh Aug. 11, 2018, 6:14 p.m. #2

Unable to access to PHPMyAdmin with root access too: mysqli_real_connect(): (HY000/2002): Connection refused

ri

ricardofh Aug. 11, 2018, 6:27 p.m. #3

mysql -u root -p;
Enter password:
ERROR 2002 (HY000): Can’t connect to local MySQL server through socket ‘/var/lib/mysql/mysql.sock’ (111 “Connection refused”)

And chose the password from: cat /etc/cyberpanel/mysqlPassword

bd

bdevroey Aug. 31, 2018, 10:03 p.m. #4

111 means Connection refused. That is, nothing is listening to that socket.

This means that MariaDB is not running, or is misconfigured
systemctl status mariadb