Debian安装配置Mariadb指南

熟悉了MySQL后，感受一下Debian下的MairaDB的体验

#安装MariaDB的服务端
apt install -y mariadb-server
systemctl start mariadb
systemctl enable mariadb
systemctl status mariadb
#初始化设置
mysql_secure_installation
cd /etc/mysql/mariadb.conf.d
vim 50-server.cnf #修改绑定ip为0.0.0.0
#bind-address
systemctl restart mariadb
mysql -u root -p
#赋权给宿主机访问
use mysql;
grant all privileges on *.* to 'root'@'%' identified by "2465" with grant option;
flush privileges;
select user from user;