mysql -u root - h command is giving error of TLS and when trying to do with utility mysql_ssl_rsa_setup --uid=mysql than this command is not found.
┌──(root㉿kali)-[/var/lib/mysql]
└─# mysql -u root -h 10.0.2.5
ERROR 2026 (HY000): TLS/SSL error: wrong version number
MariaDB [(none)]> SHOW VARIABLES LIKE '%ssl%';
+---------------------+----------------------------+
| Variable_name | Value |
+---------------------+----------------------------+
| have_openssl | YES |
| have_ssl | DISABLED |
| ssl_ca | |
| ssl_capath | |
| ssl_cert | |
| ssl_cipher | |
| ssl_crl | |
| ssl_crlpath | |
| ssl_key | |
| version_ssl_library | OpenSSL 3.0.11 19 Sep 2023 |
+---------------------+--------------------------
# systemctl status mysql
● mariadb.service - MariaDB 10.11.6 database server
Loaded: loaded (/lib/systemd/system/mariadb.service; disabled; preset: disabled)
Active: active (running) since Wed 2023-12-20 07:02:19 EST; 17min ago
Docs: man:mariadbd(8)
https://mariadb.com/kb/en/library/systemd/
Process: 169186 ExecStartPre=/usr/bin/install -m 755 -o mysql -g root -d /var/run/mysqld (code=exited, status=0/SUCCES>
Process: 169187 ExecStartPre=/bin/sh -c systemctl unset-environment WSREPSTART_POSITION (code=exited, status=0/SUCCE>
Process: 169190 ExecStartPre=/bin/sh -c [ ! -e /usr/bin/galera_recovery ] && VAR= || VAR=`cd /usr/bin/..; /usr/bin/g>
Process: 169271 ExecStartPost=/bin/sh -c systemctl unset-environment WSREPSTART_POSITION (code=exited, status=0/SUCC>
Process: 169273 ExecStartPost=/etc/mysql/debian-start (code=exited, status=0/SUCCESS)
Main PID: 169250 (mariadbd)
Status: "Taking your SQL requests now..."
Tasks: 8 (limit: 4598)
Memory: 214.7M
CPU: 2.012s
CGroup: /system.slice/mariadb.service
└─169250 /usr/sbin/mariadbd
Dec 20 07:02:19 kali mariadbd[169250]: 2023-12-20 7:02:19 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_>
Dec 20 07:02:19 kali mariadbd[169250]: 2023-12-20 7:02:19 0 [Warning] You need to use --log-bin to make --expire-logs-day>
Dec 20 07:02:19 kali mariadbd[169250]: 2023-12-20 7:02:19 0 [Note] InnoDB: Buffer pool(s) load completed at 231220 7:02:>
Dec 20 07:02:19 kali mariadbd[169250]: 2023-12-20 7:02:19 0 [Note] Server socket created on IP: '127.0.0.1'.
Dec 20 07:02:19 kali mariadbd[169250]: 2023-12-20 7:02:19 0 [Note] /usr/sbin/mariadbd: ready for connections.
Dec 20 07:02:19 kali mariadbd[169250]: Version: '10.11.6-MariaDB-1' socket: '/run/mysqld/mysqld.sock' port: 3306 Debian>
Dec 20 07:02:19 kali systemd[1]: Started mariadb.service - MariaDB 10.11.6 database server.
Dec 20 07:02:19 kali /etc/mysql/debian-start[169277]: Upgrading MariaDB tables if necessary.
lines 1-26