tar -zxvf mysql-5.7.26-linux-glibc2.12-x86_64.tar.gz
mv mysql-5.7.26-linux-glibc2.12-x86_64 mysql
adduser mysql
chown mysql:mysql -R /usr/local/mysql
cd /usr/local/mysql
./bin/mysqld --user=mysql --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data --initialize
[mysqld]
port=3306
datadir=/usr/local/mysql/data
socket=/usr/local/mysql/mysql.sock
user=mysql
max_connections=100
# Disabling symbolic-links is recommended to prevent assorted security risks
symbolic-links=0
#忽略大小写
lower_case_table_names=1
#设置编码
character-set-server=utf8
collation-server=utf8_general_ci
#IP绑定
#bind-address=192.168.8.100
[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
#客户端连接设置
[client]
# 和上面要相同才行
socket=/usr/local/mysql/mysql.sock
default-character-set=utf8
./support-files/mysql.server start
cp support-files/mysql.server /etc/init.d/mysqld
vim /etc/profile
export PATH=$PATH:/usr/local/mysql/bin
source /etc/profile
alter user 'root'@'localhost' identified by 'root' ;
use mysql;
update user set user.Host='%' where user.User='root';
flush privileges;
# 1、查看暴露的端口号
iptables-save
# 2、开放端口号
firewall-cmd --zone=public --add-port=3306/tcp --permanent
# 3、重新加载
firewall-cmd --reload
