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
[mysqld]
default_authentication_plugin=mysql_native_password
root@localhost: service mysql restart
Related Information