Error 1045 on a Restore

[Solokron]

Attempting to restore a mysql backup and receiving...

ERROR 1045: Access denied for user: 'fluxse@localhost' (Using password: YES)

Any ideas?

Thanks!

cPanel.net Support Ticket Number:

[WebNET]

Originally posted by Solokron
Attempting to restore a mysql backup and receiving...

ERROR 1045: Access denied for user: 'fluxse@localhost' (Using password: YES)

Any ideas?

Thanks!

Try this

http://www.mysql.com/doc/en/Resetting_permissions.html

It helped me tremendously! If that doesn't work, go into WHM and reset your MYSQL root password to the same password to see if that will help.

David K.

cPanel.net Support Ticket Number:

[Solokron]

This is not a root password issue.

Thanks though.

Originally posted by WebNET
Try this

http://www.mysql.com/doc/en/Resetting_permissions.html

It helped me tremendously! If that doesn't work, go into WHM and reset your MYSQL root password to the same password to see if that will help.

David K.

cPanel.net Support Ticket Number:

cPanel.net Support Ticket Number:

[ehsan]

same problem here,
if you found a fix, let us know.

cPanel.net Support Ticket Number:

[Jemshi]

how did you try to restore the database ?

try this.

mysql -u username -p databasename < file.sql

it will then ask for password. You can also use like this.

mysql -u username -ppassword database < file.sql

note that there is no space b/w p and password.

or else, if you have only root login to mysql, then you can use the same command with username root and root password ( most probably, it wont be there )