一、在线安装
1、更新软件源 && 更新软件
sudo apt-get update
sudo apt-get upgrade
2、安装 mariadb
sudo apt-get install mariadb-server
3、连接 mariadb
sudo mysql
4、配置 mariadb 访问密码(数据库里操作命令)
use mysql;
UPDATE mysql.user SET password=password('password') WHERE user='root';
UPDATE mysql.user SET plugin='mysql_native_password' WHERE user='root';
flush privileges;
exit
5、重启 mariadb
sudo systemctl restart mariadb
6、通过密码连接 mariadb
sudo mysql -u root -p
7、配置 mariadb 远程连接(数据库里操作命令)
use mysql;
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'password' WITH GRANT OPTION;
flush privileges;
exit
8、配置 mariadb 监听所有 IP 地址
(1)、打开“/etc/mysql/mariadb.conf.d/50-server.cnf”
nano /etc/mysql/mariadb.conf.d/50-server.cnf
(2)、注释“bind-address = 127.0.0.1”此行
# Instead of skip-networking the default is now to listen only on
# localhost which is more compatible and is not less secure.
# bind-address = 127.0.0.1
9、重启 mariadb 服务
sudo systemctl restart mariadb
二、服务操作
1、安装 mariadb 服务
sudo apt-get install mariadb-server
2、卸载 mariadb 服务
sudo apt-get autoremove --purge mariadb-server
3、启动 mariadb 服务
sudo systemctl start mariadb
4、重启 mariadb 服务
sudo systemctl restart mariadb
5、停止 mariadb 服务
sudo systemctl stop mariadb
6、查看 mariadb 服务状态
sudo systemctl status mariadb
7、设置 mariadb 服务开机自启
sudo systemctl enable mariadb
8、登录 mariadb 服务(默认没有密码)
sudo mysql
或者
sudo mysql -u root -p
9、登出 mariadb 服务
exit
10、修改 root 密码
(1)、切换数据库
use mysql;
(2)、修改密码
UPDATE user SET password=password('password') WHERE user='root';
(3) 、修改“native”插件密码
UPDATE user SET plugin='mysql_native_password' WHERE user = 'root';
(4)、刷新权限
flush privileges;
(5)、退出服务
exit
(6)、重启服务
sudo systemctl restart mariadb
(7)、密码登录
sudo mysql -u root -p