var sidebar_align = 'right';
var content_container_margin = parseInt('350px');
var sidebar_width = parseInt('330px');
mysql root authentication errors
for some reason any cpanel application that needs root access to mysql is not working and fails with a wrong username/password error. I am able to connect via shell no problem at all using mysql -p and then entering hte password, but any application/script that accesses mysql is failing.
check /root/.my.cnf make sure it has the correct pass
there is no password defined in /etc/my.cnf , should there be?
/etc/my.cnf should bear the mysql root password. Otherwise the root will not get connected to mysql. The solution for this problem is to run this script:
This will re-install mysql fully without the loosing your data. All the databases remains intact.
hostech support you are wrong.
there should be a file in /root
named .my.cnf with a period in the front of it just like this:
that has the contents:
putting the root password in the /etc/my.cnf is a security risk hosttechsupport.
ah, I was looking in /etc/ for .my.cnf, found it in /root/