欢迎您访问程序员文章站本站旨在为大家提供分享程序员计算机编程知识!
您现在的位置是: 首页  >  IT编程

MySQL 5.7.22 二进制包安装及免安装版Windows配置方法

程序员文章站 2022-06-17 20:36:44
下面通过代码给大家介绍了mysql 5.7.22 二进制包安装方法,具体代码如下所示: .目录规划: 程序目录:/usr/local/mysql 数据目录:/...

下面通过代码给大家介绍了mysql 5.7.22 二进制包安装方法,具体代码如下所示:

.目录规划:
程序目录:/usr/local/mysql
数据目录:/data/mysql
pid和socket文件位置:/tmp
.文件下载:
官方默认只提供最新版本的,历史版本的下载地址:
https://downloads.mysql.com/archives/
.7.22版本下载:
# wget https://cdn.mysql.com/archives/mysql-5.7/mysql-5.7.22-linux-glibc2.12-x86_64.tar.gz
文件下载大小约614m。
#tar -xzf mysql-5.7.22-linux-glibc2.12-x86_64.tar.gz -c /usr/local/
#mv /usr/local/mysql-5.7.22-linux-glibc2.12-x86_64/ /usr/local/mysql
# echo "export path=$path:/usr/local/mysql/bin" >/etc/profile.d/mysql.sh
# source /etc/profile.d/mysql.sh
.创建用户和授权:
#useradd mysql
#passwd mysql
#mkdir -p /data/mysql
#chown -r mysql:mysql /data/mysql
#chmod -r 755 /data/mysql
.设置参数:
[mysqld]
#basic
#skip-grant-tables 
#validate_password        =off
datadir             = /data/mysql
port              = 3306
pid-file            = /tmp/mysql.pid
socket             = /tmp/mysql.sock
log_error            = error.log
slow-query-log         = 1
slow-query-log-file      = slow.log
long_query_time        = 0.2
log-bin            = mysql_bin.log
binlog_format         = row
expire-logs-days        = 1
relay-log           = mysql_relay.log
relay_log_recovery       = 1
general_log          = on
general_log_file        = general.log
lower_case_table_names     = 1
server-id            = 1
character_set_client_handshake = false
character_set_server      = utf8mb4
collation_server        = utf8mb4_unicode_ci
init_connect          ='set names utf8mb4'
interactive_timeout       = 172800
wait_timeout          = 172800
max_prepared_stmt_count     =1048576 
max_connections         = 8000
#connections
 max_connections=4000
 key_buffer_size=200m
 low_priority_updates=1
 table_open_cache = 8000
 back_log=1500
 query_cache_type=0
 table_open_cache_instances=16
#files
 innodb_file_per_table =on
 innodb_log_file_size=1024m
 innodb_log_files_in_group = 3
 innodb_open_files=4000
#buffers
innodb_buffer_pool_size=1g
innodb_buffer_pool_instances=32
#innodb_additional_mem_pool_size=20m
innodb_log_buffer_size=64m
join_buffer_size=32k
sort_buffer_size=32k
#innodb
innodb_checksums=0
innodb_doublewrite=0
innodb_support_xa=0
innodb_thread_concurrency=0
innodb_flush_log_at_trx_commit=2
innodb_max_dirty_pages_pct=50
innodb_use_native_aio=1
innodb_stats_persistent = 1
#innodb_spin_wait_delay= 6 / 96
#performance
innodb_adaptive_flushing = 1
innodb_flush_neighbors = 0
innodb_read_io_threads = 4
innodb_write_io_threads = 4
innodb_io_capacity = 4000
innodb_purge_threads=1
innodb_adaptive_hash_index=0
#monitor
innodb_monitor_enable = '%'
performance_schema=off
[mysql]
user = root
.初始化数据库实例:
/usr/local/mysql/bin/mysqld --user=mysql --basedir=/usr/local/mysql --datadir=/data/mysql --initialize-insecure
.启动:
# cp /usr/local/mysql/support-files/mysql.server /etc/init.d/mysql
# /etc/init.d/mysql start
starting mysql... success! 
.验证和设置远程访问:
[root@node1 soft]# mysql -p -s /tmp/mysql.sock
mysql> grant all privileges on *.* to root@'%' identified by 'oracle' with grant option;
query ok, 0 rows affected, 1 warning (0.01 sec)
mysql> flush privileges;
query ok, 0 rows affected (0.00 sec)

补充:mysql 5.7.22 免安装版windows配置

下载mysql 5.7.22

解压文件,发现根目录下没有data目录

进入bin 目录:

cd d:\program files\mysql\mysql server 5.7\bin  

运行

mysqld --initialize-insecure --user=mysql

执行完命令发现根目录多了个data 的文件夹

配置my.ini 文件,

执行命令:

mysqld install mysql57 --defaults-file="g:\datadbs\mysql-5.7\my.ini"

启动mysql 服务,默认密码为空登录进去

update mysql.user set authentication_string=password('newpwd'),password_expired='n' where user='root';

修改密码并修改过时策略(字段名和mysql 5.6略有不同,5.6的:update user set password = password('newpwd'),password_expired='n' where user = 'root';)

-- 开启远程连接权限
grant all on *.* to root@'%' identified by 'newpwd' with grant option;
flush privileges;

然后重启mysql 服务就配置完成了

总结

以上所述是小编给大家介绍的mysql 5.7.22 二进制包安装及免安装版windows配置方法,希望对大家有所帮助