Restore database and ERROR 1045 (28000): Access denied user 'user'@'localhost'

T

tonymontana

Verified User
Joined
Dec 30, 2017
Messages
43
Hi,

I try restore database via DirectAdmin panel (not phpmyadmin) and I receive this error:

Code: 
Cannot restore database xxx_xxx : ERROR 1045 (28000): Access denied for user 'xxx'@'localhost' (using password: YES) gzip: stdout: Broken pipe

I work on Debian.

Thank you for all replies.
 
Try to unpack the gzip file manually to see if that works. Because a broken pipe notice often points to a corrupted backup.
 
Hi,

Before I wrote i tried import sql file via phpmyadmin. And i have this is errors:

Code: 
Error

Static analys:

1 error found.

    Missing. (near "ON" at position 25)

SQL query: edit

SET FOREIGN_KEY_CHECKS = ON;

MySQL returned a message:
#2006 - MySQL server has gone away
 
Hello,

Why do you try to restore a DB? Do you have an error on mysql logs under /var/lib/mysql/? What do you see there?
 
You must log in or register to reply here.
Back
Top