环境
lsb_release -a
安装
apt update
apt upgrade
apt install mariadb-server
相关命令
systemctl status mysql
或者
systemctl status mariadb
systemctl start mysql
systemctl restart mysql
systemctl stop mysql
修改配置
vim /etc/mysql/mariadb.conf.d/50-server.cnf
-
注释掉一行
bind-address =127.0.0.1
systemctl restart mysql
以上操作修改MySQL服务允许其他主机访问
mysql -u root -p
输入命令后,直接按回车跳过输入密码
use mysql;
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'admin123' WITH GRANT OPTION;
我这里设置密码为
admin123
, 可以自行修改对应密码
flush privileges;
以上操作修改MySQL数据库密码
测试
测试工具:
navicat