mysql免安装版安装配置

1.获得mysql免安装版的压缩文件包，地址http://dev.mysql.com/downloads/mysql/，带有noinstall的就是。

2.解压文件到硬盘上，如c：/，并为了方便起见重命名文件夹名为mysql.

3.拷贝my-small.ini，粘贴并重命名为my.ini。

  打开my.ini，在[mysqld]下指定basedir和datadir

  我这里是basedir=c:/mysql
  datadir=c:/mysql/data

4.打开cmd，在执行以下命令

   cd c:/mysql/bin

  mysqld --console

你会看到如下信息

InnoDB: The first specified datafile c:/ibdata/ibdata1 did not exist:

InnoDB: a new database to be created
！

InnoDB: Setting file c:/ibdata/ibdata1 size to 209715200

InnoDB: Database physically writes the file full: wait...

InnoDB: Log file c:/iblogs/ib_logfile0 did not exist: new to be created

InnoDB: Setting log file c:/iblogs/ib_logfile0 size to 31457280

InnoDB: Log file c:/iblogs/ib_logfile1 did not exist: new to be created

InnoDB: Setting log file c:/iblogs/ib_logfile1 size to 31457280

InnoDB: Log file c:/iblogs/ib_logfile2 did not exist: new to be created

InnoDB: Setting log file c:/iblogs/ib_logfile2 size to 31457280

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

011024 10:58:25  InnoDB: Started

服务器完成启动序列后，你应当能看见下述内容，表示服务器准备好，可以进行客户端连接：

mysqld: ready for connections Version: '5.1.2-alpha'  socket: ''  port: 3306

5.打开新的cmd，cd c:/mysql/bin

输入mysql -u root 就可以进入mysql了

这时的mysql是没有密码的，你用下列命令行可以为root加上密码,其中newpwd就是你想要的新密码

SET PASSWORD FOR 'root'@'localhost' = PASSWORD('newpwd
');



SET PASSWORD FOR 'root'@'host_name
' = PASSWORD('newpwd
');





end！！！！！