Skip to Content

ERROR creating DB user in MySQL 8.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]

root@localhost: vi /etc/mysql/mysql.conf.d/mysqld.cnf


root@localhost: service mysql restart 

Related Information