MySQL8.0.11安装并使用systemctl控制

（如果是centos7，会有默认的mariadb，先进行卸载）

rpm -qa | grep mariadb
yum remove mariadb-libs.x86_64

1.下载安装包

官网地址：https://downloads.mysql.com/archives/community/

cd /usr/local/src
wget https://dev.mysql.com/get/Downloads/MySQL-8.0/mysql-8.0.11-linux-glibc2.12-x86_64.tar.gz

2.解压

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

3.将解压的目录重命名放置到 /usr/local/mysql

mv /usr/local/src/mysql-8.0.11-linux-glibc2.12-x86_64 /usr/local/mysql

4.检查mysql组和用户是否存在，如没有创建，

cat /etc/group | grep mysql

cat /etc/passwd | grep mysql

#创建用户组
groupadd mysql  

#创建用户
useradd -g mysql mysql

#设置密码
passwd mysql

5.进入mysql目录并创建data目录

cd mysql 
mkdir data

6.赋权限给相关目录

chown -R mysql.mysql /usr/local/mysql

7.切换进mysql目录下

cd /usr/local/mysql/

8.进行初始化操作，记录初始化密码 ，后面登录用到

 ./bin/mysqld --user=mysql --basedir=/usr/local/mysql/ --datadir=/usr/local/mysql/data/ --initialize

（可能报错  ：error while loading shared libraries: libaio.so.1: cannot open shared object file: No such file or directory） .

yum install -y libaio

9.配置my.cnf

vi /etc/my.cnf

添加如下配置

[mysqld]
basedir=/usr/local/mysql
datadir=/usr/local/mysql/data
socket=/tmp/mysql.sock
port=3306
default_authentication_plugin=mysql_native_password

 

10.为MySQL设置环境变量

vi /etc/profile

最后一行添加

export PATH=$PATH:/usr/local/mysql/bin

 重新载入

source /etc/profile 

11.设置为开机自启动项，依次执行下面代码

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

chmod +x /etc/init.d/mysql #添加可执行权限。

chkconfig --add mysql # 注册启动服务

chkconfig --list #查看是否添加成功。

12.启动mysql服务

systemctl start mysql

 13.进入mysql

 mysql -u root -p

14.修改密码

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

15.远程连接配置

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