Am 15.05.2018 um 12:06 schrieb Muhammad Bashir Al-Noimi:
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
so it works and " error: 'Access denied for user 'root'@'localhost' (using password: YES)'" is what it is are you aware that 'root' on unix-socket (localhost) is not the same than 'root' over TCP (127.0.0.1) beause you have a host column? also make sure you did run 'mysql_upgrade' and if nothing else helps google for "mysql skip grant" but be aware that this allows *any* user with *any* password until removed from the config, but so you can bypass logins and fix things properly