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

Aikesheng Open Source Community

Nov 8, 2019 · Databases

Using MySQL auth_socket Plugin for Password‑less Authentication

This article explains how the auth_socket (MySQL) and unix_socket (MariaDB) plugins enable password‑less login by mapping operating‑system users to MySQL accounts, walks through installing and enabling the plugins on Debian, Ubuntu, MariaDB, and Percona Server, and demonstrates creating and using socket‑authenticated users.

PasswordlessPerconaUnix socket authentication

0 likes · 8 min read

Using MySQL auth_socket Plugin for Password‑less Authentication