linux下安装mysql8

1. 创建软件目录

mkdir /usr/local/soft

2. 下载mysql

没有wget：yum install wget

wget https://dev.mysql.com/get/Downloads/MySQL-8.0/mysql-8.0.20-linux-glibc2.12-x86_64.tar.xz

3. 安装mysql

移动到mysql目录：cd /usr/local/soft/mysql-8.0
1. 解压mysql ：tar -zxJf mysql-8.0.20-linux-glibc2.12-x86_64.tar.xz
2. 重命名：mv mysql-8.0.20-linux-glibc2.12-x86_64 mysql-8.0
3. 创建data文件：mkdir data
4. 创建用户组以及密码：groupadd mysql；useradd -g mysql mysql
5. 授权用户：mysqk -R mysql.mysql /usr/local/soft/mysql-8.0
6. 切换bin目录下初始化信息：./mysqld --user=mysql --basedir=/usr/local/soft/mysql-8.0 --datadir=/usr/local/soft/mysql-8.0/data/ --initialize  注意这里会得到初始密码
7. 编辑my.cnf文件，修改一下信息
	   basedir=/usr/local/soft/mysql-8.0/
       datadir=/usr/local/soft/mysql-8.0/data/
       socket=/tmp/mysql.sock
       character-set-server=UTF8MB4
       # 修改日志路径
       log-error=/usr/local/soft/mysql-8.0/logs/mysqld-error.log
       pid-file=/tmp/mysqld.pid
8. mysql服务添加到系统：cp -a ./support-files/mysql.server /etc/init.d/mysql
9. 授权以及添加服务：chmod +x /etc/init.d/mysql；chkconfig --add mysql
10. 启动服务：service mysql start 
11. 登录mysql后修改密码：ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'root'; 
12. 修改远程连接：use mysql; update user set host='%' where user='root';
13. 生效：flush privileges;