cpanel restoration error

hmaddy

• April 07, 2023 12:38

cpanel restoration error Warning ("MysqlBase::_do_cpanel_mysql_with_newuser_privs", line 599): Error from MySQL query :(XID s48fmk) The system received an error from the "MySQL" database "mysql": 1410 (You are not allowed to create a user with GRANT):

• 

  cPRex Jurassic Moderator

  • April 07, 2023 17:40

  Hey there! This often happens because of the validate password plugin being enabled in MySQL. Can you try running this from Bash to see if that changes the behavior? mysql -e "uninstall plugin validate_password;"
  

  0
• 

  Wil Hatfield

  • October 26, 2023 14:56

  Hey there! This often happens because of the validate password plugin being enabled in MySQL. Can you try running this from Bash to see if that changes the behavior? mysql -e "uninstall plugin validate_password;"
  

  
  I'm seeing this same thing on a restore. I ran your command and it says that validate_password does not exist. What's your next guess?

  0
• 

  cPRex Jurassic Moderator

  • October 26, 2023 15:51

  Does running this command give any output other than 1? mysql -e "SELECT User FROM mysql.user WHERE Plugin = 'caching_sha2_password'" | wc -l If you have that plugin enabled it could cause issues with cPanel and lead to that error.

  0

Please sign in to leave a comment.