$ cat ~/.my-server.cnf
|
|
[mariadb-client.bob]
|
socket=/tmp/mysql.sock
|
user=test
|
password=testpass
|
|
$ mysqladmin --defaults-file=/home/dan/.my-server.cnf --defaults-group-suffix=.bob --protocol tcp ping
|
mysqladmin: connect to server at 'localhost' failed
|
error: 'Access denied for user 'dan'@'localhost''
|
|
$ mysql --defaults-file=/home/dan/.my-server.cnf --defaults-group-suffix=.bob --protocol tcp -e 'select current_user()'
|
+----------------+
|
| current_user() |
|
+----------------+
|
| test@% |
|
+----------------+
|
|
$ sed -i -e '/socket/d' ~/.my-server.cnf
|
|
$ cat ~/.my-server.cnf
|
|
[mariadb-client.bob]
|
user=test
|
password=testpass
|
|
$ mysqladmin --defaults-file=/home/dan/.my-server.cnf --defaults-group-suffix=.bob --protocol tcp ping
|
mysqladmin: connect to server at 'localhost' failed
|
error: 'Access denied for user 'dan'@'localhost''
|
|
$ mysqladmin --defaults-file=/home/dan/.my-server.cnf --defaults-group-suffix=.bob --protocol tcp --host 127.0.0.1 ping
|
mysqladmin: connect to server at '127.0.0.1' failed
|
error: 'Access denied for user 'dan'@'localhost''
|
|
$ mysqladmin --defaults-file=/home/dan/.my-server.cnf --defaults-group-suffix=.bob ping
|
mysqld is alive
|
|
$ mysqladmin --defaults-file=/home/dan/.my-server.cnf --defaults-group-suffix=.bob --protocol tcp --user test -ptestpass ping
|
mysqld is alive
|