Ubuntu mariadb 远程ip 访问

1、apt install mariadb 

2、

 

mariadb =

show global variables like 'port'   ##查看端口号

#设置root 密码 远程访问
grant all privileges on *.* to 'root'@'%' identified by 'root'

flush privileges

 

#修改文件：

find / -name *y.cnf

/etc/mysql/mariadb.conf.d#

#重启服务
systemctl restart mariadb

#查看防火墙
ufw status

 

systemctl start mariadb  #启动MariaDB

systemctl stop mariadb  #停止MariaDB

systemctl restart mariadb  #重启MariaDB

systemctl enable mariadb  #设置开机启动

　　

 

 

 

 

内网连接mysql慢解决办法