1、安装
sudo apt-get install mariadb-server
2、连接
sudo mysql
3、设置root密码、开启远程访问
(1)设置root密码
use mysql; UPDATE user SET password=password('password') WHERE user='root'; UPDATE user SET plugin='mysql_native_password' WHERE user = 'root'; flush privileges;
(2)开启远程访问
use mysql; GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'password' WITH GRANT OPTION; flush privileges;
sudo nano /etc/mysql/mariadb.conf.d/50-server.cnf 注释 # bind-address = 127.0.0.1
4、重启
sudo systemctl restart mariadb