MYSQL ZIP免安装版配置

1. 下载MySQL 选择自己想要的.本次安装.我使用的是mysql-5.6.17-winx64 

地址:http://dev.mysql.com/downloads/mysql/

2. 解压zip 文件. 在mysql 的根目录下找到  my-default.ini  复制出一个 my.ini 文件, 根据你需要的位置修改 my.ini 文件

a）在[mysqld]下追加
-------
basedir = "d:\\mysql"
datadir = "d:\\mysql\\data"
character-set-server = utf8
-------
b) 在[client]下追加
-------
default-character-set = utf8

# 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 % of total RAM for dedicated server, else %.

# 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.

# basedir = .....

# datadir = .....

# port = .....

# server_id = .....

basedir =D:\work\mysql-5.6.-winx64

datadir =F:\db-data\mysql

character-set-server = utf8

# 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 

[client]

default-character-set = utf8

3. 启动服务

保存

my.ini

的配置，然后打开命令行切换到mysql解压目录下的bin 目录;

执行 mysqld.exe console 命令测试一下

D:\work\mysql-5.6.-winx64\bin>mysqld.exe console

-- ::  [Warning] TIMESTAMP with implicit DEFAULT value is depreca

ted. Please use --explicit_defaults_for_timestamp server option (see documentati

on for more details).

然后执行 mysqld.exe console 命令启动mysql

D:\work\mysql-5.6.-winx64\bin>mysqld.exe --console

-- ::  [Warning] TIMESTAMP with implicit DEFAULT value is depreca

ted. Please use --explicit_defaults_for_timestamp server option (see documentati

on for more details).

-- ::  [Note] Plugin 'FEDERATED' is disabled.

mysqld.exe: Table 'mysql.plugin' doesn't exist

-- ::  [ERROR] Can't open the mysql.plugin table. Please run m

ysql_upgrade to create it.

-- ::  [Note] InnoDB: Using atomics to ref count buffer pool p

ages

-- ::  [Note] InnoDB: The InnoDB memory heap is disabled

-- ::  [Note] InnoDB: Mutexes and rw_locks use Windows interlo

cked functions

-- ::  [Note] InnoDB: Compressed tables use zlib 1.2.

-- ::  [Note] InnoDB: Not using CPU crc32 instructions

-- ::  [Note] InnoDB: Initializing buffer pool, size = 128.0M

-- ::  [Note] InnoDB: Completed initialization of buffer pool

-- ::  [Note] InnoDB: Highest supported file format is Barracu

da.

-- ::  [Note] InnoDB:  rollback segment(s) are active.

-- ::  [Note] InnoDB: Waiting for purge to start

-- ::  [Note] InnoDB: 5.6. started; log sequence number 

-- ::  [Warning] No existing UUID has been found, so we assume

 that this is the first time that this server has been started. Generating a new

 UUID: dcd35109-ca0e-11e3-a872-003018a05bef.

-- ::  [Note] Server hostname (bind-address): '*'; port:

-- ::  [Note] IPv6 is available.

-- ::  [Note]   - '::' resolves to '::';

-- ::  [Note] Server socket created on IP: '::'.

-- ::  [ERROR] Fatal error: Can't open and lock privilege tabl

es: Table 'mysql.user' doesn't exist

注:这里出现异常 :Table 'mysql.user' doesn't exist 是因为我没有吧数据文件复制到 my.ini 里面配置的路径下,

数据文件是在 mysql 解压目录的下 的 data 目录, 吧整个目录里的内容复制到配置文件里写的目录里,然后启动

D:\work\mysql-5.6.-winx64\bin>mysqld.exe --console

-- ::  [Warning] TIMESTAMP with implicit DEFAULT value is depreca

ted. Please use --explicit_defaults_for_timestamp server option (see documentati

on for more details).

-- ::  [Note] Plugin 'FEDERATED' is disabled.

-- ::  [Note] InnoDB: Using atomics to ref count buffer pool p

ages

-- ::  [Note] InnoDB: The InnoDB memory heap is disabled

-- ::  [Note] InnoDB: Mutexes and rw_locks use Windows interlo

cked functions

-- ::  [Note] InnoDB: Compressed tables use zlib 1.2.

-- ::  [Note] InnoDB: Not using CPU crc32 instructions

-- ::  [Note] InnoDB: Initializing buffer pool, size = 128.0M

-- ::  [Note] InnoDB: Completed initialization of buffer pool

-- ::  [Note] InnoDB: Highest supported file format is Barracu

da.

-- ::  [Note] InnoDB:  rollback segment(s) are active.

-- ::  [Note] InnoDB: Waiting for purge to start

-- ::  [Note] InnoDB: 5.6. started; log sequence number 

-- ::  [Warning] No existing UUID has been found, so we assume

 that this is the first time that this server has been started. Generating a new

 UUID: 8f19129f-ca0f-11e3-a876-003018a05bef.

-- ::  [Note] Server hostname (bind-address): '*'; port:

-- ::  [Note] IPv6 is available.

-- ::  [Note]   - '::' resolves to '::';

-- ::  [Note] Server socket created on IP: '::'.

-- ::  [Note] Event Scheduler: Loaded  events

-- ::  [Note] mysqld.exe: ready for connections.

Version: '5.6.17'  socket: ''  port:   MySQL Community Server (GPL)

证明mysql服务已启动

6. 设置登陆mysql root帐号的的密码

在mysql/bin 目录下打开新的命令行，输入mysql 回车

D:\work\mysql-5.6.-winx64\bin>mysql

Welcome to the MySQL monitor.  Commands end with ; or \g.

Your MySQL connection id is

Server version: 5.6. MySQL Community Server (GPL)

Copyright (c) , , Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its

affiliates. Other names may be trademarks of their respective

owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql>

看到上面类似内容说明登陆成功，此时的root帐号是没有密码的,而我也没打算要密码

想要设置可使用命令

直接运行命令行窗口输入下面的

mysqladmin -u root password

你的密码

这样就Ok了,

7. 安装mysql服务

在bin目录下执行命令

mysqld.exe --install MySQL5.6.17 --defaults-file="D:\work\mysql-5.6.17-winx64\my.ini"

结果如下.

D:\work\mysql-5.6.-winx64\bin>mysqld.exe --install MySQL5.6.17 --defaults-file

="D:\work\mysql-5.6.17-winx64\my.ini"

Service successfully installed.

8.启动服务

net start MySQL5.6.17
D:\work\mysql-5.6.-winx64\bin>net start MySQL5.6.17

MySQL5.6.17 服务正在启动 .

MySQL5.6.17 服务已经启动成功。

注：若启动不成功修改注册表开始->运行->regedit
找HKEY_LOCAL_MECHINE---SYSTEM ---ControlSet001或ControlSet002中找Services，
再找MySQL项，修改 ImagePath值改为："D:\work\mysql-5.6.17-winx64\bin\mysqld" --defaults-file="D:\work\mysql-5.6.17-winx64\my.ini" MySQL

最后为了方便添加环境变量.

MYSQL=D:\work\mysql-5.6.17-winx64

Path=%MYSQL%/bin;Path...

测试:

C:\Windows\System32>SET PATH=%MYSQL%\bin;%PATH%

C:\Windows\System32>echo PATH

PATH

C:\Windows\System32>echo %PATH%

D:\work\mysql-5.6.-winx64\bin;D:\Program Files\java\jdk1..0_15\bin;D:\Program

 Files\java\jdk1..0_15\jre\bin;C:\Windows\system32;C:\Windows;C:\Windows\System

\Wbem;C:\Windows\System32\WindowsPowerShell\v1.\

C:\Windows\System32>mysql

Welcome to the MySQL monitor.  Commands end with ; or \g.

Your MySQL connection id is

Server version: 5.6. MySQL Community Server (GPL)

Copyright (c) , , Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its

affiliates. Other names may be trademarks of their respective

owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql>

到此结束.

最新文章

  1. .Net深入实战系列—JSON序列化那点事儿
  2. 01 Apache Solr:提升检索体验 为什么是Solr
  3. WPF 创建桌面快捷方式
  4. uzqp文件的加解密
  5. UML概述（转载）
  6. 实战DeviceIoControl 之中的一个：通过API訪问设备驱动程序
  7. 使用脚本管理IIS
  8. 很多Python新手教程
  9. Java高效计数器
  10. 自学Zabbix3.1-语言切换
  11. 最小化安装centos5.5
  12. react 简书开发笔记
  13. Winform文件上传
  14. css按钮口诀 - CSS BUG顺口溜
  15. Unity 3D游戏-贪吃蛇类游戏源码：重要方法和功能的实现
  16. EC20模块(mdm9607)复用pin脚当作普通gpio的设置方法
  17. ldap客户端以及jenkins的配置
  18. c# .net 编程方式修改环境变量无效的解决办法
  19. Vue 2.0的学习笔记：Vue的过滤器
  20. LWIP network interface 网卡 初始化 以 STM32 为例子 后面会有 用 2G 或者4G 模块 用 PPP拨号的 形式 虚拟出网卡 所以先以 这个为 前提

热门文章

  1. jquery jsonp实现跨域
  2. win7下将主分区转换成逻辑分区
  3. Contoso 大学 - 7 – 处理并发
  4. JSON解析例子
  5. javascript笔记——图片大小检测
  6. 如何找到Linux下常用命令的源码
  7. HR不会告诉你的秘密
  8. springMVC整合memcached
  9. JavaScript jQuery 事件、动画、扩展
  10. IIS上的错误与解决方案