?

一、下载(免安装Archive版)

???下载地址：http://dev.mysql.com/downloads/mysql/

????

?

二、安装

1.解压到目录：D:\mysql-5.1.59-winx64

2.注册mysql服务，命令行跳转到D:\mysql-5.1.59-winx64\bin，执行以下命令：

D:\mysql-5.1.59-winx64\bin>mysqld install mysql
Service successfully installed.

3.移除mysql服务，命令行跳转到D:\mysql-5.1.59-winx64\bin，执行以下命令：

D:\mysql-5.1.59-winx64\bin>mysqld remove mysql
Service successfully removed.

?

4.启动停止mysql服务

??? 启动：

C:\>net start mysql
MySQL 服务正在启动 ..
MySQL 服务已经启动成功。

?

??? 停止：

C:\>net stop mysql
MySQL 服务正在停止...
MySQL 服务已成功停止。

?

5.设置服务自动启动

D:\>sc config mysql start= auto
[SC] ChangeServiceConfig 成功

注：start与=号之间不能有空格，=号与auto之间必须有一个空格?

?

三.、配置

在D:\mysql-5.1.59-winx64目录下,有5个配置文件模板, 分别为：

??????? my-small.ini、

??????? my-medium.ini、

??????? my-large.ini、

??????? my-huge.ini、

??????? my-innodb-heavy-4G.ini

1.我们选择my-innodb-heavy-4G.ini,作为配置模板

2.将其改名为：my.ini

3.修改默认引擎：找到default-storage-engine =?MYISAM 这段,将其改为default-storage-engine = INNODB

4.修改默认引擎为INNODB后，可能导致服务器启动失败：删除在MySQL安装目录下的Data目录中的ib_logfile0，ib_logfile1，ibdata1三个文件，重新启动即可

5.修改默认编码：

????????? 打开my.ini文件

??????????[client] 段添加：? default-character-set=utf8

??????????[mysqld]段添加：character-set-server=utf8

[client]
port		= 3306
socket		= MySQL
default-character-set=utf8

[mysqld]
port		= 3306
socket		= MySQL
character-set-server=utf8

?

?????????

?

?

四、常用命令

1.命令行登陆：mysql -uroot -proot

D:\mysql-5.1.59-winx64\bin>mysql -uroot -proot
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 3
Server version: 5.1.59-community-log MySQL Community Server (GPL)

Copyright (c) 2000, 2011, 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>

?

2.查看数据库 show databases;

mysql> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| mysql              |
| test               |
+--------------------+
3 rows in set (0.00 sec)

?

2.查看数据库表 use dbname; show tables;

mysql> use mysql;
Database changed
mysql> show tables;
+---------------------------+
| Tables_in_mysql           |
+---------------------------+
| columns_priv              |
| db                        |
| event                     |
| func                      |
| general_log               |
| help_category             |
| help_keyword              |
| help_relation             |
| help_topic                |
| host                      |
| ndb_binlog_index          |
| plugin                    |
| proc                      |
| procs_priv                |
| servers                   |
| slow_log                  |
| tables_priv               |
| time_zone                 |
| time_zone_leap_second     |
| time_zone_name            |
| time_zone_transition      |
| time_zone_transition_type |
| user                      |
+---------------------------+
23 rows in set (0.03 sec)

?

3.查看数据配置变量信息 show variables;

?

mysql> show variables like '%innodb%';
+-----------------------------------------