My SQL 安装不成功,求高手指导!!! My SQL 安装不成功,求高手指导 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 直接下载一个免安装的ZIP版本的文件,然后解压后直接运行。 谢谢,我试过了,MySQL在服务里面启动了但是停止不了,很奇怪,不知道到底出了什么问题 MYSQL在什么地方下载,是完全版的? 上面已经很明确提示你了,你的这个MYSQL安装程序包用于商业用途,需要一个GPL LICENCE,你另外下一个MYSQL的安装包或者是找一个WAMP的集成环境安装包就可以了 https://edelivery.oracle.com/EPD/Search/handle_go 这个里面我下载了1.【MySQL Database 5.6.14 ZIP for Windows x86 (32bit)】 解压后按照百度的方法设置,服务也启动了,但是服务器不能手动停止及启动2.【MySQL Installer 5.6.14.0 Package】 安装时也是提示GPL LICENCE 直接到官网下载。http://dev.mysql.com/downloads/mysql/ 不先MSI版本,直接选ZIP版,然后解压,还有什么问题可以直接贴出来。 现在下载的是免安装版 5.6.14 32位,XP系统在C盘,解压到D:\Program Files\mysql-5.6.14-win32(不想放C盘),配置步骤如下:一.配置my.ini文件,1.C、D盘根目录及windows目录下还有解压目录都保存该文件(抄网上的)2.只在解压目录有配置文件3.my.ini文件内容如下[client]port=3306default-character-set=utf8[mysqld]port=3306character_set_server=utf8basedir=D:\Program Files\mysql-5.6.14-win32#D:\Program Files\mysql-5.6.14-win32这样的也试过了basedir=D:\Program Files\mysql-5.6.14-win32\data#D:\Program Files\mysql-5.6.14-win32\data这样的也试过了sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES[WinMySQLAdmin]D:\Program Files\mysql-5.6.14-win32\bin\mysqld.exe #Server=D:\Program Files\mysql-5.6.14-win32\bin\mysqld.exe这样的也试过了二.配置了环境变量也完成MYSQL_HOME D:\Program Files\mysql-5.6.14-win32path后面加上;%MYSQL_HOME%\bin三.安装注册提示:Service successfully installed,也没问题四.启动时提示五.在data目录下的.err文件内容如下2013-12-02 23:58:43 5684 [Note] Plugin 'FEDERATED' is disabled.2013-12-02 23:58:43 5684 [Note] InnoDB: The InnoDB memory heap is disabled2013-12-02 23:58:43 5684 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions2013-12-02 23:58:43 5684 [Note] InnoDB: Compressed tables use zlib 1.2.32013-12-02 23:58:43 5684 [Note] InnoDB: Not using CPU crc32 instructions2013-12-02 23:58:43 5684 [Note] InnoDB: Initializing buffer pool, size = 128.0M2013-12-02 23:58:43 5684 [Note] InnoDB: Completed initialization of buffer pool2013-12-02 23:58:43 5684 [Note] InnoDB: Highest supported file format is Barracuda.2013-12-02 23:58:43 5684 [Note] InnoDB: 128 rollback segment(s) are active.2013-12-02 23:58:43 5684 [Note] InnoDB: Waiting for purge to start2013-12-02 23:58:43 5684 [Note] InnoDB: 5.6.14 started; log sequence number 16260472013-12-02 23:58:43 5684 [ERROR] D:\Program Files\mysql-5.6.14-win32\bin\mysqld: unknown option '--D:\Program Files\mysql-5.6.14-win32'2013-12-02 23:58:43 5684 [ERROR] Aborting2013-12-02 23:58:43 5684 [Note] Binlog end2013-12-02 23:58:43 5684 [Note] Shutting down plugin 'partition'2013-12-02 23:58:43 5684 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'2013-12-02 23:58:43 5684 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'2013-12-02 23:58:43 5684 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'2013-12-02 23:58:43 5684 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'2013-12-02 23:58:43 5684 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'2013-12-02 23:58:43 5684 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'2013-12-02 23:58:43 5684 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'2013-12-02 23:58:43 5684 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'2013-12-02 23:58:43 5684 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'2013-12-02 23:58:43 5684 [Note] Shutting down plugin 'INNODB_SYS_TABLES'2013-12-02 23:58:43 5684 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'2013-12-02 23:58:43 5684 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'2013-12-02 23:58:43 5684 [Note] Shutting down plugin 'INNODB_FT_CONFIG'2013-12-02 23:58:43 5684 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'2013-12-02 23:58:43 5684 [Note] Shutting down plugin 'INNODB_FT_DELETED'2013-12-02 23:58:43 5684 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'2013-12-02 23:58:43 5684 [Note] Shutting down plugin 'INNODB_METRICS'2013-12-02 23:58:43 5684 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'2013-12-02 23:58:43 5684 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'2013-12-02 23:58:43 5684 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'2013-12-02 23:58:43 5684 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'2013-12-02 23:58:43 5684 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'2013-12-02 23:58:43 5684 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'2013-12-02 23:58:43 5684 [Note] Shutting down plugin 'INNODB_CMPMEM'2013-12-02 23:58:43 5684 [Note] Shutting down plugin 'INNODB_CMP_RESET'2013-12-02 23:58:43 5684 [Note] Shutting down plugin 'INNODB_CMP'2013-12-02 23:58:43 5684 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'2013-12-02 23:58:43 5684 [Note] Shutting down plugin 'INNODB_LOCKS'2013-12-02 23:58:43 5684 [Note] Shutting down plugin 'INNODB_TRX'2013-12-02 23:58:43 5684 [Note] Shutting down plugin 'InnoDB'2013-12-02 23:58:43 5684 [Note] InnoDB: FTS optimize thread exiting.2013-12-02 23:58:43 5684 [Note] InnoDB: Starting shutdown...2013-12-02 23:58:45 5684 [Note] InnoDB: Shutdown completed; log sequence number 16260572013-12-02 23:58:45 5684 [Note] Shutting down plugin 'BLACKHOLE'2013-12-02 23:58:45 5684 [Note] Shutting down plugin 'ARCHIVE'2013-12-02 23:58:45 5684 [Note] Shutting down plugin 'MRG_MYISAM'2013-12-02 23:58:45 5684 [Note] Shutting down plugin 'MyISAM'2013-12-02 23:58:45 5684 [Note] Shutting down plugin 'MEMORY'2013-12-02 23:58:45 5684 [Note] Shutting down plugin 'CSV'2013-12-02 23:58:45 5684 [Note] Shutting down plugin 'sha256_password'2013-12-02 23:58:45 5684 [Note] Shutting down plugin 'mysql_old_password'2013-12-02 23:58:45 5684 [Note] Shutting down plugin 'mysql_native_password'2013-12-02 23:58:45 5684 [Note] Shutting down plugin 'binlog'2013-12-02 23:58:45 5684 [Note] D:\Program Files\mysql-5.6.14-win32\bin\mysqld: Shutdown complete 2013-12-02 23:58:43 5684 [ERROR] D:\Program Files\mysql-5.6.14-win32\bin\mysqld: unknown option '--D:\Program Files\mysql-5.6.14-win32'2013-12-02 23:58:43 5684 [ERROR] Aborting检查一下WINDOWS的服务中的MYSQL服务项的image内容,可以从注册表中直接删除后面的参数。或者直接在命令行中执行 D:\Program Files\mysql-5.6.14-win32\bin\mysqld --console保持这个进程的运行,然后可以从其它窗口进行登录操作。 basedir="D:/Program Files/mysql-5.6.14-win32/"试试 有时候服务无法启动可能是my.ini配置文件有错误 http://download.csdn.net/detail/iihero/6604375自动帮你下载并安装. 新人求教,MySQL安装问题 带输出变量的存储过程调用问题 数据库文件800多兆....怎么导不进去? MySQL菜鸟问题··· mysql 从 csv 导入数据,中文成乱码的疑惑, 如何在windows xp下建立myssql的数据源? 安装mysql5.6.10 在cmd中输入net start mysql提示服务名无效 存储过程返回记录在表中的行号问题 cmd命令下创建表出错 SQL插入字段值 sql 中怎么改变设置了主键外键约束的列的变量 创建表的时候里面有一个字段的类型是LongBlob请问插入sql语句应该如何写
https://edelivery.oracle.com/EPD/Search/handle_go 这个里面我下载了
1.【MySQL Database 5.6.14 ZIP for Windows x86 (32bit)】
解压后按照百度的方法设置,服务也启动了,但是服务器不能手动停止及启动
2.【MySQL Installer 5.6.14.0 Package】
安装时也是提示GPL LICENCE
配置步骤如下:
一.配置my.ini文件,
1.C、D盘根目录及windows目录下还有解压目录都保存该文件(抄网上的)
2.只在解压目录有配置文件
3.my.ini文件内容如下[client]
port=3306
default-character-set=utf8
[mysqld]
port=3306
character_set_server=utf8
basedir=D:\Program Files\mysql-5.6.14-win32
#D:\Program Files\mysql-5.6.14-win32这样的也试过了
basedir=D:\Program Files\mysql-5.6.14-win32\data
#D:\Program Files\mysql-5.6.14-win32\data这样的也试过了
sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES
[WinMySQLAdmin]
D:\Program Files\mysql-5.6.14-win32\bin\mysqld.exe
#Server=D:\Program Files\mysql-5.6.14-win32\bin\mysqld.exe这样的也试过了二.配置了环境变量也完成
MYSQL_HOME D:\Program Files\mysql-5.6.14-win32
path后面加上;%MYSQL_HOME%\bin三.安装注册提示:Service successfully installed,也没问题
四.启动时提示五.在data目录下的.err文件内容如下2013-12-02 23:58:43 5684 [Note] Plugin 'FEDERATED' is disabled.
2013-12-02 23:58:43 5684 [Note] InnoDB: The InnoDB memory heap is disabled
2013-12-02 23:58:43 5684 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2013-12-02 23:58:43 5684 [Note] InnoDB: Compressed tables use zlib 1.2.3
2013-12-02 23:58:43 5684 [Note] InnoDB: Not using CPU crc32 instructions
2013-12-02 23:58:43 5684 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2013-12-02 23:58:43 5684 [Note] InnoDB: Completed initialization of buffer pool
2013-12-02 23:58:43 5684 [Note] InnoDB: Highest supported file format is Barracuda.
2013-12-02 23:58:43 5684 [Note] InnoDB: 128 rollback segment(s) are active.
2013-12-02 23:58:43 5684 [Note] InnoDB: Waiting for purge to start
2013-12-02 23:58:43 5684 [Note] InnoDB: 5.6.14 started; log sequence number 1626047
2013-12-02 23:58:43 5684 [ERROR] D:\Program Files\mysql-5.6.14-win32\bin\mysqld: unknown option '--D:\Program Files\mysql-5.6.14-win32'
2013-12-02 23:58:43 5684 [ERROR] Aborting2013-12-02 23:58:43 5684 [Note] Binlog end
2013-12-02 23:58:43 5684 [Note] Shutting down plugin 'partition'
2013-12-02 23:58:43 5684 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
2013-12-02 23:58:43 5684 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
2013-12-02 23:58:43 5684 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
2013-12-02 23:58:43 5684 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
2013-12-02 23:58:43 5684 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
2013-12-02 23:58:43 5684 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
2013-12-02 23:58:43 5684 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
2013-12-02 23:58:43 5684 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'
2013-12-02 23:58:43 5684 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'
2013-12-02 23:58:43 5684 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
2013-12-02 23:58:43 5684 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
2013-12-02 23:58:43 5684 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
2013-12-02 23:58:43 5684 [Note] Shutting down plugin 'INNODB_FT_CONFIG'
2013-12-02 23:58:43 5684 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'
2013-12-02 23:58:43 5684 [Note] Shutting down plugin 'INNODB_FT_DELETED'
2013-12-02 23:58:43 5684 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
2013-12-02 23:58:43 5684 [Note] Shutting down plugin 'INNODB_METRICS'
2013-12-02 23:58:43 5684 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
2013-12-02 23:58:43 5684 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
2013-12-02 23:58:43 5684 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
2013-12-02 23:58:43 5684 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'
2013-12-02 23:58:43 5684 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'
2013-12-02 23:58:43 5684 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'
2013-12-02 23:58:43 5684 [Note] Shutting down plugin 'INNODB_CMPMEM'
2013-12-02 23:58:43 5684 [Note] Shutting down plugin 'INNODB_CMP_RESET'
2013-12-02 23:58:43 5684 [Note] Shutting down plugin 'INNODB_CMP'
2013-12-02 23:58:43 5684 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
2013-12-02 23:58:43 5684 [Note] Shutting down plugin 'INNODB_LOCKS'
2013-12-02 23:58:43 5684 [Note] Shutting down plugin 'INNODB_TRX'
2013-12-02 23:58:43 5684 [Note] Shutting down plugin 'InnoDB'
2013-12-02 23:58:43 5684 [Note] InnoDB: FTS optimize thread exiting.
2013-12-02 23:58:43 5684 [Note] InnoDB: Starting shutdown...
2013-12-02 23:58:45 5684 [Note] InnoDB: Shutdown completed; log sequence number 1626057
2013-12-02 23:58:45 5684 [Note] Shutting down plugin 'BLACKHOLE'
2013-12-02 23:58:45 5684 [Note] Shutting down plugin 'ARCHIVE'
2013-12-02 23:58:45 5684 [Note] Shutting down plugin 'MRG_MYISAM'
2013-12-02 23:58:45 5684 [Note] Shutting down plugin 'MyISAM'
2013-12-02 23:58:45 5684 [Note] Shutting down plugin 'MEMORY'
2013-12-02 23:58:45 5684 [Note] Shutting down plugin 'CSV'
2013-12-02 23:58:45 5684 [Note] Shutting down plugin 'sha256_password'
2013-12-02 23:58:45 5684 [Note] Shutting down plugin 'mysql_old_password'
2013-12-02 23:58:45 5684 [Note] Shutting down plugin 'mysql_native_password'
2013-12-02 23:58:45 5684 [Note] Shutting down plugin 'binlog'
2013-12-02 23:58:45 5684 [Note] D:\Program Files\mysql-5.6.14-win32\bin\mysqld: Shutdown complete
2013-12-02 23:58:43 5684 [ERROR] Aborting
检查一下WINDOWS的服务中的MYSQL服务项的image内容,可以从注册表中直接删除后面的参数。或者直接在命令行中执行 D:\Program Files\mysql-5.6.14-win32\bin\mysqld --console
保持这个进程的运行,然后可以从其它窗口进行登录操作。
试试