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:

wps454E.tmp

4、登录mysql数据库:

wps454F.tmp

6、关闭mysql服务:

wps4550.tmp

控制台输出如下:

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

posted @   ChavinKing  阅读(237)  评论(0编辑  收藏  举报
编辑推荐:
· Linux系列:如何用heaptrack跟踪.NET程序的非托管内存泄露
· 开发者必知的日志记录最佳实践
· SQL Server 2025 AI相关能力初探
· Linux系列:如何用 C#调用 C方法造成内存泄露
· AI与.NET技术实操系列(二):开始使用ML.NET
阅读排行:
· 无需6万激活码!GitHub神秘组织3小时极速复刻Manus,手把手教你使用OpenManus搭建本
· C#/.NET/.NET Core优秀项目和框架2025年2月简报
· Manus爆火,是硬核还是营销?
· 终于写完轮子一部分:tcp代理 了,记录一下
· 【杭电多校比赛记录】2025“钉耙编程”中国大学生算法设计春季联赛(1)
点击右上角即可分享
微信分享提示