UbuntuÏÂÅäÖÃÍøÂ磬°²×°mysql£¬jdk
sudo apt-get install mysql-server mysql-client
sudo apt-get install sun-java6-jdk(°²×°³öÒâÍ⣬sudo dpkg -P sun-java6-bin£¬È»ºóÖØÐ°²×°)
sudo vi /etc/network/interfaces ÅäÖÃÍøÂç
auto eth0
iface eth0 inet dhcp(static)
address 192.168.8.108
netmask 255.255.255.0
gateway 192.168.8.1
£ºx±£´æ
sudo ifconfig eth0 down (up)¹Ø±ÕºÍÆô¶¯
sudo /etc/init.d/networking restart
-----------------------------------
Ô¶³ÌÊÚȨ·ÃÎÊmsyql
GRANT ALL PRIVILEGES ON *.* TO 'root'@'192.168.8.108' IDENTIFIED BY '' WITH GRANT OPTION ;
etc/mysql/my.cnf×¢Ê͵ô bind 127.0.0.1
ÖØÐÂÆô¶¯mysql :sudo /etc/init.d/mysql restart
---------------------------------------------
Ïà¹ØÎĵµ£º
1.ÅäÖÃÃû×ÖΪmyodbcµÄÊý¾ÝÔ´
2.ÔÚstdafx.hÖмÓÉÏ
#import "c:\program files\common files\system\ado\msado15.dll" no_namespace rename ("EOF", "adoEOF")
3.ÔÚ³ÌÐò³õʼ»¯µÄ·½·¨ÖмÓÉÏ
AfxEnableControlContainer();
// ³õʼ»¯COM,´´½¨ADOÁ¬½ÓµÈ²Ù×÷
AfxOleInit();
4.ÔÚºÏÊʵĵط½¼ÓÉÏ
public:_ConnectionPt ......
ÒÔÏÂת×Ô Osss.cn Óʼþ£¬ÇëʹÓùý¡¢ÕýÔÚʹÓûòÕßÖ§³Ö¿ªÔ´µÄÅóÓÑÖ§³ÖÒ»ÏÂMySql£¬Ð»Ð»¡£
ҲϣÍû½ÌÓý²¿¡¢¿Æ¼¼²¿¸øÓèÖ±½ÓÖ§³Ö£¡
´ó¼ÒºÃ£º½ñÌì¿´µ½ÕâÔòÐÂÎÅ£¬Óë´ó¼Ò¹²Ïíһϣ¬MySQL´´Ê¼ÈËÏ£ÍûÖйúÉÌÎñ²¿ÄܽéÈëOracle&SunÊÕ¹º°¸£¬ºÃÏñ²¢Ã»ÓÐʵÖʽøÕ¹¡£¶ø¶íÂÞ˹Áª°î·´Â¢¶Ï»ú¹¹ÔÚÉÏÖÜÕ¹¿ªµ÷²é¡£Èç¹ûÐèÒªÉÌÎñ² ......
If you set it in the cnf(it may be my.ini file) you will likely need to restart the server. Optionally, that is a dynamic variable and can be SET GLOBAL or SET SESSION from the command line as well.So just do as follows.
mysql>show variables like’max_allowed_packet’;
......
http://www.cnblogs.com/neonlight/archive/2008/08/25/1276178.html
½üÒ»¶Îʱ¼ä£¬ºÜ¶à²¿ÃÅͬÊ·´Ó³ÔÚʹÓÃmysqlµÄ¹ý³Ì³öÏÖÊý¾Ý¿âÁ¬½Ó×Ô¶¯¶Ï¿ªµÄÎÊÌ⣬ÎÒ¶Ô¸ÃÎÊÌâ×öÁËһЩʵÑé¡£
¹ØÓÚmysql×Ô¶¯¶Ï¿ªµÄÎÊÌâÑо¿½á¹ûÈçÏ£¬ÔÚmysqlÖÐÓÐÏà¹Ø²ÎÊýÉ趨£¬µ±Êý¾Ý¿âÁ¬½Ó¿ÕÏÐÒ»¶¨Ê±¼äºó£¬·þÎñÆ÷¾Í
»á¶Ï¿ªµÈ´ý³¬Ê±µÄÁ¬½Ó£º
1¡¢Ïà¹Ø²Î ......
MySQL Cluster
is a technology that enables
clustering of in-memory databases in a shared-nothing system. The
shared-nothing architecture allows the system to work with very
inexpensive hardware, and with a minimum of specific requirements
for hardware or software.
......