Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

linux °²×° mysql rpm

ÔÚlinuxÏÂÃæ°²×°mysql£¬Ê×ÏàÒª¸ù¾Ý²Ù×÷ϵͳµÄ°æ±¾£¬Ñ¡Ôñ¶ÔÓ¦µÄmysqlµÄ°æ±¾£¬¹Ù·½ÍøÕ¾ÉÏÓзdz£Ã÷È·µÄ·ÖÀà
http://dev.mysql.com/downloads/
ÔÚÕâÀïÎÒʵÑéµÄ²Ù×÷ϵͳÊÇredhat linux
mysql ÓÃÁËÁ½¸ö°²×°°ü£¬Ò»¸öÊÇserver¶Ë£¬Ò»¸öÊÇclient,ÎÒÓõÄÊÇrpm°ü£¬°²×°µÄÖ¸Áî±È½Ï¼òµ¥¡£
MySQL-server-community-5.1.42-0.rhel4.i386
MySQL-client-community-5.1.42-0.rhel4.i386
ÍÆ¼ö²ÉÓõÄĬÈϵݲװ·¾¶£¬È»ºóÔËÐÐÁ½Ìõ¼òµ¥µÄÖ¸Áî¾Í°²×°Íê³ÉÁË¡£
rpm -Uhv MySQLMySQL-server-community-5.1.42-0.rhel4.i386
rpm  -Uhv MySQL-client-community-5.1.42-0.rhel4.i386
mysql°²×°µÄ¼¸¸öĬÈÏ·¾¶.
1,Êý¾ÝĿ¼£¬  /var/lib/mysql
2,ÅäÖÃÎļþ£¬ /usr/share/mysql
3,Ïà¹ØµÄÃüÁî /usr/bin
4,Æô¶¯½Å±¾ /etc/rc.d/init.d
°²×°Íê³É¹ýºóÈç¹û²»ÄÜÆô¶¯·þÎñ£¬
the server quit without updating PID file
Õâ¸ö´íÎóºÜ´ó²¿·ÖÊÇÓÉÅäÖÃÎļþÒýÆðµÄ£¬ÄãÖ»ÐèÒª¸ù¾ÝÄãϵͳµÄÅäÖðÑ/usr/share/mysqlÏÂÃæ¶ÔÓ¦µÄÅäÖÃÎļþcopyµ½/etc
²¢ÖØÃüÃûΪmy.cnf.Ñ¡ÔñºÏÊʵÄÅäÖÃÎļþ²Î¿¼http://www.kuqin.com/database/20090725/64156.html
ÅäÖÃÎļþ¸ã¶¨ºó£¬¾ÍÆô¶¯mysqlµÄ·þÎñ£¬
service mysql start  »òÕß/etc/rc.d/init.d/mysqld start Æô¶¯mysqlµÄ·þÎñ
È»ºó
shell> mysql 
¾ÍÄܽøÈëmysqlµÄ¿Í»§¶ËµÄ¹ÜÀí½çÃæÁË£¬Ëæ±ãÔËÐм¸ÌõmysqlµÄsqlÃüÁî¿´ÄãÊÇ·ñ³É¹¦¡£¡£


Ïà¹ØÎĵµ£º

ʵսLinux Bluetooth±à³Ì(Áù) L2CAP±à³ÌʵÀý

ÀýÒ»£º·¢ËÍSignaling Packet£º
Signaling CommandÊÇ2¸öBluetoothʵÌåÖ®¼äµÄL2CAP²ãÃüÁî´«Êä¡£ËùÒÔµÃSignaling CommandʹÓÃCID 0x0001.
¶à¸öCommand¿ÉÒÔÔÚÒ»¸öC-frame£¨control frame£©Öз¢ËÍ¡£
 Èç¹ûÒªÖ±½Ó·¢ËÍSignaling Command.ÐèÒª½¨Á¢SOCK_RAWÀàÐ͵ÄL2CAPÁ¬½ÓSocket¡£ÕâÑù²ÅÓлú»á×Ô¼ºÌî³äCommand Code£¬Identi ......

Linux²Ù×÷ϵͳÏÂsudoÃüÁîµÄʹÓ÷½·¨ËµÃ÷

Ô­ÎĵØÖ·£ºhttp://www.gz-benet.com.cn/bbs/Show.Asp?ID=4268
“Sudo”
ÊÇUnix/Linuxƽ̨ÉϵÄÒ»¸ö·Ç³£ÓÐÓõŤ¾ß£¬ËüÔÊÐíϵͳ¹ÜÀíÔ±·ÖÅ䏸ÆÕͨÓû§Ò»Ð©ºÏÀíµÄ“ȨÀû”£¬ÈÃËûÃÇÖ´ÐÐһЩֻÓг¬¼¶Óû§»òÆäËûÌØÐíÓû§²ÅÄÜ
Íê³ÉµÄÈÎÎñ£¬±ÈÈ磺ÔËÐÐһЩÏñmount£¬halt£¬suÖ®ÀàµÄÃüÁ»òÕ߱༭һЩϵͳÅäÖà ......

mysql 5.1 configure ±àÒë²ÎÊýÏê½â

-static  13%
   --with-client-ldflags=-all-static
  
--with-mysqld-ldflags=-all-static
¾²Ì¬Á´½ÓÌá¸ß13%ÐÔÄÜ
Unix Socket  7.5%
--with-unix-socket path=/usr/local/mysql/tmp/mysql.sock
ʹÓÃunixÌ×½Ó×ÖÁ´½ÓÌá¸ß7.5%ÐÔÄÜ£¬ËùÒÔÔÚwindowsÏÂmysqlÐÔÄܿ϶¨²»ÈçunixÏÂÃæ
--enab ......

How to change max_allowed_packet value in mysql?

 
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’; ......

mysql¾ÖÓòÍø·ÃÎÊ

1,ÔÚwindow×Ô´øµÄ·À»ðǽÀïµÄÀýÍâÌí¼Ó3306¶Ë¿Ú£¬ÎªTCP
2£¬½ñÌìÔÚÓÃÔ¶³ÌÁ¬½ÓMysql·þÎñÆ÷µÄÊý¾Ý¿â£¬²»¹ÜÔõôŪ¶¼ÊÇÁ¬½Ó²»µ½£¬´íÎó´úÂëÊÇ1130£¬ERROR 1130: Host 192.168.2.159 is not allowed to connect to this MySQL server
²ÂÏëÊÇÎÞ·¨¸øÔ¶³ÌÁ¬½ÓµÄÓû§È¨ÏÞÎÊÌâ¡£½á¹ûÕâÑù×Ó²Ù×÷mysql¿â£¬¼´¿É½â¾ö¡£ÔÚ±¾»úµÇÈëmysqlºó£¬¸ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ