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

Windows  /  管理员 发布于 7年前   173

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

.目录规划：程序目录：/usr/local/mysql数据目录：/data/mysqlPID和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        =OFFdatadir = /data/mysqlport  = 3306pid-file= /tmp/mysql.pidsocket = /tmp/mysql.socklog_error= error.logslow-query-log         = 1slow-query-log-file      = slow.loglong_query_time        = 0.2log-bin= mysql_bin.logbinlog_format         = ROWexpire-logs-days        = 1relay-log           = mysql_relay.logrelay_log_recovery       = 1general_log          = ongeneral_log_file        = general.loglower_case_table_names     = 1server-id= 1character_set_client_handshake = FALSEcharacter_set_server      = utf8mb4collation_server        = utf8mb4_unicode_ciinit_connect          ='SET NAMES utf8mb4'interactive_timeout       = 172800wait_timeout          = 172800max_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#buffersinnodb_buffer_pool_size=1Ginnodb_buffer_pool_instances=32#innodb_additional_mem_pool_size=20Minnodb_log_buffer_size=64Mjoin_buffer_size=32Ksort_buffer_size=32K#innodbinnodb_checksums=0innodb_doublewrite=0innodb_support_xa=0innodb_thread_concurrency=0innodb_flush_log_at_trx_commit=2innodb_max_dirty_pages_pct=50innodb_use_native_aio=1innodb_stats_persistent = 1#innodb_spin_wait_delay= 6 / 96#performanceinnodb_adaptive_flushing = 1innodb_flush_neighbors = 0innodb_read_io_threads = 4innodb_write_io_threads = 4innodb_io_capacity = 4000innodb_purge_threads=1innodb_adaptive_hash_index=0#monitorinnodb_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 startStarting MySQL... SUCCESS! .验证和设置远程访问：[root@node1 soft]# mysql -p -S /tmp/mysql.sockmysql> 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配置方法，希望对大家有所帮助，如果大家有任何疑问请给我留言，小编会及时回复大家的。在此也非常感谢大家对站的支持！