Mysql 8.0二进制安装

useradd mysql

tar -zxvf mysql-8.0.28-linux-glibc2.12-x86_64.tar.gz

mv mysql-8.0.28-linux-glibc2.12-x86_64 mysql

mv mysql /usr/local/
cp /usr/local/mysql/support-files/mysql.server /etc/init.d/mysqld
chown mysql:mysql /etc/init.d/mysqld
chown mysql:mysql /usr/local/mysql -R
cp /usr/local/mysql/bin/mysqld /usr/sbin/

mkdir -p /data/mysql/var/
初始化（初始化之前要把my.cnf 放到/etc/下  chown mysql:mysql /etc/my.cnf）
/usr/local/mysql/bin/mysqld --user=mysql --lower-case-table-names=1 --initialize  --datadir=/data/mysql/var

ln -s /usr/local/mysql/bin/mysql /usr/bin/

找到mysql的错误日志中的初始化密码

mysql-error.log   错误日志在my.cnf设置里面

如果默认的my.cnf初始化失败就用下面的配置替换再初始化

 

[mysqld]
datadir=/usr/local/mysql
socket=/usr/localmysql/mysql.sock

[mysql.server]
user=mysql
basedir=/usr/local

[safe_mysqld]
err-log=/usr/locallog/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid

mysql 8.0更改密码

ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '密码';