win7免安装mysql配置使用

shift8

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