Hi, I've tried mysql cluster recently and noticed strange thing, when I tried to put the contents of service 'mysql' database into NDB cluster.
Some tables could not be put into cluster without modification since BLOB is not yet handled, so I changed all blob and text to char(255) and put all tables in mysql database to cluster, using: 'alter table XXX type=NDB' On machine where second MySQL, connected to the cluster works, I deleted mysql.* tables MyISAM files from datadir (when server was stopped) and successfully started MySQL. I noticed the following: * some tables' files were created on the filesystem after mysqld start (note there is no correspondent .MYD, .MYI files): $ ls -1 columns_priv.frm db.frm func.frm help_category.frm help_keyword.frm help_relation.frm help_topic.frm host.frm tables_priv.frm user.frm * permissions/grants for user root were dropped, so that I can not access mysql database anymore: [EMAIL PROTECTED] /var/lib/mysqlcluster/mysqldata]$ mysql mysql ERROR 1044 (42000): Access denied for user: ''@'localhost' to database 'mysql' [EMAIL PROTECTED] /var/lib/mysqlcluster/mysqldata]$ mysql -u root mysql ERROR 1044 (42000): Access denied for user: ''@'localhost' to database 'mysql' [EMAIL PROTECTED] /var/lib/mysqlcluster/mysqldata]$ mysql Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 21 to server version: 4.1.2-alpha-debug Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql> show grants; +--------------------------------------+ | Grants for @localhost | +--------------------------------------+ | GRANT USAGE ON *.* TO ''@'localhost' | +--------------------------------------+ 1 row in set (0.00 sec) mysql> use test; ERROR 1044 (42000): Access denied for user: ''@'localhost' to database 'test' mysql> show databases; Empty set (0.00 sec) Actually I'm curious if you plan to support keeping mysql.* inside of NDB cluster, thus allowing to have the same auth info for each MySQL server you start on top of NDB cluster. I used 4.1 from bk, latest bk pull was performed May 21 -- Regards Alec -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
