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配置方法,希望对大家有所帮助,如果大家有任何疑问请给我留言,小编会及时回复大家的。在此也非常感谢大家对我们网站的支持!
赞 (0)