mysql8.0.33-1.el7.x86_64.rpm-bundle搭建

目录

1、修改句柄数，文件最后增加

2,centos安装

3,我们需要将系统自带的mariadb-lib卸载

4,创建mysql用户

5,上传mysql-8.0.33-1.el7.x86_64.rpm-bundle.tar并解压

6.创建安装目录及权限

7,编辑配置文件

8,数据库初始化

9,启动并修改默认密码

10,如果需要其他机器远程访问，创建用户并赋权限：

11,设置mysql开机自启动

12,查看状态

---

1、修改句柄数，文件最后增加

vim /etc/security/limits.conf
#set paste

* soft nofile 102400
* hard nofile 102400

* soft nproc 65535
* hard nproc 65535

* hard  memlock 2048 
* soft  memlock 2048 

2,centos安装

yum install -y gcc gcc-c++ vim zip unzip net-tools lrzsz wget 
reboot

3,我们需要将系统自带的mariadb-lib卸载

rpm -qa | grep -i mariadb
rpm -e --nodeps mariadb-libs-5.5.56-2.el7.x86_64

4,创建mysql用户

groupadd mysql
useradd -g mysql -m mysql -s /bin/false

5,上传mysql-8.0.33-1.el7.x86_64.rpm-bundle.tar并解压

cd /export/mysql

tar -xvf mysql-8.0.33-1.el7.x86_64.rpm-bundle.tar

rpm -ivh mysql-community-common-8.0.33-1.el7.x86_64.rpm
rpm -ivh mysql-community-client-plugins-8.0.33-1.el7.x86_64.rpm
rpm -ivh mysql-community-libs-8.0.33-1.el7.x86_64.rpm 
rpm -ivh mysql-community-client-8.0.33-1.el7.x86_64.rpm
rpm -ivh mysql-community-icu-data-files-8.0.33-1.el7.x86_64.rpm 
rpm -ivh mysql-community-server-8.0.33-1.el7.x86_64.rpm

6.创建安装目录及权限

mkdir -p /data/mysql/data
chown mysql:mysql /data/mysql/
chown mysql:mysql /data/mysql/data
chmod 777 -R /data/mysql/
chmod -R 777 /var/run/mysqld

7,编辑配置文件

vim /etc/my.cnf
#set paste

[client] 
default-character-set = utf8mb4

[mysql] 
default-character-set = utf8mb4

[mysqld] 
character-set-client-handshake = FALSE 
character-set-server = utf8mb4
collation-server = utf8mb4_bin 
init_connect='SET NAMES utf8mb4'

datadir=/data/mysql/data
socket=/var/lib/mysql/mysql.sock

symbolic-links=0
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid

server-id=1
default-time-zone='+08:00' 
lower_case_table_names=1
transaction_isolation=READ-COMMITTED
skip-name-resolve
expire_logs_days=3

max_connections = 1250
max_user_connections=1000
max_connect_errors=100000

key_buffer_size = 256M
max_allowed_packet = 16M
table_open_cache = 512

log-bin=mysql-bin
binlog_format = ROW
slow-query-log=1
long_query_time =1
slow-query-log-file=/data/mysql/mysqld-slow.log

#log-queries-not-using-indexes

join_buffer_size = 1M
read_buffer_size = 4M
read_rnd_buffer_size = 8M

innodb_buffer_pool_size = 2G
innodb_autoextend_increment = 64M
innodb_log_buffer_size = 8M
innodb_log_file_size = 512M
innodb_log_files_in_group = 3

innodb_flush_log_at_trx_commit = 1
innodb_max_dirty_pages_pct = 70
innodb_flush_method = O_DIRECT

8,数据库初始化

mysqld --initialize --console --user=mysql

9,启动并修改默认密码

service mysqld start
grep 'temporary password' /var/log/mysqld.log
mysql -u root -p

ALTER USER 'root'@'localhost' IDENTIFIED BY '123456';
flush privileges;

10,如果需要其他机器远程访问，创建用户并赋权限：

create user root@'%' identified by '123456';
grant all privileges on *.* to root@'%' with grant option;
-- 5.7
--grant all privileges on *.* to 'root'@'%' identified by '123456' with grant option;
-- 8.0
alter user 'root'@'%' identified with mysql_native_password by '123456';
flush privileges;

11,设置mysql开机自启动

systemctl enable mysqld;

12,查看状态

systemctl status mysqld