mysql8.0二進制安裝

mysql8.0二進制安裝
1.創(chuàng)建目錄授權
groupadd mysql
useradd mysql
mkdir -p /usr/local/mysql/
mkdir -p /usr/local/mysql/data
mkdir -p /usr/local/mysql/etc
mkdir -p /usr/local/mysql/log
chown -R mysql:mysql /usr/local/mysql/


2.配置參數(shù)文件：
cat > /usr/local/mysql/etc/my.cnf << EOF
[client]
port?????????????????????????? = 3306
socket???????????????????????? = /usr/local/mysql/data/mysql.sock
[mysqld]
server-id????????????????????? = 1
port?????????????????????????? = 3306
mysqlx_port??????????????????? = 33060
mysqlx_socket????????????????? = /usr/local/mysql/data/mysqlx.sock
datadir??????????????????????? = /usr/local/mysql/data
socket???????????????????????? = /usr/local/mysql/data/mysql.sock
pid-file?????????????????????? = /usr/local/mysql/data/mysqld.pid
log-error????????????????????? = error.log
slow-query-log???????????????? = 1
slow-query-log-file??????????? = slow.log
long_query_time??????????????? = 0.2
log-bin??????????????????????? = bin.log
relay-log????????????????????? = relay.log
binlog_format???????????????? =ROW
relay_log_recovery??????????? = 1
character-set-client-handshake = FALSE
character-set-server?????????? = utf8mb4
collation-server?????????????? = utf8mb4_unicode_ci
init_connect?????????????????? ='SET NAMES utf8mb4'
innodb_buffer_pool_size??????? = 1G
join_buffer_size?????????????? = 128M
sort_buffer_size?????????????? = 2M
read_rnd_buffer_size?????????? = 2M
log_timestamps???????????????? = SYSTEM
lower_case_table_names???????? = 1
default-authentication-plugin? =mysql_native_password
EOF

注意配置
[client]
socket???????????????????????? = /usr/local/mysql/data/mysql.sock

[mysqld]
socket???????????????????????? = /usr/local/mysql/data/mysql.sock


3.初始化數(shù)據(jù)庫
/usr/local/mysql/bin/mysqld? --initialize --user=mysql --basedir=/usr/local/mysql --datadir=/data/mysql
cat /usr/local/mysql/data/error.log | grep -i password



4.設置啟動文件和環(huán)境變量：
cp /usr/local/mysql/support-files/mysql.server? /etc/init.d/mysql
systemctl start mysql


5、配置用戶和密碼
mysql> show variables like '%valid%pass%';
mysql> create user root@'%' identified by 'abc123';
mysql> show variables like '%valid%pass%';
mysql> alter user root@'localhost' identified by 'abc123';
mysql> show variables like '%valid%pass%';

--創(chuàng)建可以遠程登錄的用戶：
mysql> create user root@'%' identified by 'abc123';
mysql> grant all privileges on *.* to root@'%' with grant option;
mysql> flush privileges;

# 創(chuàng)建賬號密碼
CREATE USER `root`@`127.0.0.1` IDENTIFIED BY 'shsnc\!\@\#';
CREATE USER `root`@`%` IDENTIFIED BY 'shsnc\!\@\#';

# 授予權限
GRANT ALL ON *.* TO `root`@`%` WITH GRANT OPTION;



# 刪除權限
REVOKE all privileges ON databasename.tablename FROM 'username'@'host';

# 修改密碼
ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '你的密碼';


mysql8修改密碼
清空密碼
UPDATE user SET Password = PASSWORD('shsnc!@#') WHERE user = 'root';
FLUSH privileges;

修改密碼（注意不能直接改表)
ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY "shsnc\!\@\#";
FLUSH privileges;