liunx安装mysql5.7.23_linux下安装mysql5.7.23

安装mysql5.7.23

在官网上下载mysql linux版本，通过tar -xvf mysql文件名，解压文件

1.创建软链接：

ln -s mysql安装路径 mysql软连接名

2.创建用户组及用户名

groupadd mysql

useradd -g mysql -s /sbin/nologin -d /usr/local/software/mysql mysql

查看用户组：id mysql

3.分配目录权限

chown -R mysql:mysql mysql

chown -R mysql:mysql mysql/

4.修改系统配置(mysql安装目录)

#cp support-files/mysql.server /etc/init.d/mysql

#vim /etc/init.d/mysql

basedir=/usr/local/software/mysql

datadir=/usr/local/software/mysql/data

5.vim /etc/my.cnf(mysql配置文件)

6.配置参数：初始化

bin/mysqld --initialize --user=mysql --basedir=/usr/local/software/mysql --datadir=/usr/local/software/mysql/data

7.查看mysql初始化密码，在mysql日志文件中

cat /usr/local/software/mysql/logs/mysql_error.log

8.在mysql解压目录下运行：

bin/mysql_ssl_rsa_setup --datadir=/usr/local/software/mysql/data

9.启动mysql服务：

service mysql start

10.登录mysql数据库

mysql -uroot -p(mysql初始化密码，在日志文件找)

11.修改mysql的登录密码

set password=password('root');

12.控制mysql远程访问

flush privileges;

GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'root' WITH GRANT OPTION;

flush privileges;

附件：/etc/my.cnf文件

[client]

port = 3306

default-character-set=utf8

socket=/usr/local/software/mysql/mysql.sock

[mysql]

port = 3306

default-character-set=utf8

socket=/usr/local/software/mysql/mysql.sock

[mysqld]

##########################

# summary

##########################

bind-address = 0.0.0.0

port = 3306

basedir=/usr/local/software/mysql

datadir=/usr/local/software/mysql/data

socket=/usr/local/software/mysql/mysql.sock

tmpdir=/usr/local/software/mysql/tmp

pid-file=/usr/local/software/mysql/tmp/mysql.pid

#skip-grant-tables

#skip-networking

explicit_defaults_for_timestamp=1

lower_case_table_names=1

table_open_cache = 8000

##########################

# time out

##########################

connect_timeout = 20

wait_timeout = 86400

##########################

# connection

##########################

max_connections = 2000

max_user_connections = 1900

max_connect_errors = 100000

max_allowed_packet = 1G

##########################

# character set

##########################

character-set-server = utf8

collation-server = utf8_bin

##########################

# log bin

##########################

server-id = 1

log_bin = mysql-bin

binlog_format = MIXED

sync_binlog = 1

expire_logs_days =7

binlog_cache_size = 128m

max_binlog_cache_size =512m

max_binlog_size =256M

binlog_ignore_db=mysql

binlog_ignore_db=information_schema

binlog_ignore_db=performation_schema

binlog_ignore_db=sys

##########################

# log relay

##########################

relay_log = mysql-relay-bin

relay_log_purge = on

relay_log_recovery = on

max_relay_log_size = 1G

##########################

# log error

##########################

log_error=/usr/local/software/mysql/logs/mysql_error.log

##########################

# log slow

##########################

slow_query_log = on

slow_query_log_file = /usr/local/software/mysql/logs/mysql_slow.log

long_query_time = 2

log_queries_not_using_indexes = on

##########################

# log general

##########################

general_log = on

general_log_file = /usr/local/software/mysql/logs/mysql_gener.log

##########################

# thread pool

##########################

#thread_handling=pool-of-threads

#thread_handling=one-thread-per-connection

#thread_pool_oversubscribe=8

##########################

# innodb

##########################

innodb_file_per_table=1

innodb_log_file_size=1024M

innodb_log_buffer_size=64M

##########################

# password policy

# after init

##########################

#validate_password_length=4

#validate_password_mixed_case_count=0

#validate_password_number_count=0

#validate_password_policy=0

#validate_password_special_char_count=0