none
XPE安装MYSQL到最后一步 Apply security Settings 总失败! RRS feed

  • 问题

  • MYSQL:我不久前下载的版本是5.5.17

    配置过程中总是在Apply Security Settings这一步卡住,不一会就提示无法连接。错误如下图所示:

     

    下面是我根据网上一些网友在XP下得解决过程中的诊断步骤列出的一些查询状态,看起来都正常。

    ###### netstat -an
    C:\Program Files\MySQL\MySQL Server 5.5\bin>netstat -an

    Active Connections

      Proto  Local Address          Foreign Address        State
      TCP    0.0.0.0:135            0.0.0.0:0              LISTENING
      TCP    0.0.0.0:445            0.0.0.0:0              LISTENING
      TCP    0.0.0.0:3389           0.0.0.0:0              LISTENING
      TCP    169.254.99.173:139     0.0.0.0:0              LISTENING
      TCP    192.168.100.250:139    0.0.0.0:0              LISTENING
      TCP    192.168.100.250:1069   192.168.3.105:3389     ESTABLISHED
      TCP    192.168.100.250:1082   192.168.3.105:445      ESTABLISHED
      TCP    192.168.100.250:1091   192.168.2.1:139        ESTABLISHED
      TCP    [::]:135               [::]:0                 LISTENING       0
      TCP    [::]:3306              [::]:0                 LISTENING       0
      UDP    0.0.0.0:161            *:*
      UDP    0.0.0.0:445            *:*
      UDP    0.0.0.0:500            *:*
      UDP    0.0.0.0:4500           *:*
      UDP    127.0.0.1:123          *:*
      UDP    127.0.0.1:1025         *:*
      UDP    169.254.99.173:123     *:*
      UDP    169.254.99.173:137     *:*
      UDP    169.254.99.173:138     *:*
      UDP    192.168.100.250:123    *:*
      UDP    192.168.100.250:137    *:*
      UDP    192.168.100.250:138    *:*

     

    #####netstat -a -b
    TCP    OEM-WWC6OII2P4A:3306   [::]:0                 LISTENING       700
    [mysqld.exe]

     

    #####telnet
    C:\Program Files\MySQL\MySQL Server 5.5\bin>telnet localhost 3306
    正在连接到localhost...不能打开到主机的连接, 在端口 3306: 连接失败

     

    #####ping
    C:\Program Files\MySQL\MySQL Server 5.5\bin>ping localhost

    Pinging OEM-WWC6OII2P4A [127.0.0.1] with 32 bytes of data:

    Reply from 127.0.0.1: bytes=32 time<1ms TTL=128
    Reply from 127.0.0.1: bytes=32 time<1ms TTL=128
    Reply from 127.0.0.1: bytes=32 time<1ms TTL=128
    Reply from 127.0.0.1: bytes=32 time<1ms TTL=128

    Ping statistics for 127.0.0.1:
        Packets: Sent = 4, Received = 4, Lost = 0 (0% loss),
    Approximate round trip times in milli-seconds:
        Minimum = 0ms, Maximum = 0ms, Average = 0ms

     

    XPE中我添加了MySQLInstanceConfig.exe所依赖的DLL。

    包含: DBGHELP.DLL、CDFVIEW.DLL、PRINTUI.DLL、W32TOPL.DLL、MOBSYNC.DLL,还有一个MSJAVA.DLL,这个我没有添加,因为我在自己的XP主机上没有这个文件但是正常安装了同版本的MYSQL。

     

    我搜索了论坛上有关MYSQL的帖子,仅有4个结果,只有1个结果真正的与MYSQL有关,但是里面是安装完成后的问题,并不是安装过程中的问题。

    不清楚还需要添加什么组件才可以解决这个问题?

    2011年11月3日 10:04

答案

  • 问题已得到解决:

    仔细对比了XPE跟XP在netstat命令显示的区别,发现下面这句可能有问题:

     TCP    [::]:3306              [::]:0                 LISTENING       0

    正常XP下[::]应该是[0.0.0.0],而[::]看起来像个IPV6的地址。于是我卸载了IPV6协议,重新执行netstat显示正常,telnet localhost 3306连接正常,至此问题就解决了。

     

    还是要感谢happymy的回复。谢谢!

    2011年11月4日 1:55

全部回复

  • 请贴出来你MYSQL的安装日志!

    安装的log!


    Zhengbo.Xiao
    深圳艾斯威特贸易有限公司
    计算机、嵌入式是产品硬件、软件销售、Windows Embedded解决方案提供商。
    我的WIndows Embedded中文技术BLOG:
    www.XPE.cc
    blog搬家了,欢迎访问: http://questor87.wordpress.com/
    为解决大陆的Windows Embedded的开发者无法访问http://questor87.wordpress.com/,特从2010年11月起,在
    QQ:1320232327(另外两个已满)
    MSN:questor_87@hotmail.com
    MCTS:
    Windows Embedded Standard 7 Development
    Windows Embedded Standard 2009 Development
    Windows Embedded Standard CE Development
    Microsoft MVP(2010)
    2011年11月3日 13:59
    版主
  • #下面是mysql安装日志hostname.err的内容

    010101  5:36:42 [Note] Plugin 'FEDERATED' is disabled.
    010101  5:36:42 InnoDB: The InnoDB memory heap is disabled
    010101  5:36:42 InnoDB: Mutexes and rw_locks use Windows interlocked functions
    010101  5:36:42 InnoDB: Compressed tables use zlib 1.2.3
    010101  5:36:43 InnoDB: Initializing buffer pool, size = 17.0M
    010101  5:36:43 InnoDB: Completed initialization of buffer pool
    InnoDB: The first specified data file C:\MySQL Datafiles\ibdata1 did not exist:
    InnoDB: a new database to be created!
    010101  5:36:43  InnoDB: Setting file C:\MySQL Datafiles\ibdata1 size to 10 MB
    InnoDB: Database physically writes the file full: wait...
    010101  5:36:43  InnoDB: Log file .\ib_logfile0 did not exist: new to be created
    InnoDB: Setting log file .\ib_logfile0 size to 10 MB
    InnoDB: Database physically writes the file full: wait...
    010101  5:36:43  InnoDB: Log file .\ib_logfile1 did not exist: new to be created
    InnoDB: Setting log file .\ib_logfile1 size to 10 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
    010101  5:36:43  InnoDB: Waiting for the background threads to start
    010101  5:36:44 InnoDB: 1.1.8 started; log sequence number 0
    010101  5:36:44 [Note] Event Scheduler: Loaded 0 events
    010101  5:36:44 [Note] C:\Program Files\MySQL\MySQL Server 5.5\bin\mysqld: ready for connections.
    Version: '5.5.17'  socket: ''  port: 3306  MySQL Community Server (GPL)
    010101  5:40:59 [Note] C:\Program Files\MySQL\MySQL Server 5.5\bin\mysqld: Normal shutdown

    010101  5:40:59 [Note] Event Scheduler: Purging the queue. 0 events
    010101  5:40:59  InnoDB: Starting shutdown...
    010101  5:41:00  InnoDB: Shutdown completed; log sequence number 1595675
    010101  5:41:00 [Note] C:\Program Files\MySQL\MySQL Server 5.5\bin\mysqld: Shutdown complete

    010101  5:52:59 [Note] Plugin 'FEDERATED' is disabled.
    010101  5:52:59 InnoDB: The InnoDB memory heap is disabled
    010101  5:52:59 InnoDB: Mutexes and rw_locks use Windows interlocked functions
    010101  5:52:59 InnoDB: Compressed tables use zlib 1.2.3
    010101  5:52:59 InnoDB: Initializing buffer pool, size = 17.0M
    010101  5:52:59 InnoDB: Completed initialization of buffer pool
    010101  5:52:59 InnoDB: highest supported file format is Barracuda.
    010101  5:52:59  InnoDB: Waiting for the background threads to start
    010101  5:53:00 InnoDB: 1.1.8 started; log sequence number 1595675
    010101  5:53:00 [Note] Event Scheduler: Loaded 0 events
    010101  5:53:00 [Note] C:\Program Files\MySQL\MySQL Server 5.5\bin\mysqld: ready for connections.
    Version: '5.5.17'  socket: ''  port: 3306  MySQL Community Server (GPL)
    010101  6:23:43 [Note] C:\Program Files\MySQL\MySQL Server 5.5\bin\mysqld: Normal shutdown

    010101  6:23:43 [Note] Event Scheduler: Purging the queue. 0 events
    010101  6:23:43  InnoDB: Starting shutdown...
    010101  6:23:44  InnoDB: Shutdown completed; log sequence number 1595675
    010101  6:23:44 [Note] C:\Program Files\MySQL\MySQL Server 5.5\bin\mysqld: Shutdown complete

    010101  6:24:04 [Note] Plugin 'FEDERATED' is disabled.
    010101  6:24:04 InnoDB: The InnoDB memory heap is disabled
    010101  6:24:04 InnoDB: Mutexes and rw_locks use Windows interlocked functions
    010101  6:24:04 InnoDB: Compressed tables use zlib 1.2.3
    010101  6:24:04 InnoDB: Initializing buffer pool, size = 17.0M
    010101  6:24:04 InnoDB: Completed initialization of buffer pool
    010101  6:24:04 InnoDB: highest supported file format is Barracuda.
    010101  6:24:04  InnoDB: Waiting for the background threads to start
    010101  6:24:05 InnoDB: 1.1.8 started; log sequence number 1595675
    010101  6:24:05 [Note] Event Scheduler: Loaded 0 events
    010101  6:24:05 [Note] MySQL: ready for connections.
    Version: '5.5.17'  socket: ''  port: 3306  MySQL Community Server (GPL)
    010101  7:01:22 [Note] MySQL: Normal shutdown

    010101  7:01:22 [Note] Event Scheduler: Purging the queue. 0 events
    010101  7:01:22  InnoDB: Starting shutdown...
    010101  7:01:23  InnoDB: Shutdown completed; log sequence number 1595675
    010101  7:01:23 [Note] MySQL: Shutdown complete

    010101  7:01:23 [Note] Plugin 'FEDERATED' is disabled.
    010101  7:01:23 InnoDB: The InnoDB memory heap is disabled
    010101  7:01:23 InnoDB: Mutexes and rw_locks use Windows interlocked functions
    010101  7:01:23 InnoDB: Compressed tables use zlib 1.2.3
    010101  7:01:24 InnoDB: Initializing buffer pool, size = 17.0M
    010101  7:01:24 InnoDB: Completed initialization of buffer pool
    010101  7:01:24 InnoDB: highest supported file format is Barracuda.
    010101  7:01:24  InnoDB: Waiting for the background threads to start
    010101  7:01:25 InnoDB: 1.1.8 started; log sequence number 1595675
    010101  7:01:25 [Note] Event Scheduler: Loaded 0 events
    010101  7:01:25 [Note] MySQL: ready for connections.
    Version: '5.5.17'  socket: ''  port: 3306  MySQL Community Server (GPL)
    010101  7:56:45 [Note] MySQL: Normal shutdown

    010101  7:56:45 [Note] Event Scheduler: Purging the queue. 0 events
    010101  7:56:45  InnoDB: Starting shutdown...
    010101  7:56:45  InnoDB: Shutdown completed; log sequence number 1595675
    010101  7:56:45 [Note] MySQL: Shutdown complete

    010101  7:58:15 [Note] Plugin 'FEDERATED' is disabled.
    010101  7:58:15 InnoDB: The InnoDB memory heap is disabled
    010101  7:58:15 InnoDB: Mutexes and rw_locks use Windows interlocked functions
    010101  7:58:15 InnoDB: Compressed tables use zlib 1.2.3
    010101  7:58:16 InnoDB: Initializing buffer pool, size = 17.0M
    010101  7:58:16 InnoDB: Completed initialization of buffer pool
    010101  7:58:16 InnoDB: highest supported file format is Barracuda.
    010101  7:58:16  InnoDB: Waiting for the background threads to start
    010101  7:58:17 InnoDB: 1.1.8 started; log sequence number 1595675
    010101  7:58:17 [Note] Event Scheduler: Loaded 0 events
    010101  7:58:17 [Note] MySQL: ready for connections.
    Version: '5.5.17'  socket: ''  port: 3306  MySQL Community Server (GPL)
    010101  8:33:59 [Note] MySQL: Normal shutdown

    010101  8:33:59 [Note] Event Scheduler: Purging the queue. 0 events
    010101  8:33:59  InnoDB: Starting shutdown...
    010101  8:34:00  InnoDB: Shutdown completed; log sequence number 1595675
    010101  8:34:00 [Note] MySQL: Shutdown complete

    010101  0:00:16 [Note] Plugin 'FEDERATED' is disabled.
    010101  0:00:16 InnoDB: The InnoDB memory heap is disabled
    010101  0:00:16 InnoDB: Mutexes and rw_locks use Windows interlocked functions
    010101  0:00:16 InnoDB: Compressed tables use zlib 1.2.3
    010101  0:00:17 InnoDB: Initializing buffer pool, size = 17.0M
    010101  0:00:17 InnoDB: Completed initialization of buffer pool
    010101  0:00:17 InnoDB: highest supported file format is Barracuda.
    010101  0:00:17  InnoDB: Waiting for the background threads to start
    010101  0:00:18 InnoDB: 1.1.8 started; log sequence number 1595675
    010101  0:00:18 [Note] Event Scheduler: Loaded 0 events
    010101  0:00:18 [Note] MySQL: ready for connections.
    Version: '5.5.17'  socket: ''  port: 3306  MySQL Community Server (GPL)

     

    2011年11月4日 0:52
  • 问题已得到解决:

    仔细对比了XPE跟XP在netstat命令显示的区别,发现下面这句可能有问题:

     TCP    [::]:3306              [::]:0                 LISTENING       0

    正常XP下[::]应该是[0.0.0.0],而[::]看起来像个IPV6的地址。于是我卸载了IPV6协议,重新执行netstat显示正常,telnet localhost 3306连接正常,至此问题就解决了。

     

    还是要感谢happymy的回复。谢谢!

    2011年11月4日 1:55