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 _______________________________________________ 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
