mysql (Noinstall 版本) 学习

今天准备弄一下mysql,下载了一个免安装的版本。是 win32版本，我的操作系统是win xp

下面是我学习的过程，都是我一步一步测试的，如果有错误，请指正！

想赚钱的朋友，可以看程序员赚钱方法探讨

1、下载
下载地址是：http://dev.mysql.com/downloads/mysql/5.1.html#win32
选择 Without installer (unzip in C:\) 5.1.39 112.6M
   这个进行下载

2、解压

解压到一个你指定的地方，最好别放在系统盘，不然操作系统一出问题.....

3、启动数据库
首先进入命令行窗口（注意，进入你的解压的路径，不一定和我的相同）

d:
cd D:\Program Files\mysql-5.1.39-win32\bin
D:\Program Files\mysql-5.1.39-win32\bin>mysqld --console

执行完上述操作后，你会看到

090929 22:13:43 [Note] Plugin 'FEDERATED' is disabled.
InnoDB: The first specified data file .\ibdata1 did not exist:
InnoDB: a new database to be created!
090929 22:13:43  InnoDB: Setting file .\ibdata1 size to 10 MB
InnoDB: Database physically writes the file full: wait...
090929 22:13:43  InnoDB: Log file .\ib_logfile0 did not exist: new to be created

InnoDB: Setting log file .\ib_logfile0 size to 5 MB
InnoDB: Database physically writes the file full: wait...
090929 22:13:43  InnoDB: Log file .\ib_logfile1 did not exist: new to be created

InnoDB: Setting log file .\ib_logfile1 size to 5 MB
InnoDB: Database physically writes the file full: wait...
InnoDB: Doublewrite buffer not found: creating new
InnoDB: Doublewrite buffer created
InnoDB: Creating foreign key constraint system tables
InnoDB: Foreign key constraint system tables created
090929 22:13:44  InnoDB: Started; log sequence number 0 0
090929 22:13:45 [Note] Event Scheduler: Loaded 0 events
090929 22:13:45 [Note] mysqld: ready for connections.
Version: '5.1.39-community'  socket: ''  port: 3306  MySQL Community Server (GPL
)


到此：服务已经启动了。
保持这个窗口不要关闭。

4、测试mysql是否安装上

D:\>cd D:\Program Files\mysql-5.1.39-win32\bin

D:\Program Files\mysql-5.1.39-win32\bin>mysqlshow
+--------------------+
|     Databases      |
+--------------------+
| information_schema |
| test               |
+--------------------+

5、关闭服务
D:\Program Files\mysql-5.1.39-win32\bin>mysqladmin -u root shutdown
(直接将命令行窗口关掉也会关闭服务，至于会有什么负面影响，我不知道)

如果此时再执行命令 mysqlshow,则会报错了

D:\Program Files\mysql-5.1.39-win32\bin>mysqlshow
mysqlshow: Can't connect to MySQL server on 'localhost' (10061)

6、创建 option file 来配置你的 mysql路径和数据路径

在 C:\WINDOWS 下，创建文件 my.ini
文件内容为：

[mysqld]
# set basedir to your installation path
basedir=D:/Program Files/mysql-5.1.39-win32
# set datadir to the location of your data directory
datadir=D:/Program Files/mysql-5.1.39-win32/data

注意：路径用/分隔，如果用\，则要写两个，即\\

7、从命令行连接到mysql

D:\Program Files\mysql-5.1.39-win32\bin>mysql -h localhost -u root -p
Enter password:
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 4
Server version: 5.1.39-community MySQL Community Server (GPL)

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

mysql>

mysql会提示你输入密码
Enter password:
什么也别输入，直接回车即可。(至于说在哪里设置用户名及密码，俺还不知道......慢慢学了)

当然，如果mysql运行在你本机上，直接
D:\Program Files\mysql-5.1.39-win32\bin>mysql -u root -p
就行，不需要指定服务器地址。

8、退出连接
mysql> quit;
Bye

9、查看目前已有的数据库
mysql> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| mysql              |
| test               |
+--------------------+
3 rows in set (0.02 sec)


10、创建数据库

mysql> create database deqiallen_wp1;
Query OK, 1 row affected (0.02 sec)






参考：http://dev.mysql.com/doc/refman/5.0/en/windows-create-option-file.html
mysql 5.1参考手册