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 *****_2_2.sql to *****_2_2 : ERROR 1044 (42000): Access denied for user '*****'@'localhost' to database '*****_2_2'
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...?
I've a new server, CentOS 7 and MariaDB 5.5 and I try to restore a backup build on an other server:
Quote:
Domain ***** CreatedDomain Created Successfully
Unable to restore database *****_2_2.sql to *****_2_2 : ERROR 1044 (42000): Access denied for user '*****'@'localhost' to database '*****_2_2'
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...?
Restrore backup on new server: Access denied for user
Aucun commentaire:
Enregistrer un commentaire