首页 > 代码库 > MySQL在windows下的noinstall安装

MySQL在windows下的noinstall安装

1、下载并解压下载的noinstall安装包到指定目录。

2、配置MySQL数据库:

在mysql安装目录下my-default.ini文件中最少添加以下两行,更多的参数以后详细说明:

[mysqld] 

basedir=D:\MySQL\MySQL Server 5.6(mysql所在目录)

datadir=D:\MySQL\MySQL Server 5.6\data (mysql所在目录\data)

3、启动mysql服务:以管理员身份登录cmd,进入mysql的bin目录下,运行mysqld --console:

技术分享

4、登录mysql数据库:

技术分享

6、关闭mysql服务:

技术分享

控制台输出如下:

2016-10-18 14:24:16 15140 [Note] mysqld: Normal shutdown

2016-10-18 14:24:16 15140 [Note] Giving 0 client threads a chance to die gracefu

2016-10-18 14:24:16 15140 [Note] Event Scheduler: Purging the queue. 0 events

2016-10-18 14:24:16 15140 [Note] Shutting down slave threads

2016-10-18 14:24:16 15140 [Note] Forcefully disconnecting 0 remaining clients

2016-10-18 14:24:16 15140 [Note] Binlog end

2016-10-18 14:24:16 15140 [Note] Shutting down plugin ‘partition‘

2016-10-18 14:24:16 15140 [Note] Shutting down plugin ‘PERFORMANCE_SCHEMA‘

2016-10-18 14:24:16 15140 [Note] Shutting down plugin ‘INNODB_SYS_DATAFILES‘

2016-10-18 14:24:16 15140 [Note] Shutting down plugin ‘INNODB_SYS_TABLESPACES‘

2016-10-18 14:24:16 15140 [Note] Shutting down plugin ‘INNODB_SYS_FOREIGN_COLS‘

2016-10-18 14:24:16 15140 [Note] Shutting down plugin ‘INNODB_SYS_FOREIGN‘

2016-10-18 14:24:16 15140 [Note] Shutting down plugin ‘INNODB_SYS_FIELDS‘

2016-10-18 14:24:16 15140 [Note] Shutting down plugin ‘INNODB_SYS_COLUMNS‘

2016-10-18 14:24:16 15140 [Note] Shutting down plugin ‘INNODB_SYS_INDEXES‘

2016-10-18 14:24:16 15140 [Note] Shutting down plugin ‘INNODB_SYS_TABLESTATS‘

2016-10-18 14:24:16 15140 [Note] Shutting down plugin ‘INNODB_SYS_TABLES‘

2016-10-18 14:24:16 15140 [Note] Shutting down plugin ‘INNODB_FT_INDEX_TABLE‘

2016-10-18 14:24:16 15140 [Note] Shutting down plugin ‘INNODB_FT_INDEX_CACHE‘

2016-10-18 14:24:16 15140 [Note] Shutting down plugin ‘INNODB_FT_CONFIG‘

2016-10-18 14:24:16 15140 [Note] Shutting down plugin ‘INNODB_FT_BEING_DELETED‘

2016-10-18 14:24:16 15140 [Note] Shutting down plugin ‘INNODB_FT_DELETED‘

2016-10-18 14:24:16 15140 [Note] Shutting down plugin ‘INNODB_FT_DEFAULT_STOPWOR

2016-10-18 14:24:16 15140 [Note] Shutting down plugin ‘INNODB_METRICS‘

2016-10-18 14:24:16 15140 [Note] Shutting down plugin ‘INNODB_BUFFER_POOL_STATS‘

2016-10-18 14:24:16 15140 [Note] Shutting down plugin ‘INNODB_BUFFER_PAGE_LRU‘

2016-10-18 14:24:16 15140 [Note] Shutting down plugin ‘INNODB_BUFFER_PAGE‘

2016-10-18 14:24:16 15140 [Note] Shutting down plugin ‘INNODB_CMP_PER_INDEX_RESE

2016-10-18 14:24:16 15140 [Note] Shutting down plugin ‘INNODB_CMP_PER_INDEX‘

2016-10-18 14:24:16 15140 [Note] Shutting down plugin ‘INNODB_CMPMEM_RESET‘

2016-10-18 14:24:16 15140 [Note] Shutting down plugin ‘INNODB_CMPMEM‘

2016-10-18 14:24:16 15140 [Note] Shutting down plugin ‘INNODB_CMP_RESET‘

2016-10-18 14:24:16 15140 [Note] Shutting down plugin ‘INNODB_CMP‘

2016-10-18 14:24:16 15140 [Note] Shutting down plugin ‘INNODB_LOCK_WAITS‘

2016-10-18 14:24:16 15140 [Note] Shutting down plugin ‘INNODB_LOCKS‘

2016-10-18 14:24:16 15140 [Note] Shutting down plugin ‘INNODB_TRX‘

2016-10-18 14:24:16 15140 [Note] Shutting down plugin ‘InnoDB‘

2016-10-18 14:24:16 15140 [Note] InnoDB: FTS optimize thread exiting.

2016-10-18 14:24:16 15140 [Note] InnoDB: Starting shutdown...

2016-10-18 14:24:18 15140 [Note] InnoDB: Shutdown completed; log sequence number

2016-10-18 14:24:18 15140 [Note] Shutting down plugin ‘BLACKHOLE‘

2016-10-18 14:24:18 15140 [Note] Shutting down plugin ‘ARCHIVE‘

2016-10-18 14:24:18 15140 [Note] Shutting down plugin ‘MRG_MYISAM‘

2016-10-18 14:24:18 15140 [Note] Shutting down plugin ‘MyISAM‘

2016-10-18 14:24:18 15140 [Note] Shutting down plugin ‘MEMORY‘

2016-10-18 14:24:18 15140 [Note] Shutting down plugin ‘CSV‘

2016-10-18 14:24:18 15140 [Note] Shutting down plugin ‘sha256_password‘

2016-10-18 14:24:18 15140 [Note] Shutting down plugin ‘mysql_old_password‘

2016-10-18 14:24:18 15140 [Note] Shutting down plugin ‘mysql_native_password‘

2016-10-18 14:24:18 15140 [Note] Shutting down plugin ‘binlog‘

2016-10-18 14:24:18 15140 [Note] mysqld: Shutdown complete

MySQL在windows下的noinstall安装