The system failed to grant privileges on the database ...

Operating System & Version
CentOS v7.9.2009
cPanel & WHM Version
106.0.10

masterross

Well-Known Member
Apr 7, 2004
73
5
158
Hello,

Just made a backup restoration of account and this appeared:
Warning: The system failed to grant privileges on the database “new_db” to the user “new” because of an error: (XID ju8a2v) This system will not add the database user “new” to the database “new_db” because this user does not have a password.

I've found this article about MariaDB:

But I run version 10.2 so what could be the problem?

thanks!
 

quietFinn

Well-Known Member
Feb 4, 2006
1,785
405
438
Finland
cPanel Access Level
Root Administrator
Maybe you get that error " because this user does not have a password " :rolleyes:
 

masterross

Well-Known Member
Apr 7, 2004
73
5
158
Yes, I sat pass manually and added the user to the DB and it worked.
But why the restore srcipt couldnt do that auto?
 

cPRex

Jurassic Moderator
Staff member
Oct 19, 2014
13,329
2,102
363
cPanel Access Level
Root Administrator
I can't say why the restore script wouldn't have worked properly in that situation. We'd need to analyze the backup and restore processes to get more details. If you'd like to create a ticket, assuming you still have the old backup data, we could take a look at that for you.