靳闯博客 记录是一种习惯,分享是一种态度
  • 波浪
  • 波浪
  • 波浪
  • 波浪
mysql5.7 安装配置
发表于: | 分类: 技术积累 | 标签: Linux Mysql | 评论:0 | 阅读: 675

1 安装好开发环境各种依赖包

yum groupinstall "Development tools"

2 安装依赖包

yum install libaio

3 新建用户组和用户

groupadd mysql
useradd mysql -g mysql

4 建立存放数据库目录

mkdir /data

5 解压包指定目录

#源码包(慢,编译过程易出错)
wget http://download.jinchuang.org/other/linux/mysql-5.7.18.tar.gz

#二进制编译好的包(快速,不易出错)
wget http://download.jinchuang.org/other/linux/mysql-5.7.18-linux-glibc2.5-x86_64.tar.gz

# mysql-5.7.18-linux-glibc2.5-x86_64.tar.gz 这里使用编译好的二进制安装包
tar xf mysql-5.7.18-linux-glibc2.5-x86_64.tar.gz -C /data
cd /data
mv mysql-5.7.18-linux-glibc2.5-x86_64 mysql

6 安装

#创建data目录
mkdir -p /data/mysql/data

#更改所有者
chown -R mysql:mysql /data/mysql

#配置my.cnf
vim /etc/my.cnf
#----------------  配置文件开始  ------------------#
[client]
#no-beep
socket =/data/mysql/mysql.sock
# pipe
# socket=0.i0
port=3306
default-character-set=utf8mb4
[mysql]
default-character-set=utf8mb4

[mysqld]
basedir=/data/mysql
datadir=/data/mysql/data
port=7416
pid-file=/data/mysql/mysqld.pid
bind-address=0.0.0.0
#skip-grant-tables
skip-name-resolve
socket = /data/mysql/mysql.sock
default-storage-engine=INNODB
explicit_defaults_for_timestamp = true
default-time-zone = '+8:00'
#字符集
character-set-client-handshake = FALSE
character_set_filesystem = utf8mb4
character-set-server = utf8mb4
collation-server = utf8mb4_unicode_ci
init_connect = 'SET NAMES utf8mb4'
skip-character-set-client-handshake = true

# Server Id
server-id=1
log-bin = mysql-bin
max_connections=2000
table_open_cache=2000
tmp_table_size=246M
thread_cache_size=300

#logs 初始化的时候如果配置好了log,那么随机密码相关信息会写入logs中不会前台打印
general_log = ON
general_log_file = /data/mysql/logs/mysql.log
log_error = /data/mysql/logs/mysql-error.log
#slow_query_log = on
#slow-query-log-file = /data/mysql5.7/logs/slow-query.log
#long_query_time = 2

#限定用于每个数据库线程的栈大小。默认设置足以满足大多数应用
thread_stack = 192k
key_buffer_size=512M
read_buffer_size=4M
read_rnd_buffer_size=32M
innodb_data_home_dir = /data/mysql/data
innodb_flush_log_at_trx_commit=0
innodb_log_buffer_size=16M
innodb_buffer_pool_size=256M
innodb_log_file_size=256M
innodb_thread_concurrency=128
innodb_autoextend_increment=1000
innodb_buffer_pool_instances=8
innodb_concurrency_tickets=5000
innodb_old_blocks_time=1000
innodb_open_files=300
innodb_stats_on_metadata=0
innodb_file_per_table=1
innodb_checksum_algorithm=0
back_log=80
flush_time=0
join_buffer_size=128M
max_allowed_packet=1024M
max_connect_errors=2000
open_files_limit=4161
query_cache_type=0
sort_buffer_size=32M
table_definition_cache=1400
binlog_row_event_max_size=8K
sync_master_info=10000
sync_relay_log=10000
sync_relay_log_info=10000
#批量插入数据缓存大小,可以有效提高插入效率,默认为8M
bulk_insert_buffer_size = 64M
interactive_timeout = 28800
wait_timeout = 28800
log-bin-trust-function-creators=1
sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES,NO_ZERO_DATE
#----------------  配置文件结束  ------------------#


#创建日志目录和文件
mkdir -p /data/mysql/logs
touch /data/mysql/logs/mysql.log
touch /data/mysql/logs/mysql-error.log

#授权mysql写入日志权限
cd /data && chown mysql.mysql mysql/logs -R

#初始化数据库
/data/mysql/bin/mysqld --user=mysql --basedir=/data/mysql/ --datadir=/data/mysql/data --initialize
#初始化后在日志文件找到mysql生产的root随机密码
cat /data/mysql/logs/mysql-error.log
2018-11-19T06:23:33.135345Z 0 [Warning] 'NO_ZERO_DATE', 'NO_ZERO_IN_DATE' and 'ERROR_FOR_DIVISION_BY_ZERO' sql modes should be used with strict mode. They will be merged with strict mode in a future release.
2018-11-19T06:23:33.135440Z 0 [Warning] 'NO_AUTO_CREATE_USER' sql mode was not set.
 100 200
 100 200
2018-11-19T06:23:34.828434Z 0 [Warning] InnoDB: New log files created, LSN=45790
2018-11-19T06:23:34.888319Z 0 [Warning] InnoDB: Creating foreign key constraint system tables.
2018-11-19T06:23:34.948333Z 0 [Warning] No existing UUID has been found, so we assume that this is the first time that this server has been started. Generating a new UUID: a4b82a35-ebc3-11e8-adfb-0050568e526b.
2018-11-19T06:23:34.948987Z 0 [Warning] Gtid table is not ready to be used. Table 'mysql.gtid_executed' cannot be opened.
2018-11-19T06:23:34.950660Z 1 [Note] A temporary password is generated for root@localhost: E1<S.t,:_bXk
2018-11-19T06:23:35.497259Z 1 [Warning] 'user' entry 'root@localhost' ignored in --skip-name-resolve mode.
2018-11-19T06:23:35.497315Z 1 [Warning] 'user' entry 'mysql.sys@localhost' ignored in --skip-name-resolve mode.
2018-11-19T06:23:35.497342Z 1 [Warning] 'db' entry 'sys mysql.sys@localhost' ignored in --skip-name-resolve mode.
2018-11-19T06:23:35.497365Z 1 [Warning] 'proxies_priv' entry '@ root@localhost' ignored in --skip-name-resolve mode.
2018-11-19T06:23:35.497432Z 1 [Warning] 'tables_priv' entry 'sys_config mysql.sys@localhost' ignored in --skip-name-resolve mode.



#拷贝启动程序文件到/etc/init.d/下面
cp /data/mysql/support-files/mysql.server /etc/init.d/mysqld
chmod +x /etc/init.d/mysqld

#修改启动脚本文件
vim /etc/init.d/mysqld
修改mysql程序路径 为我们自定义的路径
basedir=/data/mysql
datadir=/data/mysql/data

7启动mysql

service mysqld start
[root@localhost ~]# netstat -lntp|grep mysqld
tcp        0      0 0.0.0.0:7416            0.0.0.0:*               LISTEN      24253/mysqld

8增加环境变量

vim /etc/profile
最下面加上:
export PATH=${PATH}:/data/mysql/bin

#使环境变量生效
source /etc/profile  或者 . /etc/profile

9修改root密码

mysql –uroot –p【密码为初始化数据库时给出的随机密码】

#修改密码,不然无法执行mysql相关命令操作;自MySQL 5.7开始,密码存在有效期的概念, 同时因为安全等级的问题,需要使用使用其它的方式进行设置。另一个需要注意的点是, 自5.7.6开始废弃了password()函数,同时无法设置old_password=1
mysql>SET PASSWORD = PASSWORD('root');

商业转载请联系作者获得授权,非商业转载请注明出处,谢谢合作。


如果这篇文章帮助到了你,我感到十分荣幸!

或许你不想写点什么·但我依旧在这里

icon_mrgreen.pngicon_neutral.pngicon_twisted.pngicon_arrow.pngicon_eek.pngicon_smile.pngicon_confused.pngicon_cool.pngicon_evil.pngicon_biggrin.pngicon_idea.pngicon_redface.pngicon_razz.pngicon_rolleyes.pngicon_wink.pngicon_cry.pngicon_surprised.pngicon_lol.pngicon_mad.pngicon_sad.pngicon_exclaim.pngicon_question.png2018new_aini_org.png2018new_baobao_thumb.png2018new_erha_org.png2018new_kuxiao_thumb.png2018new_yun_thumb.png2018new_hufen_thumb.png2018new_gui_org.png2018new_xiaoerbuyu_org.png2018new_heixian_thumb.png2018new_wabi_thumb.png2018new_tianping_thumb.png

站点地图 网站地图
豫ICP备17003270号 | Copyright © 2018 💖 靳闯博客
Typecho🍹Sgreen
TOP