安装
//打开local文件
cd /usr/local
//建立mysql文件夹
mkdir mysql
//打开mysql文件
cd mysql
下载安装包
wget http://repo.mysql.com/mysql57-community-release-el7-8.noarch.rpm
解压并且安装
rpm -ivh mysql57-community-release-el7-8.noarch.rpm
//安装mysqlserver
sudo yum install mysql-server
启动mysql
service mysqld.service start
然后输入
sudo grep 'temporary password' /var/log/mysqld.log
下面图片中用红色方框圈住的，是第一次登录的临时密码
问题解决方案
如果找不到密码
1.删除原来安装过的mysql残留的数据（这一步非常重要，问题就出在这）
rm -rf /var/lib/mysql
2.重启mysqld服务
systemctl restart mysqld
3.再去找临时密码
grep ‘temporary password’ /var/log/mysqld.log
//使用账号的密码登录mysql
mysql -u root -p
然后修改好密码
继续登录mysql
set password=password(‘123456’);
然后会提示密码不安全。新的mysql的密码要求较高。随意简单密码通不过验证。
不过我们可以通过下面的方式取消密码复杂度的要求。
mysql> set global validate_password_policy=0; # 关闭密码复杂性策略
mysql> set global validate_password_length=1; # 设置密码复杂性要求密码最低长度为1
mysql> select @@validate_password_policy; # 查看密码复杂性策略
mysql> select @@validate_password_length; # 查看密码复杂性要求密码最低长度大小
然后在输入设置密码就成功啦！
远程连接
FLUSH PRIVILEGES;
mysql> select Host,User,Password from user;
ERROR 1054 (42S22): Unknown column ‘Password’ in ‘field list’
mysql> select Host, User from user;
±----------±--------------+
| Host | User |
±----------±--------------+
| localhost | mysql.session |
| localhost | mysql.sys |
| localhost | root |
±----------±--------------+
3 rows in set (0.00 sec)
mysql> update user set Host = '%' where User = 'root';
Query OK, 1 row affected (0.00 sec)
Rows matched: 1 Changed: 1 Warnings: 0
允许远程连接
mysql> GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' WITH GRANT OPTION;
Query OK, 0 rows affected (0.00 sec)
刷新
mysql> GRANT ALL PRIVILEGES ON . TO ‘root’@’%’ WITH GRANT OPTION;
ERROR 1819 (HY000): Your password does not satisfy the current policy requirements
执行 ```c grant all privileges on *.* to 'root'@'%' identified by '123456' with grant option;
mysql> FLUSH PRIVILEGES;
Query OK, 0 rows affected (0.00 sec)
mysql> EXIT
