mysq绿色版装配

mysq绿色版安装
下载绿色版的mysql5.5.9
解压到 D:\development\

命令行进入该目录
先测试一下能不能用

bin\mysqld --console

成功后就启动了mysql程序。

再打开个命令行

bin\mysql -uroot -p

这里密码默认为空，直接回车就可以了
登陆成功后可以修改密码

安装mysql服务到系统：

bin\mysqld --install mysql55--defaults-file="D:\development\mysql\my.ini"

启动服务

net start mysql55

停止服务：
net stop mysql55

删除服务：

bin\mysqld --remove mysql55

my.ini如下：

[client]port=33067[mysql][mysqld]port=33067innodb_flush_log_at_trx_commit=2interactive_timeout=3600wait_timeout=3600default-storage-engine=innodbmax_connections=100tmp_table_size=35Mthread_cache_size=4query_cache_size=0table_open_cache =256#basedir=..\#datadir=..\data\#table_cache=256#*** MyISAM Specific optionskey_buffer_size = 64Mmyisam_sort_buffer_size = 16Mmax_allowed_packet = 1Msort_buffer_size = 256Kread_buffer_size = 256Kread_rnd_buffer_size = 1M#*** INNODB Specific options ***innodb_buffer_pool_size = 256Minnodb_log_file_size = 64Minnodb_log_buffer_size = 8Minnodb_additional_mem_pool_size = 20Minnodb_lock_wait_timeout = 50innodb_thread_concurrency=4#innodb_data_home_dir=..\data\basedir=D:\development\mysqldatadir=D:\development\mysql\data

安装bat脚本：

set SugarNMS_HOME=%cd%net stop mysql55%SugarNMS_HOME%\bin\mysqld --remove mysql55%SugarNMS_HOME%\bin\mysqld --install mysql55 --defaults-file="%SugarNMS_HOME%\my.ini"echo Try to start the mysql55 deamon as service ... net start mysql55 

查看更多 下一篇