树莓派4 配置mariadb远程连接

一、安装

apt-get install mariadb-server

配置密码访问

use mysql; 
UPDATE user SET password=password('密码') WHERE user='root'; 
UPDATE user SET plugin='mysql_native_password' WHERE user = 'root'; 
flush privileges; 
exit 

以上执行完成后，重启服务

systemctl restart mariadb 

重启完成后，试用密码进行mariadb登录，验证是否修改成功

mysql -u root -ptiantian

二、远程访问

1.数据库的设置

命令1：

GRANT ALL PRIVILEGES ON *.* TO ‘root‘@‘%‘ IDENTIFIED BY ‘密码‘ WITH GRANT OPTION;
(命令中的123456就是远程访问时的密码)
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY '密码' WITH GRANT OPTION;

命令2：

flush privileges;

2、注释bind-address = 127.0.0.1

vim /etc/mysql/mariadb.conf.d/50-server.cnf
--------------------------
# bind-address = 127.0.0.1   -->注释
----------------------------

systemctl restart mariadb 

netstat -an | grep 3306
---------------------------------
tcp6    0  0 :::3306  :::*    LISTEN
------------------------------------

如果远程还无法访问，那就开启3306端口

命令1：iptables -I INPUT -p tcp --dport 3306 -j ACCEPT

命令2：service iptables save

命令3：service iptables restart