Cannot restore backups using MariaDB 5.5

enginaar

Verified User
Joined
May 20, 2004
Messages
158
Location
Turkiye
Hi,

I'm trying to transfer accounts from one server to another but failing with a MySQL error even though the version on both servers are the same. I'm getting the error below for every user that I'm trying to restore. This happens both admin and reseller level backups.

Error altering user 'username': You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'USER 'username'@'localhost' IDENTIFIED WITH mysql_native_password AS '*password' at line 1

Anyone knows why this happens or if there is a workaround?

Thank you,
Engin
 
Back
Top