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