下载链接
wget https://dev.mysql.com/get/Downloads/MySQL-8.0/mysql-8.0.11-linux-glibc2.12-x86_64.tar.gz
#解压
tar -zxvf mysql-8.0.11-linux-glibc2.12-x86_64.tar.gz
#拷贝到/usr/local
mv /usr/local/src/mysql-8.0.11-linux-glibc2.12-x86_64 /usr/local/
#修改名称
mv ./mysql-8.0.11-linux-glibc2.12-x86_64 mysql-8.0.11
#创建存放数据文件夹
mkdir /usr/local/mysql-8.0.11/data
#创建用户及用户组
groupadd mysql
useradd -g mysql mysql
#授权
chown -R mysql.mysql /usr/local/mysql
#初始化数据库(记录临时密码)
cd /usr/local/mysql/
./bin/mysqld --user=mysql --lower-case-table-names=1 --basedir=/usr/local/mysql/ --datadir=/usr/local/mysql/data/ --initialize ;
#配置my.cnf
vi /etc/my.cnf
#在[mysqld]下添加
basedir=/usr/local/mysql
datadir=/usr/local/mysql/data
socket=/tmp/mysql.sock
character-set-server=utf8
lower-case-table-names=1
#建立Mysql服务
cp -a ./support-files/mysql.server /etc/init.d/mysql
chmod +x /etc/init.d/mysql
chkconfig --add mysql
#检查服务是否生效
chkconfig --list mysql
#启动、停止、重启
service mysql start
service mysql stop
service mysql restart
#登录（使用临时密码）
mysql -uroot -p
#若出现-bash: mysqldump: 未找到命令
ln -s /usr/local/mysql-8.0.11/bin/mysql /usr/bin
#修改密码
ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'new password';
#配置远程连接
vi /etc/my.cnf
#在[mysqld]在增加
default_authentication_plugin=mysql_native_password
#修改root权限
use mysql
update user set host ='%' where user='root';
alter user 'root'@'%' identified with mysql_native_password by 'new password';
flush privileges;
