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.
Update your table with native authentication.