mysql5、8安装包不一样,安装方式一样
-
解压mysql安装文件
tar -xvf mysql-8.0.22-el7-x86_64.tar.gz mv mysql-8.0.22-el7-x86_64/ /data/mysql-8.0.22
-
创建mysql用户和组
groupadd mysql useradd -r -g mysql mysql
-
修改配置文件
vim /etc/my.cnf(这个文件里面内容全部删除,然后写入如下) [mysqld] socket=/tmp/mysql.sock # 设置mysql的安装目录 basedir=/data/mysql-8.0.22 # 设置mysql数据库的数据的存放目录 datadir=/data/mysql-8.0.22/data #设置mysql端口 port=3306 #开启MySQL-X协议 mysqlx_port=33060 mysqlx_socket=/var/lib/mysql-8.0.22/mysqlx.sock # 允许最大连接数 max_connections=8000 max_connect_errors=2000 max_allowed_packet=512M open_files_limit=20480 table_open_cache=8192 group_concat_max_len=1024000 #开启binlog日志 server-id=1 log-bin=/data/mysql-8.0.22/binlog/bin.log relay-log=/data/mysql-8.0.22/binlog/relay.log binlog_format=ROW relay_log_recovery=1 expire_logs_days=10 binlog_expire_logs_seconds=864000 #增加慢查询 slow-query-log=1 slow-query-log-file=/var/log/mysql-8.0.22/slow.log long_query_time=3 # 服务端使用的字符集默认为8比特编码的latin1字符集 character-set-server=utf8mb4 collation-server=utf8mb4_unicode_ci init_connect='SET NAMES utf8mb4' #设置临时表大小 tmp_table_size=828M max_heap_table_size=828M #表名存储在磁盘是小写的,但是比较的时候是不区分大小写 lower_case_table_names=1 # 创建新表时将使用的默认存储引擎,配置InnoDB缓冲池大小 default-storage-engine=INNODB #128M*的倍数 innodb_buffer_pool_size=总内存2/3-3/4(例如:innodb_buffer_pool_size=128000M) innodb_log_buffer_size=32M join_buffer_size=2M sort_buffer_size=2M read_buffer_size=2M read_rnd_buffer_size=4M bulk_insert_buffer_size=64M tmp_table_size=828M max_heap_table_size=828M log_timestamps=SYSTEM default-authentication-plugin=mysql_native_password symbolic-links=0 default-time-zone='+08:00' [mysqld_safe] log-error=/var/log/mysql-8.0.22/mysql.log pid-file=/var/run/mysql-8.0.22/mysql.pid
-
创建相关文件目录
mkdir /data/mysql-8.0.22/data mkdir /data/mysql-8.0.22/binlog mkdir /var/log/mysql-8.0.22 mkdir /var/run/mysql-8.0.22 mkdir /var/lib/mysql-8.0.22 touch /var/log/mysql-8.0.22/mysql.log chown -R mysql:mysql /data/mysql-8.0.22/data chown -R mysql:mysql /data/mysql-8.0.22/binlog chown -R mysql:mysql /var/log/mysql-8.0.22/ chown -R mysql:mysql /var/run/mysql-8.0.22/ chown -R mysql:mysql /var/lib/mysql-8.0.22/
-
初始化
./bin/mysqld --initialize --lower-case-table-names=1 --user=mysql --basedir=/data/mysql-8.0.22/ --datadir=/data/mysql-8.0.22/data/
-
加入linux服务
cp support-files/mysql.server /etc/init.d/mysqld chkconfig add mysqld service mysqld start
-
添加mysql命令
vim /root/.bash_profile PATH=$PATH:$HOME/bin:/data/mysql-8.0.22/bin
source /root/.bash_profile
如果遇见mysql/mysql.sock无效
ln -s /var/lib/mysql/mysql.sock /tmp/
-
初始化密码
alter user root@'localhost' identified by 'mtXx87668438_187_2020Q2'; CREATE USER 'root'@'%' IDENTIFIED BY 'mtXx87668438_187_2020Q2'; GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' WITH GRANT OPTION; FLUSH PRIVILEGES;
-
启动是有如下报错
error while loading shared libraries: libtinfo.so.5 解决办法
ln -s /usr/lib64/libtinfo.so.6.1 /usr/lib64/libtinfo.so.5
喜欢的亲可以关注点赞评论哦!以后每天都会更新的哦!本文为小编原创文章;
文章中用到的文件、安装包等可以加小编联系方式获得;
欢迎来交流小编联系方式VX:CXKLittleBrother
进入运维交流群