Comments - Not able to access MariaDB even from LocalHost - Access denied for user 'root'@'puppetmaster29' (using password: YES)
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.
From your question, it is not clear if the *mariadb* root user is using unix_socket authentication as its authentication plugin.
Can you first try running: sudo mariadb -u root
with the server running and see if you get access?
If this doesn't work, stop mariadbd and restart the server with --skip-grant-tables option. This will make the server accept any incoming connection. Make sure the server can not be accessed from the outside.
Login to the server and run select * from mysql.global_priv table. This will help in understanding what sort of authentication setup you have for your server and we can then debug further.
I just tried …
But --skip-grant-tables option doesn't help very much.
You can enter and see the problem, but you can't fix it:
All GRANT statements are forbidden while mariadb is running with this option.