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

2020-12-10  本文已影响0人  Coding测试

解压版mysql安装流程

链接:https://pan.baidu.com/s/1HqdFDQn_6ccPM0gOftApIg 
提取码:n19t 

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

# 删除服务
sc delete mysql
#返回:[SC]
 Delete Service (成功)

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

basedir = "D:\work\MySQL\mysql-5.6.24-win32"
datadir = "D:\work\MySQL\mysql-5.6.24-win32\data"

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

1)、进入安装目录
        cd D:\work\MySQL\mysql-5.6.24\bin
        e:
2)、安装
        mysqld -install     
        返回:Service successfully installed

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

net start MySQL

6、修改密码

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

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


附录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:\work\MySQL\mysql-5.6.24-win32"
# 数据文件存放目录
datadir = "D:\work\MySQL\mysql-5.6.24-win32\data"
# 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:\work\MySQL\mysql-5.6.24-win32\bin\mysqld.exe"

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

免破解版Navicat,解压即可用

链接:https://pan.baidu.com/s/1HBoyZ3p593JgXR5erh31wg 
提取码:o50h 

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

上一篇下一篇

猜你喜欢

热点阅读