l安装mysql视频教程_mysql5.7 安装配置

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

#创建日志目录和文件

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

#配置my.cnf

vim /etc/my.cnf

#---------------- 配置文件开始 ------------------#

[client]

port=3306

socket =/data/mysql/mysql.sock

default-character-set=utf8mb4

[mysql]

socket =/data/mysql/mysql.sock

default-character-set=utf8mb4

[mysqld]

port=3306

bind-address=0.0.0.0

skip-name-resolve

basedir=/data/mysql

datadir=/data/mysql/data

pid-file=/data/mysql/mysqld.pid

socket = /data/mysql/mysql.sock

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

expire_logs_days=7

max_binlog_size = 1024M

#使用MySQL的功能相对少(存储过程、触发器、函数)Statement(默认)

#使用MySQL的特殊功能较多(存储过程、触发器、函数)则选择 Mixed 模式

#使用MySQL的特殊功能较多(存储过程、触发器、函数)又希望数据最大化一直，此时最好选择 Row 模式

#binlog_format=

log-bin-trust-function-creators=1

#最大连接数

back_log=600

max_connections=2000

max_connect_errors=2000

tmp_table_size=1024M

thread_cache_size=128

#日志 初始化的时候如果配置好了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

read_buffer_size = 8M

read_rnd_buffer_size = 8M

sort_buffer_size = 16M

table_open_cache = 2000

join_buffer_size = 32M

key_buffer_size = 256M

ft_min_word_len = 4

flush_time=0

max_allowed_packet=1024M

open_files_limit=10240

query_cache_type=0

table_definition_cache=1400

#innodb

default-storage-engine=INNODB

innodb_data_home_dir = /data/mysql/data

innodb_flush_log_at_trx_commit=1

innodb_log_buffer_size=16M

innodb_buffer_pool_size=1024M

innodb_buffer_pool_instances=1

innodb_log_file_size=256M

innodb_thread_concurrency=128

innodb_autoextend_increment=1000

innodb_concurrency_tickets=5000

innodb_old_blocks_time=1000

innodb_open_files=600

innodb_stats_on_metadata=0

innodb_file_per_table=1

innodb_checksum_algorithm=0

#批量插入数据缓存大小，可以有效提高插入效率，默认为8M

bulk_insert_buffer_size = 64M

#连接超时

interactive_timeout = 28800

wait_timeout = 28800

sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES,NO_ZERO_DATE

[mysqldump]

quick

default-character-set = utf8mb4

max_allowed_packet = 256M

#---------------- 配置文件结束 ------------------#

#初始化数据库

/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

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启动mysqlservice 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');

商业转载请联系作者获得授权，非商业转载请注明出处 本文地址：https://me.jinchuang.org/archives/22.html