群晖使用Navicat链接MariaDB套件维护数据库原创教程

群晖没有提供Mysql的安装，但是提供了MariaDB，所以直接安装MariaDB即可。

1.安装官方套件MariaDB

文章源自玩技e族-https://www.playezu.com/807804.html

2.设置好端口和root密码

3.ssh进入群晖

4.登录mysql帐号密码

mysql -uroot -p数据库root密码

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]>

5.更改用户权限并刷新

其中root为远程登录账户 password 为密码  第一句赋予了远程账户root所有权限。 第二句是刷新权限。文章源自玩技e族-https://www.playezu.com/807804.html

提示：上面的password需要自行自定义设置否则会提示至少需要10个字符才可以。文章源自玩技e族-https://www.playezu.com/807804.html

6.使用工具链接Navicat

新建链接数据库类型选择MariaDB文章源自玩技e族-https://www.playezu.com/807804.html

文章源自玩技e族-https://www.playezu.com/807804.html

7.外网访问

请直接路由器端进行DDNS端口映射即可访问。文章源自玩技e族-https://www.playezu.com/807804.html 文章源自玩技e族-https://www.playezu.com/807804.html