On 05/15/2018 12:09 PM, Kenneth Penza wrote:
/opt/mariadb/bin/mysqladmin  --defaults-file=/opt/mariadb-data/my.cnf  -uroot -p version
I tried to call it with mariadb user instead of root so I get this result:

# /opt/mariadb/bin/mysqladmin  --defaults-file=/opt/mariadb-data/my.cnf  -umariadb -p version
Enter password: 
/opt/mariadb/bin/mysqladmin  Ver 9.1 Distrib 10.2.14-MariaDB, for Linux on x86_64
Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.
Server version        10.2.14-MariaDB-log
Protocol version    10
Connection        Localhost via UNIX socket
UNIX socket        /opt/mariadb-data/mariadb.sock
Uptime:            5 min 2 sec
Threads: 8  Questions: 1  Slow queries: 0  Opens: 17  Flush tables: 1  Open tables: 11  Queries per second avg: 0.003


/opt/mariadb/bin/mysqladmin  --defaults-file=/opt/mariadb-data/my.cnf  -uroot -p shutdown 
# /opt/mariadb/bin/mysqladmin  --defaults-file=/opt/mariadb-data/my.cnf  -umariadb -p shutdown
Enter password: 
/opt/mariadb/bin/mysqladmin: shutdown failed; error: 'Access denied; you need (at least one of) the SHUTDOWN privilege(s) for this operation'

-- 
Best Regards,
Muhammad Bashir Al-Noimi
Skype+Telegram+GMail: mbnoimi