一。.MySQL版本:
mysql-8.0.14-el7-x86_64.tar
二。安装说明
1.解压的位置:/var/local/
2.解压后重新命名
mv /var/local/mysql/-8.0.14-el7-x86_64 /var/local/mysql |
3.安装完后需要手动配置mysql的环境变量
三。安装步骤
1). 解压
tar -zxvf tar -zxvf mysql-8.0.14-el7-x86_64.tar.gz -C /var/local/ |
2).创建 mysql 用户及组
groupadd mysql 查看是否创建成功 id mysql |
3).修改mysql 解压后的文件及目录的所属组及所属者
chown -R mysql:mysql /var/local/mysql |
4).创建 /tmp/mysql 目录
mkdir /tmp/mysql 给 /tmp/mysql 目录权限 chown -R mysql:mysql /tmp/mysql |
5).编写 /etc/my.cnf 文件
[client] port=3306 socket=/tmp/mysql/mysql.sock [mysqld] port=3306 user=mysql socket=/tmp/mysql/mysql.sock basedir=/usr/local/mysql datadir=/usr/local/mysql/data log=access.log |
6).初始化mysql
/var/local/mysql/bin/mysqld --initialize --user=mysql --basedir=/var/local/mysql/ --datadir=/var/local/mysql/data/ |
7).查看root密码
密码在 /var/local/mysql/data/access.log中 或者使用:cat var/local/mysql/data/access.log | cut -d ":" -f 4 |
8).启动mysql服务
/var/local/mysql/support-files/mysql.server start |
9).登录mysql
/var/local/mysql/bin/mysqld -u root -p 密码 |
10).修改root密码
ALTER USER 'root'@'localhost' IDENTIFIED BY 'root'; FLUSH PRIVILEGES; |
11).添加到系统服务自动启动
cd 到mysql安装文件夹目录,设置权限 cp -a /var/local/mysql/support-files/mysql.server /etc/init.d/mysqld chmod +x /etc/rc.d/init.d/mysqld chkconfig --add mysqld
检查一下服务是否生效 chkconfig --list
出现以下内容说明配置成功 |
四。问题
1.MySQL 1130错误,无法远程连接 (https://www.cnblogs.com/devan/p/7055339.html)
mysql>select 'host' from user where user='root'; mysql>update user set host = '%' where user ='root'; mysql>flush privileges; mysql>select 'host' from user where user='root'; |
2.Unable to load authentication plugin 'caching_sha2_password'.(https://blog.csdn.net/u010026255/article/details/80062153)
处理方式:(@后面是localhost还是%可以通过上一步确定)
ALTER USER 'root'@'localhost' IDENTIFIED BY 'password' PASSWORD EXPIRE NEVER; #修改加密规则 FLUSH PRIVILEGES; #刷新权限 |