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

下面通过代码给大家介绍了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配置方法，希望对大家有所帮助，如果大家有任何疑问请给我留言，小编会及时回复大家的。在此也非常感谢大家对脚本之家网站的支持！