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.
Update your table with native authentication.
Recent Posts
Recent Comments
- LogixTree Networks on Localhost showing “Index/of” instead of displaying the Website
- AMANUR RAHMAN on Localhost showing “Index/of” instead of displaying the Website
- Christy on Support Purchase Notes in Order Emails WooCommerce
- LogixTree Networks on Localhost showing “Index/of” instead of displaying the Website
- Sofia on Localhost showing “Index/of” instead of displaying the Website