linux系统下mysql 5.7详细安装

安装mysql5.7详细操作按着步骤来不出问题

1.wget https://dev.mysql.com/get/mysql57-community-release-el7-9.noarch.rpm
2.rpm -ivh mysql57-community-release-el7-9.noarch.rpm
3.cd /etc/yum.repos.d/
4.yum install mysql-server
5.等待安装 进入vim /etc/my.cnf
[mysqld]

character_set_server=utf8

init_connect=‘SET NAMES utf8’

#skip-grant-tables

skip-name-resolve

sql_mode = STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION

wait_timeout=31536000

interactive_timeout=31536000

max_connections=2000
替换，#skip-grant-tables，注释解开，修改完密码在进行注释。
6.systemctl start mysqld 启动
grep ‘temporary password’ /var/log/mysqld.log 查看密码
mysql -uroot -p 登录mysql
update user set host=’%’ where user=‘root’;
flush privileges;
GRANT ALL PRIVILEGES ON . TO ‘root’@’%’ IDENTIFIED BY ‘root’ WITH GRANT OPTION; 修改账号密码