MySQL 5.7.22 二进制包安装及免安装版Windows配置方法
下面通过代码给大家介绍了mysql5.7.22二进制包安装方法,具体代码如下所示:
.目录规划: 程序目录:/usr/local/mysql 数据目录:/data/mysql PID和SOCKET文件位置:/tmp .文件下载: 官方默认只提供最新版本的,历史版本的下载地址: https://downloads.mysql.com/archives/ .7.22版本下载: #wgethttps://cdn.mysql.com/archives/mysql-5.7/mysql-5.7.22-linux-glibc2.12-x86_64.tar.gz 文件下载大小约614M。 #tar-xzfmysql-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"exportPATH=$PATH:/usr/local/mysql/bin">/etc/profile.d/mysql.sh #source/etc/profile.d/mysql.sh .创建用户和授权: #useraddmysql #passwdmysql #mkdir-p/data/mysql #chown-Rmysql:mysql/data/mysql #chmod-R755/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='SETNAMESutf8mb4' 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/mysqlstart StartingMySQL...SUCCESS! .验证和设置远程访问: [root@node1soft]#mysql-p-S/tmp/mysql.sock mysql>grantallprivilegeson*.*toroot@'%'identifiedby'oracle'withgrantoption; QueryOK,0rowsaffected,1warning(0.01sec) mysql>flushprivileges; QueryOK,0rowsaffected(0.00sec)
补充:mysql5.7.22免安装版Windows配置
下载mysql5.7.22
解压文件,发现根目录下没有data目录
进入bin目录:
cdd:\ProgramFiles\MySQL\MySQLServer5.7\bin
运行
mysqld--initialize-insecure--user=mysql
执行完命令发现根目录多了个data的文件夹
配置my.ini文件,
执行命令:
mysqldinstallMYSQL57--defaults-file="G:\DataDBs\mysql-5.7\my.ini"
启动mysql服务,默认密码为空登录进去
updatemysql.usersetauthentication_string=password('newpwd'),password_expired='N'whereuser='root';
修改密码并修改过时策略(字段名和mysql5.6略有不同,5.6的:updateusersetpassword=password('newpwd'),password_expired='N'whereuser='root';)
--开启远程连接权限 grantallon*.*toroot@'%'identifiedby'newpwd'withgrantoption; flushprivileges;
然后重启mysql服务就配置完成了
总结
以上所述是小编给大家介绍的MySQL5.7.22二进制包安装及免安装版Windows配置方法,希望对大家有所帮助,如果大家有任何疑问请给我留言,小编会及时回复大家的。在此也非常感谢大家对毛票票网站的支持!