maria-discuss team mailing list archive

[Reindl Harald <h.reindl@xxxxxxxxxxxxx>]

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