Forum Debian Users Gang

sudo -u mysql bash

/usr/sbin/mysqld --defaults-file=/etc/mysql/my.cnf

mysql -h {AA.BB.CC.DD} -u root -p

{AA.BB.CC.DD}

mysql -h 127.0.0.1 -u root -p
Enter password: 
Welcome to the MariaDB monitor.  Commands end with ; or \g.
Your MariaDB connection id is 19
Server version: 10.1.34-MariaDB Gentoo Linux mariadb-10.1.34

Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

MariaDB [(none)]> status
--------------
mysql  Ver 15.1 Distrib 10.1.34-MariaDB, for Linux (x86_64) using readline 7.0

Connection id:        19
Current database:    
Current user:        root@localhost
SSL:            Cipher in use is DHE-RSA-AES256-SHA
Current pager:        /usr/bin/less
Using outfile:        ''
Using delimiter:    ;
Server:            MariaDB
Server version:        10.1.34-MariaDB Gentoo Linux mariadb-10.1.34
Protocol version:    10
Connection:        127.0.0.1 via TCP/IP
Server characterset:    utf8mb4
Db     characterset:    utf8mb4
Client characterset:    utf8mb4
Conn.  characterset:    utf8mb4
TCP port:        3306
Uptime:            18 min 58 sec

Threads: 8  Questions: 3292  Slow queries: 0  Opens: 3563  Flush tables: 1  Open tables: 6  Queries per second avg: 2.892

Note that you are running in safe_update_mode:
UPDATEs and DELETEs that don't use a key in the WHERE clause are not allowed.
(One can force an UPDATE/DELETE by adding LIMIT # at the end of the command.)
SELECT has an automatic 'LIMIT 1000' if LIMIT is not used.
Max number of examined row combination in a join is set to: 1000000

--------------

MariaDB [(none)]>

SELECT User, Host FROM mysql.user;

ERROR 1045 (28000): Access denied for user 'root'@'192.168.0.10' (using password: YES)

MariaDB [(none)]> show grants for root@'%';
+--------------------------------------------------------------------------------------------------------------------------------------------+
| Grants for root@%                                                                                                                          |
+--------------------------------------------------------------------------------------------------------------------------------------------+
| GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY PASSWORD '*XXXXXXXXXXXXXXXXXXXXXXXX' REQUIRE SSL WITH GRANT OPTION |
+--------------------------------------------------------------------------------------------------------------------------------------------+
1 row in set (0.00 sec)