Common Tech Share

目錄表

Setting up "wp2" for DB blog3
Setting up "bb2" for DB b2
Setting up "wp2" for DB WP

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)

Setting up "wp2" for DB blog3

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)

Setting up "bb2" for DB b2

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)

Setting up "wp2" for DB WP

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)