ÒÔÏÂÊǹÜÀí½ÚµãµÄÅäÖÃ
[NDBD DEFAULT]
NoOfReplicas=2
[MYSQLD DEFAULT]
[NDB_MGMD DEFAULT]
[TCP DEFAULT]
[NDB_MGMD] # ¹ÜÀí½Úµã
HostName=192.168.1.10
[NDBD] # ´æ´¢½Úµã 1
# ±¾»ú£¨¹ÜÀí½Úµã£©µÄ IP µØÖ·
HostName=19 ......
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
Ò»ÖÖÇé¿ö£¬ÄãûÓÐmysql.sockÕâ¸öÎļþ£¬Èç¹ûÊÇÊÖ¶¯°²×°µÄ»°£¬ÓпÉÄܷŵ½ÆäËüµÄµØ·½ÁË£¬µ«ÊÇĬÈÏÊÇÕÒ/TMP·¾¶ÏµÄÕâ¸öÎļþµÄ£¬»¹ÓÐÒ»ÖÖ¿ÉÄÜ£¬MYSQLÓû§Ã»ÓÐȨÏÞ¡£¡£Õâʱ¾ÍÓÃROOTÓû§¸øMYSQLÓû§Ìí¼ÓȨÏÞ¡£
......
mysql ÖÐÓÐ ttt ±í½á¹¹ºÍÊý¾ÝÈçÏÂ
CREATE TABLE `ttt` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`num` double(15,3) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;
INSERT INTO `ttt` (`id`, `num`) VALUES
(1, ......
ÏÖÔÚÔÚLinuxÏÂ×öÒ»¸öÏîÄ¿£¬ÎÒ¸ºÔðC++·ÃÎÊmysqlµÄÊý¾Ý²ã·â×°£¬¸Ðµ½ÎÞ´ÓÏÂÊÖ¡£
ÎÊÌ⣺
1.ÈçºÎ²ÅÄÜÀ©Õ¹ÐÔºÃЩ£¨Èç¹ûÎҸ͝²»´óµÄÇé¿öϸÄÓÃÆäËüÊý¾Ý¿â£©
2.½Ó¿ÚÒ×ά»¤ÐÔ£¨¾¡Á¿Ê¹Ó¦Óõ÷ÓÃÍÑÀëÊý¾Ý¿â£¬Ö»Êǵ÷ÓÃÎҵĽӿھÍOKÁË£©
ÓиßÊÖ×ö¹ýµÄÇëÖ¸µ¼Ï£¬Ë¼Â·¾Í¿ÉÒÔ£¨ÓдúÂëÄǾ͸üºÃÁË£©
ÔÚÏߵȣ¬¶¥ÉÏÈ¥
Ê ......
ÕâÊÇSQL SERVERÖеÄÒ»ÌõÓï¾ä(×¢Òâ±íÃûºÍÁÐÃû¶¼ÊÇÓ÷ûºÅ¿ªÊ¼µÄ)£¬Èç¹û¸ÄÓÃMYSQL£¬Ó¦¸ÃÈçºÎд£º
SELECT [_±íA].[_µÚÒ»ÁÐ], [_±íA].[_µÚ¶þÁÐ], [_±íB].[_µÚÈýÁÐ] from [_±íA] INNER JOIN [_±íB] ON [_±íA].[_µÚÒ»ÁÐ] = [_±íB].[_µÚÒ»ÁÐ]
ÎÒÖ÷ÒªÊÇÏëÖªµÀ£¬ÔÚMySQLµÄSelectÓï¾äÖУ¬ÊÇÈçºÎ´¦ÀíÕâÖÖÌØÊâµÄ±íÃû ......
mysql 1067´íÎó½ø³ÌÒâÍâÖÕÖ¹
¼ì²éÄãµÄ´íÎóÈÕÖ¾ÓÐЩʲôÌáʾ¡£
ÓдíÎóÈÕ־ûÓУ¿
ÊÔÊÔɾ³ýϵͳĿ¼ÏµÄmy.iniÎļþ£¬È»ºóÖØÐ´´½¨
windows주
½â¾ö°ì·¨£º
1.¼ì²éÄãµÄMysqlĿ¼ÓÐûÓиøÏµÍ³µÄSystemÓû§È¨ÏÞ¡£
2.ɾ³ýµôÄãµÄ %WINDOWS%/my.ini Îļþ¡£
3.¼ì²éÄãµÄ c:/my.cnf ÎļþÅäÖÃÊÇ·ñÕýÈ·¡£
......