I’m trying to make MySQL Workbench discover the MySQL server running on my archlinux computer. The server is running:
[uther@uther ~]$ sudo systemctl status mysqld
[sudo] password for uther:
● mariadb.service - MariaDB 10.9.3 database server
Loaded: loaded (/usr/lib/systemd/system/mariadb.service; enabled; preset: disabled)
Active: active (running) since Sat 2022-10-22 17:07:04 WAT; 17min ago
Docs: man:mariadbd(8)
https://mariadb.com/kb/en/library/systemd/
Main PID: 4471 (mariadbd)
Status: "Taking your SQL requests now..."
Tasks: 9 (limit: 18918)
Memory: 147.2M
CPU: 414ms
CGroup: /system.slice/mariadb.service
└─4471 /usr/bin/mariadbd
Oct 22 17:07:04 uther mariadbd[4471]: 2022-10-22 17:07:04 0 [Note] Server socket created on IP: '::'.
Oct 22 17:07:04 uther mariadbd[4471]: 2022-10-22 17:07:04 0 [Note] InnoDB: Buffer pool(s) load completed at 221022 17:07:04
Oct 22 17:07:04 uther mariadbd[4471]: 2022-10-22 17:07:04 0 [Note] /usr/bin/mariadbd: ready for connections.
Oct 22 17:07:04 uther mariadbd[4471]: Version: '10.9.3-MariaDB' socket: '/run/mysqld/mysqld.sock' port: 3306 Arch Linux
Oct 22 17:07:04 uther systemd[1]: Started MariaDB 10.9.3 database server.
Oct 22 17:10:25 uther mariadbd[4471]: 2022-10-22 17:10:25 14 [Warning] Access denied for user 'testuser'@'localhost' (using password: YES)
Oct 22 17:10:30 uther mariadbd[4471]: 2022-10-22 17:10:30 15 [Warning] Access denied for user 'testuser'@'localhost' (using password: NO)
Oct 22 17:10:53 uther mariadbd[4471]: 2022-10-22 17:10:53 16 [Warning] Access denied for user 'testuser'@'localhost' (using password: YES)
Oct 22 17:11:26 uther mariadbd[4471]: 2022-10-22 17:11:26 18 [Warning] Access denied for user 'user'@'localhost' (using password: YES)
Oct 22 17:13:19 uther mariadbd[4471]: 2022-10-22 17:13:19 20 [Warning] Access denied for user '-p'@'localhost' (using password: NO)
However when I try scanning for servers in MySQL Workbench, nothing comes up as shown here.
Any help wold be appreciated. Thank you.