Am 15.05.2018 um 11:49 schrieb Reindl Harald:
Am 15.05.2018 um 11:39 schrieb Muhammad Bashir Al-Noimi:
# /opt/mariadb/bin/mysqladmin --defaults-file=/opt/mariadb-data/my.cnf -uroot -p shutdown Enter password: /opt/mariadb/bin/mysqladmin: connect to server at 'localhost' failed error: 'Access denied for user 'root'@'localhost' (using password: YES)'
Strangely!!!
I passed the correct password of Ubuntu's root user!
irrelevant as you can see by "connect to server at 'localhost' failed"
/opt/mariadb/bin/mysqladmin --socket=path-to-socket
or make sure "/opt/mariadb-data/my.cnf" has a [mysqladmin] section [mysqladmin] socket = path-to-socket
in fact each tool has it's own config section in the defaults file while port is for TCP (127.0.0.1) and socket for socket-connections (localhost) [mysqld] socket = /var/lib/mysql/mysql-replication.sock port = 3307 [client] socket = /var/lib/mysql/mysql-replication.sock port = 3307 [mysqladmin] socket = /var/lib/mysql/mysql-replication.sock port = 3307