So, We installed MySQL in Linux system and after secure_installation. We are unable to access MySQL from a normal user. But, If we go to the root. We can access it without a password.

Recently, In MySQL 5.7, Oracle introduced an authentication plugin ‘auth_socket’ which basically allow access from SQL socket file. In laymen term, You much have access to socket file in order to access MySQL.

Solution: 

When you run the following SQL query, you will get the following table output.

SQL User status

Update your table with native authentication.

Leave a Reply

Your email address will not be published.

Fill out this field
Fill out this field
Please enter a valid email address.

Menu