Jun 1, 2022 · Databases

Why MySQL Root Can Connect Without a Password and How to Fix It

This article explains why a MySQL root account may bypass password authentication, walks through common causes, demonstrates reproducing the issue, identifies the auth_socket plugin as the culprit, and shows how to switch to a native password plugin to restore proper password checks.

auth_socketauthentication pluginmysql

0 likes · 8 min read

Why MySQL Root Can Connect Without a Password and How to Fix It

Aikesheng Open Source Community

Nov 23, 2020 · Databases

Resolving MySQL 5.7 Login Issue Caused by the auth_socket Plugin and Exploring Its Use Cases

The article describes a puzzling MySQL 5.7 situation where any password works, investigates the cause as the auth_socket authentication plugin, provides exact SQL commands to fix the issue, and explains the plugin's security characteristics and appropriate deployment scenarios.

auth_socketauthentication plugindatabase troubleshooting

0 likes · 5 min read

Resolving MySQL 5.7 Login Issue Caused by the auth_socket Plugin and Exploring Its Use Cases