mysql8.0.28安装

1.解压
tar -xvf mysql-8.0.28-linux-glibc2.12-x86_64.tar.xz
mv mysql-8.0.28-linux-glibc2.12-x86_64 /usr/local/mysql
2.创建数据文件目录和log目录
cd /usr/local/mysql
mkdir data log
touch log/error.log
mkdir /var/lib/mysql
chown -R mysql.mysql /var/lib/mysql/
3.创建用户组和用户
groupadd mysql
useradd -g mysql mysql
4.改变mysql目录权限
chown -R mysql.mysql /usr/local/mysql
5.数据库初始化,记录临时密码：Ydw<k6lyqgkL
mysqld --user=mysql --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data --initialize --lower-case-table-names=1
6.修改配置文件（参考正式库10.44.76.62）
datadir=/usr/local/mysql/data
socket=/var/lib/mysql/mysql.sock
slow_query_log_file =/usr/local/mysql/log/mysql_query_slow.log
log-error=/usr/local/mysql/log/error.log 这个log文件要手动创建
lower_case_table_names=1 #注意 这个配置初始化之前要加号，不然后面加会启动报错
7.创建mysql服务，将mysql.server启动文件复制到/etc/init.d目录
cp -a /usr/local/mysql/support-files/mysql.server /etc/init.d/mysqld
chmod +x /etc/rc.d/init.d/mysqld
chkconfig --add mysqld && chkconfig --list mysqld #创建mysql服务
8.添加快捷方式(软连接)
ln -s /usr/local/mysql/bin/mysql /usr/bin
8.配置环境变量
vi /etc/profile
export PATH=$PATH:/usr/local/mysql/bin:/usr/local/mysql/lib
export PATH
source /etc/profile 立即生效
9.服务启动
systemctl start mysqld
10.登录mysql并修改密码
mysql -uroot -p -S /var/lib/mysql/mysql.sock
select user,host from user;
alter user 'root'@'localhost' identified with mysql_native_password by 'b8Ak1yR7';
update user set host='%' where user='root'; #设置mysql远程登录
flush privileges;