Restrore backup on new server: Access denied for user

Pzz

Pzz

Verified User
Joined
May 20, 2013
Messages
135
Location
The Hague area, The Netherlands
Hi,

I've a new server, CentOS 7 and MariaDB 5.5 and I try to restore a backup build on an other server:


Domain ***** CreatedDomain Created Successfully

Unable to restore database *****&#95&#50&#95&#50.sql to *****_2_2 : ERROR 1044 (42000): Access denied for user '*****'@'localhost' to database '*****_2_2'
Click to expand...

Shouldn't this user and database be created (new) on restore? It looks like the database and the user have to be there before I can do a restore?

In that case it's my misunderstanding of the functionality and I will create database and user in advance, but is this true...?
 
Hello,

Yes, it should work.
For the restore of database, DA will assume that the system account is there, and then will temporary change the password that account, and then use it for the restore.
After the restore is done, the old crypt is reset to mysql.user.

My guess, is that perhaps the system account isn't correctly in mysq.user.

Try this.
1) User Level -> MySQL Management -> Delete the DB that is being restored.

2) From the same page, create the database with a fresh user/pass.
This should trigger the re-adding of the system account.

3) Try the restore again. This will drop the database, and re-add it again.

Let us know if that doesn't work.

John
 
Hi,

The errormessage got me to some fast conclusions....

The initial restore did install the database (3 DB's actually). Username and password are correct (like the old settings in the backup). The database looks good to me.

Maybe this gives a new clue on the cause of the errormessage?
 
You must log in or register to reply here.
Back
Top