05-11 19:16 [root@kiosk430 ~]# systemctl status mysqld
● mysqld.service - MySQL database server
Loaded: loaded (/usr/lib/systemd/system/mysqld.service; enabled; vendor preset: disabled)
Active: active (running) since Tue 2021-05-11 19:08:42 CST; 8min ago
Process: 129042 ExecStartPre=/usr/sbin/mysqld-prepare-db-dir (code=exited, status=0/SUCCESS)
Main PID: 129056 (mysqld)
Status: "Taking your SQL requests now..."
Tasks: 10 (limit: 76993)
Memory: 42.7M
CPU: 299ms
CGroup: /system.slice/mysqld.service
└─129056 /usr/sbin/mysqld
5月 11 19:08:42 kiosk430 mysqld[129056]: 2021-05-11 19:08:42 0 [Note] /usr/sbin/mysqld: ready for connections.
5月 11 19:08:42 kiosk430 mysqld[129056]: Version: '10.5.8-MariaDB' socket: '/var/lib/mysql/mysql.sock' port: 0 Mageia MariaDB Server
5月 11 19:08:42 kiosk430 systemd[1]: Started MySQL database server.
5月 11 19:08:49 kiosk430 mysqld[129056]: 2021-05-11 19:08:49 3 [Warning] Access denied for user 'b2'@'localhost' (using password: YES)
5月 11 19:09:42 kiosk430 mysqld[129056]: 2021-05-11 19:09:42 4 [Warning] Access denied for user 'wp'@'localhost' (using password: YES)
5月 11 19:11:42 kiosk430 mysqld[129056]: 2021-05-11 19:11:42 5 [Warning] Access denied for user 'wp'@'localhost' (using password: YES)
5月 11 19:12:29 kiosk430 mysqld[129056]: 2021-05-11 19:12:29 6 [Warning] Access denied for user 'b2'@'localhost' (using password: YES)
5月 11 19:12:31 kiosk430 mysqld[129056]: 2021-05-11 19:12:31 7 [Warning] Access denied for user 'b2'@'localhost' (using password: YES)
5月 11 19:13:42 kiosk430 mysqld[129056]: 2021-05-11 19:13:42 8 [Warning] Access denied for user 'wp'@'localhost' (using password: YES)
5月 11 19:15:42 kiosk430 mysqld[129056]: 2021-05-11 19:15:42 9 [Warning] Access denied for user 'wp'@'localhost' (using password: YES)
MariaDB [(none)]> CREATE USER 'wp2'@'localhost' IDENTIFIED BY 'wordpress';
Query OK, 0 rows affected (0.036 sec)
MariaDB [(none)]> GRANT ALL PRIVILEGES ON blog3.* TO 'wp2'@'localhost';
Query OK, 0 rows affected (0.017 sec)
MariaDB [(none)]> FLUSH PRIVILEGES;
Query OK, 0 rows affected (0.001 sec)
MariaDB [(none)]> CREATE USER 'b22'@'localhost' IDENTIFIED BY 'wordpress';
Query OK, 0 rows affected (0.021 sec)
MariaDB [(none)]> GRANT ALL PRIVILEGES ON b2.* TO 'b22'@'localhost';
Query OK, 0 rows affected (0.020 sec)
MariaDB [(none)]> FLUSH PRIVILEGES;
Query OK, 0 rows affected (0.001 sec)
MariaDB [(none)]> GRANT ALL PRIVILEGES ON WP.* TO 'wp2'@'localhost';
Query OK, 0 rows affected (0.016 sec)
MariaDB [(none)]> FLUSH PRIVILEGES;
Query OK, 0 rows affected (0.001 sec)