Synology NAS 配置 MariaDB 上手教程

Synology 不提供 Mysql 的安装，但提供 MariaDB，因此您可以直接安装 MariaDB。 ？运行mysql命令

如果报错，可以进入目录/usr/local/mariadb10/bin然后运行，或者进入目录

/volume1/@appstore/MariaDB10/usr/local/ mariadb10/bin.mariadb10/bin.mariadb10/bin.mariadb10/bin。

创建用于测试的数据库。

zhonglaonianoldjava@DS918plus:~$ mysql -uroot -p数据库root密码
Welcome to the MariaDB monitor.  Commands end with ; or g.
Your MariaDB connection id is 19
Server version: 10.3.32-MariaDB Source distribution

Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.

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

MariaDB [(none)]> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| mysql              |
| performance_schema |
+--------------------+
3 rows in set (0.001 sec)
MariaDB [(none)]> create database test;
Query OK, 1 row affected (0.001 sec)

MariaDB [(none)]> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| mysql              |
| performance_schema |
| test               |
+--------------------+
4 rows in set (0.001 sec)

MariaDB [(none)]> use test;
Database changed
MariaDB [test]>

3。设置数据库权限，创建新用户并将其设置为允许远程访问

在数据库中创建新用户。注意密码复杂度必须包含数字、特殊字符和大小写字母

MariaDB [test]> CREATE USER dbtestuser@'%' IDENTIFIED BY 'qqjavaold';
ERROR 1819 (HY000): Your password does not satisfy the current policy requirements: [Minimal password length 10, Include mixed case, Include numeric characters, Include special characters]
MariaDB [test]> CREATE USER dbtestuser@'%' IDENTIFIED BY 'qqjavaold&zhihu';
ERROR 1819 (HY000): Your password does not satisfy the current policy requirements: [Include mixed case, Include numeric characters]
MariaDB [test]> CREATE USER dbtestuser@'%' IDENTIFIED BY 'qqjavaold&ZH123';
Query OK, 0 rows affected (0.031 sec)
MariaDB [test]> show grants for dbtestuser;
+-----------------------------------------------------------------------------------------------------------+
| Grants for dbtestuser@%                                                                                   |
+-----------------------------------------------------------------------------------------------------------+
| GRANT USAGE ON *.* TO `dbtestuser`@`%` IDENTIFIED BY PASSWORD '*xxxxx' |
+-----------------------------------------------------------------------------------------------------------+
1 row in set (0.000 sec)

接下来我确认数据库可以远程连接，但是我还没有数据库的操作权限

所以我向用户 dbtestuser 授予了测试数据库实例

MariaDB [test]> grant all privileges on test.* to dbtestuser;
Query OK, 0 rows affected (0.001 sec)

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

MariaDB [test]> show grants for dbtestuser;
+-----------------------------------------------------------------------------------------------------------+
| Grants for dbtestuser@%                                                                                   |
+-----------------------------------------------------------------------------------------------------------+
| GRANT USAGE ON *.* TO `dbtestuser`@`%` IDENTIFIED BY PASSWORD '*EAFA6F84C1B06C49EAF78DEF26C4077952FD7944' |
| GRANT ALL PRIVILEGES ON `test`.* TO `dbtestuser`@`%`                                                      |
+-----------------------------------------------------------------------------------------------------------+
2 rows in set (0.000 sec)

4 的所有权限。可以通过Spring+JPA自动创建表进行测试