远程链接树莓派4B的Mariadb数据库

树莓派4B安装Mariadb

dxy@raspi:~ $sudo apt-get install mariadb-server

修改mariadb用户名密码

SET PASSWORD FOR 'mysql'@'localhost' = PASSWORD('123456');

修改host

MariaDB [mysql]> rename user 'mysql'@'localhost' to 'mysql'@'%';

查看修改情况

MariaDB [mysql]> select user,host,Password from mysql.user;
+-------------+-----------+-------------------------------------------+
| User        | Host      | Password                                  |
+-------------+-----------+-------------------------------------------+
| mariadb.sys | localhost |                                           |
| root        | localhost | *739D4EB1A83101EF0AACA07120FFB1F23D8368D0 |
| mysql       | %         | *739D4EB1A83101EF0AACA07120FFB1F23D8368D0 |
+-------------+-----------+-------------------------------------------+
3 rows in set (0.003 sec)

修改mariadb绑定的IP

dxy@raspi:~ $ vi /etc/mysql/mariadb.conf.d/50-server.cnf

bind-address          = 127.0.0.1

修改为：

bind-address          = 0.0.0.0

复位一下mariadb

systemctl restart mariadb

测试一下远程链接mariadb数据库：