Ubuntu 20.04 LTS MySQL Access Denied for Root User

📖 ~1 min read

Table of contents

1. Symptom & Impact
2. Environment & Reproduction
3. Root Cause Analysis
4. Quick Triage
5. Step-by-Step Diagnosis
6. Solution – Primary Fix
7. Solution – Alternative Approaches
8. Verification & Acceptance Criteria
9. Rollback Plan
10. Prevention & Hardening
11. Related Errors & Cross-Refs
12. References & Further Reading

Symptom & Impact

Administrative DB tasks fail because root login is rejected.

Environment & Reproduction

Ubuntu 20.04 LTS using default MySQL auth_socket or changed auth plugin.

Root Cause Analysis

Login method and credentials do not match configured root authentication mechanism.

Quick Triage

Determine whether root uses auth_socket or password-based plugin.

Step-by-Step Diagnosis

Inspect mysql.user plugin settings and local socket access behavior.

Solution – Primary Fix

Set intended root auth plugin and securely reset credentials.

Solution – Alternative Approaches

Create dedicated admin account instead of direct root application access.

Verification & Acceptance Criteria

Administrative login works using approved auth method and least privilege.

Rollback Plan

Revert plugin changes and restore prior grants if application compatibility fails.

Prevention & Hardening

Standardize MySQL auth policies and avoid ad hoc root account modifications.

Related Errors & Cross-Refs

May coincide with socket path mismatches and service startup issues.

Related tutorial: View the step-by-step tutorial for Ubuntu 20.04 LTS.

View all Ubuntu 20.04 LTS tutorials on the Tutorials Hub →

Browse all common problems & solutions on the Tutorials Hub.

References & Further Reading

See MySQL authentication plugin docs and Ubuntu server database guides.