centos7安装mysql8 (原创)

centos7安装mysql8

1、下载包

官网下载
https://dev.mysql.com/downloads/mysql/
选择oracle linux7 x86_64 ，下载包：mysql-8.0.21-el7-x86_64.tar.gz



2、卸载原mariadb软件包 
rpm -qa | grep mariadb
rpm -e  mariadb-libs-5.5.60-1.el7_5.x86_64  --nodeps  #rpm卸载mariadb包
 


3、创建mysql用户

groupadd mysql
useradd -g  mysql mysql  -s /sbin/nologin -d /usr/local/mysql
chown -R mysql:mysql  /usr/local/mysql  



4、解压安装mysql
将mysql-8.0.21-el7-x86_64.tar.gz包上传到centos服务器

#解压
tar -zxvf  mysql-8.0.21-el7-x86_64.tar.gz

#移动目录并重命名
mv  mysql-8.0.21-el7-x86_64  /usr/local/mysql 

 
cd /usr/local/mysql
mkdir data

5 、初始化安装
bin/mysqld --initialize --user=mysql --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data  或者

bin/mysqld --initialize --user=mysql --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data --lower-case-table-names=1

得到临时密码： bgQpx7a*g=rx  (重要)

bin/mysql_ssl_rsa_setup --datadir=/usr/local/mysql/data


cp  -rf /usr/local/mysql/support-files/mysql.server  /etc/init.d/mysql

vi /etc/my.cnf ,内容如下
[mysqld]
character_set_server=utf8
basedir=/usr/local/mysql
datadir=/usr/local/mysql/data
port=3306
socket=/tmp/mysql.sock
server-id=1

lower_case_table_names=1
mysqlx=0



service mysql start #启动服务


mysql -u root -p 
输入临时密码登录


#修改localhost的root密码为123456
ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '123456';


#创建root@%用户，并授权所有权限
create user 'root'@'%' IDENTIFIED WITH mysql_native_password BY '123456';
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%';
GRANT ALL ON *.* TO 'root'@'%';