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.


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. Required fields are marked *

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