Navicat – MySQL Overview

Navicat for MySQL is available for three platforms – Microsoft Windows, Mac OS X and Linux. It connects users to any local/remote MySQL Server, providing several database utilities such as Data Modeling Tool, Data/Structure Synchronization, Import/Export, Backup and Report, to facilitate the process of maintaining data.

via Navicat – MySQL Overview – The Most Popular SQL Server management,

This product competes with the free MySQL Workstation.

The MySQL Cluster API Developer Guide

This guide provides information for developers wishing to develop applications against MySQL Cluster. Application interfaces covered include the low-level C++-language NDB API for the MySQL NDBCLUSTER storage engine, the C-language MGM API for communicating with and controlling MySQL Cluster management servers, and the MySQL Cluster Connector for Java, which is a a collection of Java APIs introduced in MySQL Cluster NDB 7.1 for writing applications against MySQL Cluster, including JDBC, JPA, and ClusterJ.

via MySQL :: The MySQL Cluster API Developer Guide.

ERROR 1130 (HY000): Host ‘hostname’ is not allowed to connect to this MySQL server

After a bit of research, the fix in my case was to “GRANT” user root to connect to MySQL on any hosts. By default, user “root” was only allowed to connect to localhost and 127.0.0.1 hosts of MySQL.

#GRANT ALL PRIVILEGES ON *.* TO ‘root’@’%’ IDENTIFIED BY ‘<roots-password>’ WITH GRANT OPTION;

via ERROR 1130 (HY000): Host ‘hostname’ is not allowed to connect to this MySQL server – kuber’s posterous.

Adding MySQL Cluster Data Nodes Online

The redistribution for NDBCLUSTER tables already existing before the new data nodes were added is not automatic, but can be accomplished using simple SQL statements in mysql or another MySQL client application. However, all data and indexes added to tables created after a new node group has been added are distributed automatically among all cluster data nodes, including those added as part of the new node group.

via MySQL :: MySQL Cluster :: 5.12.1 Adding MySQL Cluster Data Nodes Online: General Issues.