mysql集群安装错误解决方案

《mysql集群安装错误解决方案》由会员上传分享，免费在线阅读，更多相关内容在行业资料-天天文库。

1、2、[root@localhostmysql]#scripts/mysql_install_db--user=mysqlInstallingMySQLsystemtables...OKFillinghelptables...OKTostartmysqldatboottimeyouhavetocopysupport-files/mysql.servertotherightplaceforyoursystemPLEASEREMEMBERTOSETAPASSWORDFORTHEMySQLrootUSER!Todoso,startthes

2、erver,thenissuethefollowingcommands:./bin/mysqladmin-urootpassword'new-password'./bin/mysqladmin-uroot-hlocalhost.localdomainpassword'new-password'Alternativelyyoucanrun:./bin/mysql_secure_installationwhichwillalsogiveyoutheoptionofremovingthetestdatabasesandanonymous

3、usercreatedbydefault.Thisisstronglyrecommendedforproductionservers.Seethemanualformoreinstructions.YoucanstarttheMySQLdaemonwith:cd.;./bin/mysqld_safe&YoucantesttheMySQLdaemonwithmysql-test-run.plcd./mysql-test;perlmysql-test-run.plPleasereportanyproblemswiththe./bin/

4、mysqlbugscript![root@localhostlocal]#tarzxvfmysql-cluster-gpl-6.3.51-linux-i686-glibc23.tar.gz/usr/local/bin'*/bin/ndb_mgm*'mysql-cluster-gpl-6.3.51-linux-i686-glibc23/bin/ndb_mgmmysql-cluster-gpl-6.3.51-linux-i686-glibc23/bin/ndb_mgmdtar:/usr/local/bin：归档中找不到tar:由于出现

5、以上问题，不用理，管理节点就只需要ndb_mgm,ndb_mgmd[root@localhostbin]#ndb_mgmd-f/var/lib/mysql-cluster/config.iniWarningline13:[TCP]portnumberisdepricated,usePortusedforthistransporterinstead出现这个提示，可以把配置文件中端口号屏蔽掉。[root@localhostmysql]#scripts/mysql_install_db--user=mysqlerror:Foundopt

6、ionwithoutprecedinggroupinconfigfile:/etc/my.cnfatline:1Fatalerrorindefaultshandling.ProgramabortedInstallingMySQLsystemtables...error:Foundoptionwithoutprecedinggroupinconfigfile:/etc/my.cnfatline:1提示withoutprecedinggroup，在配置文件my.cnf中，添加user=mysql即可例如：我的配置文件：#options

7、formysqldprocess:[MYSQLD]ndbcluster#runNDBenginendb-connectstring=192.168.1.13#locationofMGMnodeuser=mysql[root@localhostbin]#./ndbd--initialUnabletoconnectwithconnectstring:nodeid=0,192.168.1.13:1186Retryingevery5seconds.Attemptsleft:12^C[root@localhostbin]#catndb_pi

8、d2529_error.logCurrentbyte-offsetoffile-pointeris:568Time:Tuesday1April2014-13:31:23Status:Permanenterror,externalactionneed