Skip to Content

ERROR creating DB user: Password hash should be a 41-digit hexadecimal number (0) . ERROR granting access for DB user: Can’t find any matching row in the user table (0)

Get the error on MySQL version 8:  ERROR creating DB user: Password hash should be a 41-digit hexadecimal number (0) .   ERROR granting access for DB user: Can’t find any matching row in the user table (0) 

 

  For MySQL 8.0 and above, add the following to /etc/mysql/mysql.conf.d/mysqld.cnf configuration file under [mysqld]

[email protected]: vi /etc/mysql/mysql.conf.d/mysqld.cnf

[mysqld]
default_authentication_plugin=mysql_native_password 

[email protected]: service mysql restart