Change path to datadir and socket in /etc/my.cnf and I have error

juliogar63

• January 03, 2020 10:06

Change the path to save the mysql databases in my.cnf, thats ok but I have this error

cPanel & WHM has determined that the following database tables are corrupt: Database Error mysql mysqlcheck: [ERROR] unknown variable 'symbolic-links=0' We recommend that you repair these tables with WHM"s Repair a MySQL/MariaDB Database interface, but I cant see the database there I cant make backups and I cant entry to phpmyadmin drom the cpanel client The site are working fine Could you help me please Thanks

• 

  cPRex Jurassic Moderator

  • January 03, 2020 15:14

  Hello there. Do you have the symbolic-links=0
  value setup inside /etc/my.cnf on the system? If so, can you try removing that and restarting MySQL to see if that helps to resolve the issue?

  0
• 

  juliogar63

  • January 03, 2020 15:42

  cPRex, thanks for your reply Resolve only the make backups from the cpanel client but I cant entry to phpmyadmin I have a diferent screen and this message mysqli_connect(): (28000/1045): Access denied for user 'cerranet'@'localhost' (using password: YES) https://cerranet.net:2083/cpsess5740155838/3rdparty/phpMyAdmin/themes/dot.gif
  Undefined index: auth_type

  0
• 

  juliogar63

  • January 03, 2020 15:44

  And I cant see any database from WHM into the repair databeses section Thanks

  0
• 

  cPanelLauren

  • January 08, 2020 17:06

  Can you provide the contents of the mysql configuration file? You can get this by running the following: cat /etc/my.cnf
  Please ensure that you remove any identifying information like IP addresses and domain names.

  0

Please sign in to leave a comment.