mysql远程访问

txwdhs

目前结构一主一从，把从的数据目录挂载到了另外一个服务器上，另外一台服务器mount上后，在配置文件的datadir路径写的mount 的路径，等于是让新服务器去访问从的数据，主从已经搭好，无论停不停那个从机，新服务器的mysql都启动不了，详见以下错误信息：

110628 10:45:36 mysqld_safe mysqld from pid file /data/mysql3/localhost.pid ended

110628 10:45:36 [Note] /usr/local/mysql/bin/mysqld: Shutdown complete

110628 10:45:36 [ERROR] Aborting
110628 10:45:36 [ERROR] Do you already have another mysqld server running on port: 3309 ?
110628 10:45:36 [ERROR] Can't start server: Bind on TCP/IP port: Address already in use
110628 10:45:36 [Note] Plugin 'InnoDB' is disabled.
110628 10:45:36 [Note] Plugin 'FEDERATED' is disabled.
110628 10:45:36 [Warning] '--default-character-set' is deprecated and will be removed in a future release. Please use '--character-set-server' instead.
110628 10:45:36 [Warning] 'for replication startup options' is deprecated and will be removed in a future release. Please use ''CHANGE MASTER'' instead.
110628 10:45:36 [Warning] '--log' is deprecated and will be removed in a future release. Please use ''--general_log'/'--general_log_file'' instead.
110628 10:45:36 [Warning] '--skip-locking' is deprecated and will be removed in a future release. Please use '--skip-external-locking' instead.
110628 10:45:36 mysqld_safe Starting mysqld daemon with databases from /data/mysql3
110628 10:43:44 mysqld_safe mysqld from pid file /data/mysql3/localhost.pid ended

请问高手该怎么解决？

horizonhyg

回复 1# txwdhs


    启动的mysql没有关掉，建议kill干净~~~你的是5。5吧？有些参数低版本的不适用，建议查找更换。

horizonhyg

启动的mysql没有关掉，建议kill干净，然后重新启动~~~你的是5。5吧？有些参数高版本的不适用，建议查找更换。

txwdhs

5.1的，这个问题已经好了，我启动好了从，主从状态也正常，可是新的服务器的不支持Innodb，我把配置文件里的skip-Innodb前面加了#，然后就启动不了mysql了，报错如下：
110628 11:16:29  InnoDB: Completed initialization of buffer pool
110628 11:16:28  InnoDB: Initializing buffer pool, size = 512.0M
110628 11:16:28 [Note] Plugin 'FEDERATED' is disabled.
110628 11:16:28 [Warning] '--default-character-set' is deprecated and will be removed in a future release. Please use '--character-set-server' instead.
110628 11:16:28 [Warning] 'for replication startup options' is deprecated and will be removed in a future release. Please use ''CHANGE MASTER'' instead.
110628 11:16:28 [Warning] '--log' is deprecated and will be removed in a future release. Please use ''--general_log'/'--general_log_file'' instead.
110628 11:16:28 [Warning] '--skip-locking' is deprecated and will be removed in a future release. Please use '--skip-external-locking' instead.
110628 11:16:28 mysqld_safe Starting mysqld daemon with databases from /data/mysql3
110628 11:05:32 [ERROR] Error running query, slave SQL thread aborted. Fix the problem, and restart the slave SQL thread with "SLAVE START". We stopped at log 'mysql-bi
n.000009' position 822
110628 11:05:32 [Warning] Slave: Unknown table engine 'InnoDB' Error_code: 1286
110628 11:05:32 [ERROR] Slave SQL: Error 'Unknown table engine 'InnoDB'' on query

为什么不支持Innodb了呢，我这3台机器都是安的同样的mysql，同样的操作系统，编译进去了Innodb

horizonhyg

回复 4# txwdhs


    我也没有遇到过，看一下这个帖子吧 http://bbs.chinaunix.net/viewthread.php?tid=1592425