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)