Can't open priveledges table?
Take out the ndb configuration for your MySQL APIs and run the API
without clustering. It should startup and run, accept your connections,
run SQL, etc...
If that works, then shut down the API, add in your configuration to the
my.cnf for the ndb cluster connection...
ndb-connectstring = "host=mgm-node1.domain.com:2200"
...then start the API up again.
You should not get a "Can't open privilege tables: Table 'mysql.host'"
just because you have the mysqld setup to act as an API to the MySQL
Cluster (which is only two additional lines).
If you are getting this error, it is not any cluster configuration, it
is you API configuration. You must set the API to run like any other
MySQL daemon server process you would set up. - the only different
between a normal mysqld server and a mysqld server as an NDB API is the
two lines in the my.cnf configuration file I indicated above.
Lewis Bergman wrote:
>First off, this is my first try at the mysql cluster. I have used mysql
>for about 5 years, both rpms and compiled from source. I have read the
>manual several times over a week and I believe I followed it step by step.
>Having said all of that I cam having no luck and suspect that I have left
>something out of my config options or overlooked something.
>ndb_mgm show reports both ndbd and ndb_mgmd are running. Netstat -l
>reports ports 2200, 2202, and 2203 are open and listening. But, when I run
>the mysqld command per the manual I get the subject error. The server
>starts, sees the innodb needs creating, then bails on the permissions
>tasble. I have a my.cnf with the [mysqld]ndbcluster option set.
>This is off the 4.1.7 tarball yesterday.
>I have been banging at this for about 20 hours and am evidently to thick
>headed to see the problem. I would really appreciate some help, even
>referencing the manual as I have searched it a dozen different ways