P4D

  • HW: Raspberry Pi 3
  • OS: Arch Linux ARM

[root@p4d linux-p4d]# systemctl start mariadb [root@p4d linux-p4d]# mysql -u root -Dmysql -p Enter password: Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A

Welcome to the MariaDB monitor. Commands end with ; or \g. Your MariaDB connection id is 3 Server version: 10.5.9-MariaDB Arch Linux

Copyright © 2000, 2018, Oracle, MariaDB Corporation Ab and others.

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

MariaDB [mysql]> CREATE DATABASE p4 charset utf8; Query OK, 1 row affected (0.001 sec)

MariaDB [mysql]> CREATE USER 'p4'@'localhost' IDENTIFIED BY 'p4'; Query OK, 0 rows affected (0.008 sec)

MariaDB [mysql]> GRANT ALL PRIVILEGES ON p4.* TO 'p4'@'localhost' IDENTIFIED BY 'p4'; Query OK, 0 rows affected (0.006 sec)

MariaDB [mysql]> flush privileges; Query OK, 0 rows affected (0.003 sec)

MariaDB [mysql]> exit Bye [root@p4d linux-p4d]# systemctl start p4d