MySQL keep down after restart

[dsteam]

Dear Sifus,

Need help for solve my server MySQL issue, it keep down no matter how many time restart it
But in SSH it showed active?

I cant view my PHPMyadmin, it show "

mysqli_sql_exception: Access denied for user 'root'@'localhost' (using password: YES)"

below is my.cnf file
---------
[mysqld]
disable-log-bin = 1
default-authentication-plugin = mysql_native_password
performance-schema = 0
datadir = /var/lib/mysql
socket = /var/lib/mysql/mysql.sock
log-error = /var/log/mysqld.log
pid-file = /var/run/mysqld/mysqld.pid
innodb_buffer_pool_size = 134217728
max_allowed_packet = 268435456
open_files_limit = 40000
innodb_file_per_table = 1
mysqlx = 0

I try
/var/lib/mysql/$hostname.err
it show : -bash: /var/lib/mysql/server3.deoworkz.net.err: No such file or directory

OS : CloudLinux v8.8.0 STANDARD standard
MySQL Governor install : Yes

Hope sifus can advise or help on my issue.
Thanks alot

 

[9xlinux]

Are you using Imunify360?
If yes just disable/uninstall it and then check.
I have the same issue and after wasting lot of time finally resolved after uninstall of Imunify360.

 

[dsteam]

Are you using Imunify360?
If yes just disable/uninstall it and then check.
I have the same issue and after wasting lot of time finally resolved after uninstall of Imunify360.

Hi 9xlinux, my server have no setup imunify360

 

[techAMIGO]

Can you execute the following command and share the output with us? Additionally, include the latest errors of the'/var/log/mysqld.log' file.

Command:
```
/scripts/restartsrv_mysql --status
```

 

[cPRex]

Seeing the data from the log would be most helpful here. If that doesn't resolve the issue, we'd be happy to take a look for you, or you could contact CloudLinux directly since you're using MySQL Governor.

 

[dsteam]

Dear TechAMICO, sorry very late reply >.<
Please check the attached file

Can you execute the following command and share the output with us? Additionally, include the latest errors of the'/var/log/mysqld.log' file.

Command:
```
/scripts/restartsrv_mysql --status
```

 

[dsteam]

Hi cPRex,
Thanks for your reply, even i unistall the MySQL Governor, the MySQL still keep down after restart the service

Seeing the data from the log would be most helpful here. If that doesn't resolve the issue, we'd be happy to take a look for you, or you could contact CloudLinux directly since you're using MySQL Governor.

 

[ITHKBO]

Have you tried editing the my.cnf and add just below it skip-grant-tables
Than restart the SQL server

Login to the root with mysql -u root -p
Than refresh the grant tables you just skipped with FLUSH PRIVILEGES;

Set your new password or the one you thought was used with ALTER USER 'root'@'localhost' IDENTIFIED BY 'your password';

Than go back to the my.cnf comment the skip-grant-tables line or simply remove it either works.
Restart the SQL server and try to login again and see if the service also comes up.

 

[SimpleSonic]

Have you tried simply resetting the MySQL root password in WHM?

SQL Services --> MySQL Root Password

 

[cPRex]

Those screenshots look like normal output to me. I would also just try resetting the root password for MySQL.

 

[dsteam]

Dear ITHKBO,

Thanks for your reply, I followed your step and now the MySQL up again and not down again. Thanks for your advise.

Have you tried editing the my.cnf and add just below it skip-grant-tables
Than restart the SQL server

Login to the root with mysql -u root -p
Than refresh the grant tables you just skipped with FLUSH PRIVILEGES;

Set your new password or the one you thought was used with ALTER USER 'root'@'localhost' IDENTIFIED BY 'your password';

Than go back to the my.cnf comment the skip-grant-tables line or simply remove it either works.
Restart the SQL server and try to login again and see if the service also comes up.

 

[dsteam]

Have you tried simply resetting the MySQL root password in WHM?

SQL Services --> MySQL Root Password

Yes, followed the ITHKBO Advise step, and now back to normal ~ hurray!