win7免安装mysql配置使用

win7 64位机

下载地址：http://www.mysql.com/downloads/mirror.php?id=402885；选择“Univ. of Technology / Vienna, Austria ”后面的“HTTP”下载后解压缩，我放到“C:\ProgrameData\mysql-5.5.13-winx64”。

 

下面是三个常用批处理脚本：

StartMySql.bat

---------

CD C:\ProgrameData\mysql-5.5.13-winx64\bin

mysqld --console

---------

ShutDownMySql.bat

---------

CD C:\ProgrameData\mysql-5.5.13-winx64\bin

mysqladmin -u root shutdown

#mysqladmin -u root shutdown可视自己的root口令加上-p xxx

---------

MySql_query.bat

---------

CD C:\ProgrameData\mysql-5.5.13-winx64\bin

 

mysql -u root

#mysql -u root -p xxx

---------

 

my.ini 【解决中文乱码，放在解压缩目录里面】

-----

 

[client]

port = 3306

 

[mysql]

no-auto-rehash

default-character-set = utf8

 

[mysqld]

port = 3306

socket = /tmp/mysql.sock

skip-external-locking

key_buffer_size = 16M

max_allowed_packet = 16M

innodb_data_home_dir = ../data

innodb_log_group_home_dir = ../data

table_open_cache = 64

sort_buffer_size = 512K

net_buffer_length = 8K

read_buffer_size = 256K

read_rnd_buffer_size = 512K

myisam_sort_buffer_size = 32M

max_connections = 1000

#log-bin = mysql-bin

#binlog_format = mixed

server-id = 1

default-storage-engine = MYISAM

character-set-server = utf8

#skip-innodb

 

[mysqldump]

quick

max_allowed_packet = 16M

 

[myisamchk]

key_buffer_size = 20M

sort_buffer_size = 20M

read_buffer = 2M

write_buffer = 2M

 

[mysqlhotcopy]

interactive-timeout

-----------------

130314  9:43:27 [Note] Plugin 'FEDERATED' is disabled.

130314  9:43:27 InnoDB: The InnoDB memory heap is disabled

130314  9:43:27 InnoDB: Mutexes and rw_locks use Windows interlocked functi

130314  9:43:27 InnoDB: Compressed tables use zlib 1.2.3

130314  9:43:27 InnoDB: Initializing buffer pool, size = 128.0M

130314  9:43:27 InnoDB: Completed initialization of buffer pool

InnoDB: The first specified data file .\ibdata1 did not exist:

InnoDB: a new database to be created!

130314  9:43:27  InnoDB: Setting file .\ibdata1 size to 10 MB

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

130314  9:43:28  InnoDB: Log file .\ib_logfile0 did not exist: new to be cr

InnoDB: Setting log file .\ib_logfile0 size to 5 MB

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

130314  9:43:28  InnoDB: Log file .\ib_logfile1 did not exist: new to be cr

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: 127 rollback segment(s) active.

InnoDB: Creating foreign key constraint system tables

InnoDB: Foreign key constraint system tables created

130314  9:43:29  InnoDB: Waiting for the background threads to start

130314  9:43:30 InnoDB: 1.1.8 started; log sequence number 0

130314  9:43:30 [Note] Server hostname (bind-address): '0.0.0.0'; port: 330

130314  9:43:30 [Note]   - '0.0.0.0' resolves to '0.0.0.0';

130314  9:43:30 [Note] Server socket created on IP: '0.0.0.0'.

130314  9:43:30 [Note] Event Scheduler: Loaded 0 events

130314  9:43:30 [Note] mysqld: ready for connections.

Version: '5.5.29'  socket: ''  port: 3306  MySQL Community Server (GPL)