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
得到临时密码: 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
service start mysql #启动服务
#登入mysql 服务器,修改root密码
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'@'%';
6、配置mysql环境变量
vi /etc/profile ,在最后加上
export MYSQL_HOME=/usr/local/mysql
export PATH=$PATH:$MYSQL_HOME/bin
保存退出, source /etc/profile 使之立即生效。