Re: SQL node not starting

[Shaun van Wyngaard]

Thank you for your response.

I edited my sql node's my.ini file and added the basedir & datadir options, it now looks like the following...

[mysqld]
# Options for mysqld process:
ndbcluster #run NDB storage engine
basedir=C:/MySQL/
datadir=C:/MySQL/Data

[mysql_cluster]
# Options for NDB Cluster processes:
ndb-connectstring=192.168.7.112 #location of management server 1


Again, it starts up and then seems to stop, i.e. giving me the normal command prompt again.

This is the contents of my error file:

2017-11-28T13:39:46.038508Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2017-11-28T13:39:46.397864Z 0 [Warning] InnoDB: New log files created, LSN=45790
2017-11-28T13:39:46.491616Z 0 [Warning] InnoDB: Creating foreign key constraint system tables.
2017-11-28T13:39:46.585399Z 0 [Warning] No existing UUID has been found, so we assume that this is the first time that this server has been started. Generating a new UUID: 992aac5f-d441-11e7-98c6-000c29a6c4de.
2017-11-28T13:39:46.600992Z 0 [Warning] Gtid table is not ready to be used. Table 'mysql.gtid_executed' cannot be opened.
2017-11-28T13:39:46.600992Z 1 [Note] A temporary password is generated for root@localhost: m/tcel2e=y*J

This is what it looks like in the command prompt:
C:\mysql\bin>mysqld --initialize --user=mysql

C:\mysql\bin>



Edited 1 time(s). Last edit at 11/28/2017 07:41AM by Shaun van Wyngaard.