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.
    Related Articles RSS Feed
    "An error occurred. Please contact administrator." - got error while trying to access remote server from jump server
    Viewed 2864 times since Tue, May 8, 2018
    vzctl enter veid fails. Unable to get term attr: Invalid argument
    Viewed 3048 times since Wed, Jun 14, 2017
    Can’t connect to local MySQL server through socket /tmp/mysql.sock
    Viewed 5315 times since Thu, Jun 15, 2017
    Jump server user password expired
    Viewed 156 times since Tue, Dec 22, 2020
    Unable to open ssh session
    Viewed 3248 times since Thu, Jun 15, 2017
    internal command ezinfo not displaying server details
    Viewed 3504 times since Wed, Jun 14, 2017
    Configuration and error log files to check for troubleshooting
    Viewed 6711 times since Thu, Jun 15, 2017
    no matching host key type found. Their offer: ssh-rsa,ssh-dss [preauth]
    Viewed 3002 times since Mon, Jan 28, 2019
    "Error: LDAP extension is not installed".
    Viewed 3062 times since Fri, Sep 8, 2017
    Install not allowed on this server
    Viewed 650 times since Fri, Mar 20, 2020