PS:centos7.6自带的类mysql数据库是mariadb,会跟mysql冲突,要先删除。
rpm -ivh mysql-community-common-5.7.26-1.el7.x86_64.rpm rpm -ivh mysql-community-libs-5.7.26-1.el7.x86_64.rpm rpm -ivh mysql-community-client-5.7.26-1.el7.x86_64.rpm rpm -ivh mysql-community-server-5.7.26-1.el7.x86_64.rpm
Mysql自动给root用户设置随机密码,运行grep "password" /var/log/mysqld.log可看到当前密码
mysql> use mysql; ERROR 1820 (HY000): You must reset your password using ALTER USER statement before executing this statement.
set global validate_password_policy=0; 提示密码设置策略 (validate_password_policy默认值1,) 【 密码的长度是由validate_password_length决定的,但是可以通过以下命令修改 set global validate_password_length=4; 】
|
设置mysql远程访问
# 授权远程用户登录 %表示任意地址,也可以指定IP
grant all privileges on *.* to root@'%' identified by 'root';
# 重载授权表
flush privileges;
设置端口放行
firewall-cmd --permanent --add-port=3306/tcp
firewall-cmd --reload
安装包在这
链接:https://pan.baidu.com/s/1jvZkxa0IqxZV9ma3DHb_Ww?pwd=aaaa
提取码:aaaa
--来自百度网盘超级会员V2的分享