MYSQLͬ²½ÎÊÌ⣬¿¨ËÀÔÚÕâÀïÁË[93È«·ÖËͳö]
ÎÒµÄÄ¿±êÊÇʵÏÖÁ½Ì¨»òÕß¶ą̀MYSQLÏ໥ͬ²½£¬ÏÖÔÚÓÃÁ½¸öµçÄÔ×ö²âÊÔ£¬Áíһ̨ÊÇÐÂ×°µÄPC£¨windows server 2003£¬³ÉΪAÖ÷»ú£¬IP=192.168.1.150£©£¬Ò»Ì¨ÊDZʼDZ¾£¨XPϵͳ£¬³ÆÎªBÖ÷»ú£¬IP=192.168.1.10£©£¬¾¹ýÒ»ÌìµÄÕÛÌÚ£¬ÏÖÔÚµÄÇé¿öÓ¦¸ÃºÍËùÓÐ×ÊÁÏÉÏÌṩµÄ×îÖճɹ¦×´Ì¬ÊDz鲻¶¼ÁË£¬µ«ÊÇ£¬»¹ÊDz»Äܳɹ¦Í¬²½£¬ÇëÀÏÊÖÖ¸µãһϣ»
ÏÈ˵ÅäÖãº
AÖ÷»úµÄMy.iniÎļþ×îºóµÄÄÚÈÝ£º
#ͬ²½²ÎÊýÉèÖÃ
server-id=1
log-bin=C:hobcmsdatamysqllog
binlog-do-db=MY_DATA1
log-slave-updates
master-host=192.168.1.10
master-user=root
master-password=26202122
replicate-do-db=MY_DATA1
master-connect-retry=20
slave-skip-errors=all
BÖ÷»úµÄMy.iniÎļþ×îºóµÄÄÚÈÝ£º
#ͬ²½²ÎÊýÉèÖÃ
server-id=2
log-bin=C:hobcmsdatamysqllog
binlog-do-db=MY_DATA1
log-slave-updates
master-host=192.168.1.150
master-user=root
master-password=26202122
replicate-do-db=MY_DATA1
master-connect-retry=20
slave-skip-errors=all
A»ú²éѯµÄ״̬£º
mysql> show master status;
mysql> show slave status;
B»ú²éѯµÄ״̬£º
mysql> show master status;
mysql> show slave status;
´ÓÉϵÄÐÅÏ¢À´¿´£¬»ù±¾Ö»ÓÐÒ»µãµãµØ²îÒ죬²»ÖªµÀÕâÊÇ·ñΪÎÊÌâÔÒòÖ®ËùÔÚ¡£
ÆäËûÐÅÏ¢£º
Á½Ì¨Ö÷»úµÄ·À»ðǽȫ²¿¹Ø±Õ£¬ÓÃtelnet 192.168.1.150 3306,telnet 192.168.1.150
Ïà¹ØÎÊ´ð£º
ÎÒÊÇÓÃmysql×Ô´øµÄC API
if(mysql_real_connect(&mysql,"125.0.0.108","root","root","home",3306,NULL,0))
{
AfxMessageBox("Êý¾Ý¿âÁ¬½Óʧ°Ü") ......
Winform+MySQL×öÏîÄ¿£¬ÔÚ×¢ÖØÐÔÄܵÄÇé¿öÏ£¬ÎÒ¸ÃÈçºÎÈ¥Íê³ÉÕâÀàÐ͵ÄÏîÄ¿ÄØ£¡
Çë¸÷λ¸øÒÔÌáʾ¡£
ÄãÕâ¸ö·¶Î§Ì«¹ãÁË£¬ÎÒ˵2µãÖØÒªµÄ°É
1.WINFORM³ÌÐòÊǵ¥¶ÀÔËÐеÄCS³ÌÐò£¬ºÍBS²»Í¬£¬BSµÄѹÁ¦Ê¼ÖÕ¶¼ÔÚSERVERÉϵ쬶ÔC ......
²»ÖªµÀÊDz»ÊÇÎÒµÄxamppÓÐÎÊÌ⣬mysqlÊÇͼÐλ¯µÄ£¡
Ò»¸öID×éÔÚÎÒµÄmysqlµÄ±íÀïÃæ 2£¬5£¬8£¬7
µãÁËÅÅÐò£¬È»ºóÓÃPHPÎļþÁ¬½ÓÕâ¸ö±íÏÔʾ±íµÄÐÅϢʱ£¬IDµÄ˳Ðò»¹ÊDz»±ä£¡Ó¦¸ÃÊÇ2£¬5£¬7£¬8µÄ°ÉÉýÐòÅÅÐòºó£¡
ÔÚPHPÎļþÀï ......
ÎÒµÄmysqlÔõôûÓа취дÈëÖÐÎÄÊý¾Ý£¿Ö»ÒªÊÇÊý¾ÝдÈëÊý¾Ý¿âʱ ¾Í»á±ä³ÉÈý¸öÎʺŠ£¿Çë½Ì¸ßÈË£¡£¡
linux? ÔõôдÈëµÄ
ÔÚmysqlÖÐÖ´ÐÐ show variables like 'character%'Ìù½á¹û³öÀ´¡£
ÔÚ°²×°MYSLQʱ½«Êý¾Ý¿âµÄ×Ö· ......