wget https://dev.mysql.com/get/mysql57-community-release-el7-11.noarch.rpm 下载mysql57.rpm
yum localinstall -y mysql57-community-release-el7-11.noarch.rpm 安装Mysql源文件
yum repolist enabled | grep "mysql.*-community.*" 查看Mysql源是否安装成功
yum install -y mysql-community-server 安装Mysql服务
systemctl start mysqld.service 启动mysql服务
grep 'temporary password' /var/log/mysqld.log 获取mysql临时密码
mysql -uroot -p 登录mysql MysqlLPZ123
关闭Mysql密码校验规则,允许设置简单密码 Mysql(my.ini)配置文件最后加入:validate_password = off
alter user 'root'@'localhost' identified by 'Mysql666!'; 修改密码
-- 创建用户、密码及权限范围 第一个 root为用户名 @后为适用的主机,‘%’表示所有电脑都可以访问连接,第二个 root 为密码
GRANT ALL PRIVILEGES ON *.* TO 'root'@'192.168.0.2' IDENTIFIED BY 'root' WITH GRANT OPTION;
flush privileges; -- 立即生效