欢迎您访问程序员文章站本站旨在为大家提供分享程序员计算机编程知识!
您现在的位置是: 首页

win7免安装mysql配置使用 博客分类: 每天的收获点点滴滴 MySQLwin7免安装配置中文乱码 

程序员文章站 2024-03-18 18:20:22
...

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)