mysql8.0安裝

1.說明

  mariadb更新為 mysql8.0.11

2.47資料庫備份

  bash -x /root/backupdb/mysql_4.sh

3.47環境停止mariadb

  systemctl stop mariadb

4.備份my.cnf

 cp /etc/my.cnf    /etc/my.conf.1

5.開始安裝Mysql8.0

①解壓資料庫mv操作

mkdir  -p  /usr/local/mysql

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

②建立目錄

mkdir  -p  /usr/local/mysql/mysql8.0/socket

mkdir  -p  /usr/local/mysql/mysql8.0/pid

mkdir  -p  /usr/local/mysql/mysql8.0/data

mkdir  -p  /usr/local/mysql/mysql8.0/log

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

③配置檔案

vi /etc/my.cnf 

[client]

port=3306

socket=/usr/local/mysql/mysql8.0/socket/mysql.sock

default-character-set=utf8

[mysqld]

server-id=1

user=mysql

max_connections=1000

basedir=/usr/local/mysql/mysql8.0

datadir=/usr/local/mysql/mysql8.0/data

pid-file=/usr/local/mysql/mysql8.0/pid/mysql.pid

init-connect='SET NAMES utf8'

character-set-server=utf8

default-storage-engine=INNODB

log_error=/usr/local/mysql/mysql8.0/log/error.log

innodb_buffer_pool_size=10G

slow_query_log = ON

slow_query_log_file=/usr/local/mysql/mysql8.0/log/slowlog.log

long_query_time = 1

default_authentication_plugin=mysql_native_password

④編譯安裝

cd /usr/local/mysql/mysql8.0

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

⑤配置啟動

cp -a ./support-files/mysql.server /etc/init.d/mysql

chmod +x   /etc/init.d/mysql

⑥修改密碼

skip-grant-tables = 1  ###添加入配置檔案 然後重新開機

flush privileges

ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '123456';

use mysql;

update user  set   host='%'  where user='root'  and host='localhost';

flush  privileges;

skip-grant-tables = 1  ###删除配置 然後重新開機

已經建立完畢:
create database member;          
CREATE USER 'user01'@'192.168.10.%' IDENTIFIED BY '123456';
GRANT ALL PRIVILEGES ON member.* TO 'user01'@'192.168.10.%';   
flush privileges;