安装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