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 _______________________________________________ Mailing list: https://launchpad.net/~maria-discuss Post to : maria-discuss@lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-discuss More help : https://help.launchpad.net/ListHelp
