Linux中安装mysql

yum install prel net-tools -y 安装Perl net-tools 两个软件
rpm -qa | grep mariadb
rpm -e --nodeps mariadb 卸载 mariadb
tar -xvf xxxxxxxxx.tar 解压
包安装顺序 common libs client server
systemctl start mysqld 启动mysql服务
status
cat /var/log/mysqld.log | grep passwd 查看密码
mysql -u root -p 修改权限
8.0 set globcal validate.passwd = low
set globcal validate.length = 6
5.7 set globcal validate_passwd = low
更改加密方式
ALTER VSER 'root'@'localhost' IDENTIFIED BY '123456' PASSWORD EXPIRE NEVER;
更改密码
ALTER
mysql_native_passwd BY '123456'
刷新权限
FLISH PRIVILEGES;
修改mysql链接
use mysql
update user set host='%' where user = 'root';
commit; 提交
exit; 退出
systemctl restart mysqld
使用 Navicat 连接mysql