Tagged articles

authentication plugin

2 articles · Page 1 of 1

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.

MySQLauth_socketauthentication plugin

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.

Database TroubleshootingMySQLauth_socket

0 likes · 5 min read

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