linux安装mysql8.0

cd  /usr/local

#下载 
wget https://dev.mysql.com/get/Downloads/MySQL-8.0/mysql-8.0.11-linux-glib

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

mv ./mysql-8.0.11-linux-glibc2.12-x86_64 mysql8.0

#创建文件夹
cd /usr/local/mysql8.0
mkdir ./data

#新建用户组
groupadd mysql

#新建用户和密码
useradd -g mysql mysql

#授权
chown -R mysql.mysql /usr/local/mysql8.0/ 

#初始它 mysql,这里会生成初始密码。注意保存javascript:void(0)
./bin/mysqld --user=mysql --basedir=/usr/local/mysql8.0/ --datadir=/usr/local/mysql8.0/data/ --initialize 

#mysql配置
创建 /etc/my.cnf ， 添加如下参数

[mysqld]
basedir=/usr/local/mysql8.0
datadir=/usr/local/mysql8.0/data
socket=/tmp/mysql.sock
character-set-server=utf8
# 远程连接
default_authentication_plugin=mysql_native_password
#若忘记密码可以打开这个字段。重启mysql后不需要密码即可登录
#skip-grant-tables

# 增加 mysql 到系统服务中
cp -a ./support-files/mysql.server /etc/init.d/mysql

chmod +x /etc/init.d/mysql 
chkconfig --add mysql
# 检查服务是否生效  
chkconfig --list mysql

启动 mysql服务
service mysql start

#建立软连接
ln -s /usr/local/mysql8.0/bin/mysql /usr/bin

mysql -uroot -p

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

use mysql
update user set host ='%' where user='root';
ALTER USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY 'root';
FLUSH PRIVILEGES;


######end######
后记:

查看服务列表
chkconfig --list

重启mysql服务
service mysql restart

启动
service mysql start

#查看状态
service mysql status


启动mysql报错The server quit without updating PID file！

ps -ef | grep mysql

杀掉mysql进程。重新启动

 

 

参考