Full backup problem

[Guile]

Originally posted by sparek-3
What script are you using that generates this error?

cPanel.net Support Ticket Number:

Cpanel -> Backup -> Generate/Download a Full Backup then I generate a full backup to home directory. All I enter is a valid email and then I hit the generate a backup button. After a few seconds I get:

/usr/bin/mysqladmin: connect to server at 'localhost' failed error: 'Access denied for user: 'root@localhost' (Using password: NO)' l

I did notice that a backup file is generated now, even though I get that error. But I am not sure if the proper mySQL information is in the backup file. How would I be able to verify this?

cPanel.net Support Ticket Number:

[sparek-3]

It doesn't look like the script is trying to use a password to connect to the MySQL database. Since you have assigned a password to the root user a password is required to access any database using the root user. I'm not sure what could be causing this, perhaps someone who has a better understanding of the inner workings of CPanel can answer that question.

cPanel.net Support Ticket Number:

[Guile]

Originally posted by sparek-3
It doesn't look like the script is trying to use a password to connect to the MySQL database. Since you have assigned a password to the root user a password is required to access any database using the root user. I'm not sure what could be causing this, perhaps someone who has a better understanding of the inner workings of CPanel can answer that question.

cPanel.net Support Ticket Number:

sparek-3, thanks for al of your help! I hope somone can help me figure this out soon...

cPanel.net Support Ticket Number:

[simonlee]

Got this in the cPanel FAQ:

Make sure root pass is in /root/.my.cnf

This is usually the first root pass the box was given once cpanel is installed.

If it still does not work, you will need to reset the mysqld root pass.

First, stop the mysqld, usually /etc/rc.d/init.d/mysql stop

Then stop chkservd to keep it from interfering with mysqld while you work on it with /etc/rc.d/init.d/chkservd stop

Start up mysqld , but, without the grant tables, mysqld --skip-grant-tables -u mysql &

Then change the pass..

mysql -u root mysql UPDATE user SET Password=PASSWORD('new_password') WHERE user='root'; FLUSH PRIVILEGES;

Now you just killall -9 mysqld and start it up normally with it's safe_mysqld script..

cPanel.net Support Ticket Number:

[htremblay]

Originally posted by simonlee
Got this in the cPanel FAQ:

Make sure root pass is in /root/.my.cnf

This is usually the first root pass the box was given once cpanel is installed.

If it still does not work, you will need to reset the mysqld root pass.

First, stop the mysqld, usually /etc/rc.d/init.d/mysql stop

Then stop chkservd to keep it from interfering with mysqld while you work on it with /etc/rc.d/init.d/chkservd stop

Start up mysqld , but, without the grant tables, mysqld --skip-grant-tables -u mysql &

Then change the pass..

mysql -u root mysql UPDATE user SET Password=PASSWORD('new_password') WHERE user='root'; FLUSH PRIVILEGES;

Now you just killall -9 mysqld and start it up normally with it's safe_mysqld script..

cPanel.net Support Ticket Number:

Hi, I try that, but I still have the same problem :
/usr/bin/mysqladmin: connect to server at 'localhost' failed error: 'Access denied for user: 'root@localhost' (Using password: NO)'

cPanel.net Support Ticket Number:

[Guile]

Originally posted by Guile
sparek-3, thanks for al of your help! I hope somone can help me figure this out soon...

cPanel.net Support Ticket Number:

Still the same problem...

cPanel.net Support Ticket Number: