Comments - mysqladmin
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.
I have a new install of MariaDB 10.2.27 on RHEL7. Our security scans have flagged the root account, so we have modified the name to orgdba, assigning all of the applicable privileges. I have not encountered any issues, except with mysqladmin. I know I have my password correct as I can connect via mysql using it. It is only erroring on mysqladmin. I ended up creating a root account specifically to execute mysqladmin commands. I cannot execute with that account either. It is not until I create the root account using the Unix Socket plugin that I can successfully execute mysqladmin commands. I cannot find anything in any documentation that expands on this topic. I have no idea if this is a bug in the version of MariaDB that I am using. Does anyone have any insight?
Error connecting to mysqladmin:
root@db01 $ mysqladmin -uorgdba -p status Enter password: mysqladmin: connect to server at 'localhost' failed error: 'Access denied for user 'orgdba'@'localhost' (using password: YES)'
root@db01 $ mysqladmin -u orgdba -p status Enter password: mysqladmin: connect to server at 'localhost' failed error: 'Access denied for user 'orgdba'@'localhost' (using password: YES)' Same user/same password, successfully connects to mysql:
root@db01 $ mysql -u orgdba -p Enter password: Welcome to the MariaDB monitor. Commands end with ; or \g. Your MariaDB connection id is 52347 Server version: 10.2.27-MariaDB-log MariaDB Server
Copyright © 2000, 2018, Oracle, MariaDB Corporation Ab and others.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
MariaDB [(none)]> Any insight on this, or additional documentation on mysqladmin, would be appreciated.