解压版mysql+免破解版Navicat,好用!

解压版mysql安装流程

  • 获取mysql压缩包
    获取地址:
链接:https://pan.baidu.com/s/1HqdFDQn_6ccPM0gOftApIg 
提取码:n19t 

获取压缩包后可安装压缩包内的安装说明执行安装流程(整体配置环境变量和路径即可)

  • 具体流程如下:
    1、如果本地已安装mysql可执行如下命令:
# 删除服务
sc delete mysql
#返回:[SC]
 Delete Service (成功)

2、配置mysql环境变量:在path中添加“MySQLin”的路径(详情可百度)
3、修改my-default.ini配置文件,找到如下配置指向自己的安装路径

basedir = "D:workMySQLmysql-5.6.24-win32"
datadir = "D:workMySQLmysql-5.6.24-win32data"

4、安装MySQL服务,具体命令如下:

1)、进入安装目录
		cd D:workMySQLmysql-5.6.24in
		e:
2)、安装
		mysqld -install 	
		返回:Service successfully installed

5、启动MySQL服务,具体命令如下:

net start MySQL

6、修改密码

因为默认密码为空。
	在in目录下,执行:
		mysqladmin -uroot -p password 输入你的新密码   回车
		返回:Enter password
		不用管,直接回车,密码修改成功。

到此mysql安装成功,通过cmd验证mysql如下:

  • 附my.ini配置文件
附录A:my.ini
--------------------------------------------------------------------------------
# For advice on how to change settings please see
# http://dev.mysql.com/doc/refman/5.6/en/server-configuration-defaults.html
# *** DO NOT EDIT THIS FILE. It's a template which will be copied to the
# *** default location during install, and will be replaced if you
# *** upgrade to a newer version of MySQL.

[mysqld]

# Remove leading # and set to the amount of RAM for the most important data
# cache in MySQL. Start at 70% of total RAM for dedicated server, else 10%.
innodb_buffer_pool_size = 128M

# Remove leading # to turn on a very important data integrity option: logging
# changes to the binary log between backups.
# log_bin

# These are commonly set, remove the # and set as required.
# mysql根目录
basedir = "D:workMySQLmysql-5.6.24-win32"
# 数据文件存放目录
datadir = "D:workMySQLmysql-5.6.24-win32data"
# port = .....
# server_id = .....


# Remove leading # to set options mainly useful for reporting servers.
# The server defaults are faster for transactions and fast SELECTs.
# Adjust sizes as needed, experiment to find the optimal values.
# join_buffer_size = 128M
# sort_buffer_size = 2M
# read_rnd_buffer_size = 2M 

sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES 

#服务端的编码方式
character-set-server=utf8
[client]
#客户端编码方式,最好和服务端保存一致
loose-default-character-set = utf8
[WinMySQLadmin]  
Server = "D:workMySQLmysql-5.6.24-win32inmysqld.exe"

-------------------------------my.ini <end>----------------------------------------	

免破解版Navicat,解压即可用

  • Navicat获取地址:
链接:https://pan.baidu.com/s/1HBoyZ3p593JgXR5erh31wg 
提取码:o50h 
  • 下载后直接解压,找到navicat.exe,直接启动即可,整个过程无需破解!
    运行过程配置的mysql已经成功,如下:

简单几步即可完成mysql安装!


更多测试技术分享、学习资源以及一些其他福利可关注公众号:【Coding测试】获取:
Coding测试

记录工作中使用的CI/CD流程
原文地址:https://www.cnblogs.com/CodingTest/p/14120806.html