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

[juliogar63]

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]

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?

 

[juliogar63]

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)

Undefined index: auth_type

 

[juliogar63]

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

Thanks

 

[cPanelLauren]

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.