mysql集群sql节点无法启动问题_无法在Mysql集群中启动SQL节点

mysqld:[错误]无法打开所需的默认文件

所以我检查了文件的权限。我看起来像这样:

drwxrwxr-x 3 mysql ubuntu 4096 Sep 10 03:00 1

drwxrwxr-x 3 mysql ubuntu 4096 Sep 10 03:00 2

drwxrwxr-x 2 mysql ubuntu 4096 Sep 10 03:30 49

drwxrwxr-x 5 mysql ubuntu 4096 Sep 10 03:03 53

-rw-rw-r-- 1 mysql ubuntu 214 Sep 10 03:25 my.cnf

drwxrwxr-x 2 mysql ubuntu 4096 Sep 10 03:00 mysql

drwxrwxr-x 2 mysql ubuntu 4096 Sep 10 03:00 test

drwxrwxr-x 2 mysql ubuntu 4096 Sep 10 03:00 tmp

我已尝试手动运行该命令,收到以下消息:

ubuntu@mysql-cluster-1:~/MySQL_Cluster/53$ !41

/usr/sbin/mysqld --defaults-file=/home/ubuntu/MySQL_Cluster/53/my.cnf

mysqld: [ERROR] Could not open required defaults file: /home/ubuntu/MySQL_Cluster/53/my.cnf

mysqld: [ERROR] Fatal error in defaults handling. Program aborted!

文件my.cnf包含以下配置:

#

# Configuration file for test1

# Generated by mcc

#

[mysqld]

log-error=mysqld.53.err

datadir="/home/ubuntu/MySQL_Cluster/53/data"

tmpdir="/home/ubuntu/MySQL_Cluster/53/tmp"

basedir="/usr/"

port=3306

ndbcluster=on

ndb-nodeid=53

ndb-connectstring=10.142.0.2:1186,

socket="/home/ubuntu/MySQL_Cluster/53/mysql.socket"

ndb-wait-setup=120

ndb-batch-size=32768

ndb-blob-read-batch-bytes=65536

ndb-blob-write-batch-bytes=65536

ndb-deferred-constraints=0

ndb-log-apply-status=0

ndb-log-empty-epochs=0

ndb-log-empty-update=0

ndb-log-exclusive-reads=0

编辑1:我使用的是安装了.deb文件的Ubuntu18.04.1和MySQLcluster7.6.7