Unable to see the mysql database after Initialization
Posted by: giriprasad kandregula
Date: December 05, 2017 11:26PM

Below are the steps i did to create SQL Node in a NDB cluster. Unable to see mysql and ndbinfo databases. Please let me know how to debug this issue.

$sudo /opt/mysql/server-5.7/bin/mysqld --initialize --user=mysql --datadir=/data/mysql
$ sudo systemctl start mysqld
$ mysql -u root
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
$ sudo /opt/mysql/server-5.7/bin/mysqld_safe --skip-grant-tables &
$ mysql -u root
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 6
Server version: 5.7.17-ndb-7.5.5-cluster-gpl MySQL Cluster Community Server (GPL)

mysql> show databases;
| Database |
| information_schema |
1 row in set (0.01 sec)

Options: ReplyQuote

Written By
Unable to see the mysql database after Initialization
December 05, 2017 11:26PM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.