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]

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

[mysqld]
default_authentication_plugin=mysql_native_password 

root@localhost: service mysql restart 

 
0 (0)
Article Rating (No Votes)
Rate this article
    Attached Files
    There are no attachments for this article.