第一步下载
https://dev.mysql.com/downloads/mysql/
第二步上传到服务器
tar -zxvf mysql-8.0.13-el7-x86_64.tar.gz
cd mysql-8.0.13-el7-x86_64
mv mysql-8.0.13-el7-x86_64 mysql8.0.13_x64
第三步 创建 mysql 用户组和 mysql 用户
groupadd mysql
useradd -g mysql mysql
第四步 改变 mysql 目录权限
chown -R mysql.mysql /usr/local/ mysql8.0.13_x64/
第五步 mysql配置
[mysql]
default-character-set=utf8mb4
socket=/var/lib/mysql/mysql.sock
[client]
default-character-set=utf8mb4
socket=/var/lib/mysql/mysql.sock
[mysqld]
user=mysql
skip-name-resolve
server-id=1
port=3306
lower_case_table_names=1
socket=/var/lib/mysql/mysql.sock
basedir=/usr/local/mysql-8.0.13_x64
datadir=/usr/local/mysql-8.0.13_x64/data
max_connections=800
character-set-server=utf8mb4
default-storage-engine=INNODB
max_allowed_packet=16M
innodb_buffer_pool_size=1G
innodb_flush_log_at_trx_commit=2
binlog_format=MIXED
log-bin=/usr/local/mysql-8.0.13_x64/logs/binlog/mysql-log
binlog-ignore-db=mysql
default_authentication_plugin=mysql_native_password
sql_mode=STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION
第六步 执行 ./mysqld –initialize-insecure 默认空密码
出现以下错误
需要安装 libnuma
yum install libnuma
yum -y install numactl
yum install libaio1 libaio-dev
./mysqld: error while loading shared libraries: libaio.so.1: cannot open shared object file: No such file or directory
第七步建立MySQL服务
cp -a ./support-files/mysql.server /etc/init.d/mysqld chmod +x /etc/rc.d/init.d/mysqld chkconfig --add mysqld
可以检查一下服务是否生效
chkconfig --list
第八步 配置全局环境
vi /etc/profileexport MYSQL_HOME=/usr/local/mysql-8.0.13_x64
PATH=$MYSQL_HOME/bin:$PATH
export PATH
保存退出,使环境变量生效
source /etc/profile
第九步 启动mysql服务,关闭和重启
service mysqld startservice mysqld stop service mysqld restart
第十步
修改密码
ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '你的密码';
mysql>update user set host='%' where user='root' limit 1;
// 刷新权限
mysql>flush privileges;
然后检查3306端口是否开放
netstat -nupl|grep 3306
开放3306端口
firewall -cmd --permanent --add-prot=3306/tcp
重启防火墙
firewall -cmd --reload
错误一
把share/english下面的errmsg.sys复制到share目录下面