The Ultimate Guide to High Availability with MariaDB

Comments - **Only if not connected to Internet** : Access denied for user '<user>'@'localhost' (using password: YES)

1 month, 3 weeks ago Mary Jennings
Re: **Only if not connected to Internet** : Access denied for user '<user>'@'localhost' (using password: YES)

Add 127.0.0.1 localhost to your hosts file (/etc/hosts on Linux/Mac, C:\Windows\System32\drivers\etc\hosts on Windows). In MariaDB’s config (my.cnf or my.ini), set bind-address to 127.0.0.1 to keep it on the local network. Recreate your user with permissions for '<user>'@'localhost' instead of '% to ensure consistent access offline.

This should help

 
Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.