mysql Could not alloc node id 簇问题（巳解决）

错误现象：Configuration error: Error : Could not alloc node id at 192.168.5.254 port 1186: Connection done from wrong host ip 192.168.5.45.
所有其它正常，在管节点上用show查看所有存储节点与sql节点正常 ，管理节点配置文件如下
#options affecting ndbd processes on all data nodes:

[NDBD DEFAULT]

NoOfReplicas=2    # Number of replicas

DataMemory=180M    # How much memory to allocate for data storage

IndexMemory=80M   # How much memory to allocate for index storage

                  # For DataMemory and IndexMemory, we have used the

                  # default values. Since the "world" database takes up

                  # only about 500KB, this should be more than enough for

                  # this example Cluster setup.



# TCP/IP options:

[TCP DEFAULT]

portnumber=2202   # This the default; however, you can use any

                  # port that is free for all the hosts in cluster

                  # Note: It is recommended beginning with MySQL 5.0 that

                  # you do not specify the portnumber at all and simply allow

                  # the default value to be used instead



# Management process options:

[NDB_MGMD]
id=1
hostname=192.168.5.254           # Hostname or IP address of MGM node

datadir=/var/lib/mysql-cluster  # Directory for MGM node logfiles



# Options for data node "A":

[NDBD]

                                # (one [NDBD] section per data node)
id=2
hostname=192.168.5.45           # Hostname or IP address

datadir=/usr/local/mysql/data   # Directory for this data node's datafiles


# Options for data node "B":

[NDBD]
id=3
hostname=192.168.5.30          # Hostname or IP address

datadir=/usr/local/mysql/data   # Directory for this data node's datafiles



# SQL node options:

[MYSQLD]
id=4
hostname=192.168.5.238           # Hostname or IP address

                                # (additional mysqld connections can be

                                # specified for this node for various

                                # purposes such as running ndb_restore)

后另添加了跟数据存储节点一样的两个[MYSQLD]空选项，一切运行正常。如下是我更改后的管理节点配置文件
红色部分为我新添加的选项
[NDBD DEFAULT]

NoOfReplicas=2    # Number of replicas

DataMemory=180M    # How much memory to allocate for data storage

IndexMemory=80M   # How much memory to allocate for index storage

                  # For DataMemory and IndexMemory, we have used the

                  # default values. Since the "world" database takes up

                  # only about 500KB, this should be more than enough for

                  # this example Cluster setup.



# TCP/IP options:

[TCP DEFAULT]

portnumber=2202   # This the default; however, you can use any

                  # port that is free for all the hosts in cluster

                  # Note: It is recommended beginning with MySQL 5.0 that

                  # you do not specify the portnumber at all and simply allow

                  # the default value to be used instead



# Management process options:

[NDB_MGMD]
id=1
hostname=192.168.5.254           # Hostname or IP address of MGM node

datadir=/var/lib/mysql-cluster  # Directory for MGM node logfiles



# Options for data node "A":

[NDBD]

                                # (one [NDBD] section per data node)
id=2
hostname=192.168.5.45           # Hostname or IP address

datadir=/usr/local/mysql/data   # Directory for this data node's datafiles


# Options for data node "B":

[NDBD]
id=3
hostname=192.168.5.30          # Hostname or IP address

datadir=/usr/local/mysql/data   # Directory for this data node's datafiles



# SQL node options:

[MYSQLD]
id=4
hostname=192.168.5.238           # Hostname or IP address

                                # (additional mysqld connections can be

                                # specified for this node for various

                                # purposes such as running ndb_restore)
［MYSQLD］
［MYSQLD］