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进程。重新启动