maria-discuss team mailing list archive

[Reindl Harald <h.reindl@xxxxxxxxxxxxx>]

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