MySQL keep down after restart

dsteam

• September 09, 2023 23:15

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 " https://43.252.212.129:2087/cpsess4097094360/3rdparty/phpMyAdmin/themes/dot.gif
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

  • September 10, 2023 06:16

  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.

  0
• 

  dsteam

  • September 10, 2023 07:01

  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

  0
• 

  techAMIGO

  • September 10, 2023 10:59

  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 ```

  0
• 

  cPRex Jurassic Moderator

  • September 11, 2023 14:45

  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.

  0
• 

  dsteam

  • October 31, 2023 09:43

  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 ```

  
  

  0
• 

  dsteam

  • October 31, 2023 09:45

  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.

  
  

  0
• 

  ITHKBO

  • October 31, 2023 12:22

  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.

  0
• 

  SimpleSonic

  • October 31, 2023 13:39

  Have you tried simply resetting the MySQL root password in WHM? SQL Services --> MySQL Root Password

  0
• 

  cPRex Jurassic Moderator

  • October 31, 2023 15:08

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

  0
• 

  dsteam

  • November 01, 2023 06:11

  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.

  
  

  0
• 

  dsteam

  • November 01, 2023 06:12

  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!

  0

Please sign in to leave a comment.