LinuxϱàÒë°²×°mysql
£¨ºÇ£©½üÒ»¶Îʱ¼äÓÉÓÚ¹¤×÷ÐèÒª£¬ÖÕÓÚ¿ªÊ¼ÍæLinuxÁË£¬½ñÌì¸ãÁËÒ»ÌìµÄMySQL±àÒë°²×°£¬¼Ç¼ÏÂÀ´£¬±¸Íü°É£¡£¡
£¨¿¨£©°²×°»·¾³£ºVmWare5(ÇŽÓģʽ) + RedHat E AS 4 + ÒÑ°²×°ÁË¿ª·¢¹¤¾ßÒÔ¼°Ïà¹Ø¿ª·¢°ü(°²×°Linuxϵͳʱ×Ô¼ºÒª¶¨ÖƵÄ)£¬²¢²âÊԳɹ¦
£¨£¡£©Ïȸø³öMySQL For Linux Ô´ÂëÏÂÔصØÖ·£¬ÊÇxx.tar.zg¸ñʽµÄ
http://www.filewatcher.com/m/mysql-5.0.45.tar.gz.24433261.0.0.html
£¨1£©
-------------Ô¤±¸¹¤×÷----------
1£º¼ÙÈçÏÂÔصÄÎļþÃûΪ£ºmysql-5.0.45.tar.gz
2£º¼ÙÈçcopyµ½ /homeÏÂ
3£ºgroupadd mysql #Ìí¼Ómysql×é
4£ºuseradd -g mysql mysql #Ìí¼ÓÒ»¸ömysqlÓû§
5£ºcd /home #½øÈëµ½¸ÃĿ¼
-----------------------±àÒë¹ý³Ì-----------------------
6£ºtar zxvf mysql-5.0.45.tar.gz #½âѹºó£¬ÔÚ¸ÃĿ¼Ï»á³öÏÖÒ»¸öͬÃûµÄÎļþ¼Ð
7£ºcd /home/mysql-5.0.45
8£º./configure --prefix=/usr/local/mysql --with-charset=utf8 --with-collation=utf8_general_ci --with-extra-charsets=latin1 #²ÎÊýÉèÖ㬿ÉÒÔÏȲ»Ã÷°×£¬ÒÔºóÔÙÐÞ¸ÄÅäÖÃ
9£ºmake
10£ºmake install
11£ºcp support-files/my-medium.cnf /etc/my.cnf #Èç¹û/etc/my.cnfÒÑ´æÔÚ£¬ÔòÏȱ¸·Ý£¬ÔÙɾ³ý
12£ºvi /etc/my.cnf #½«log-bin=mysql-bin×¢Ê͵ô
----------------------------°²×°²¢³õ²½ÅäÖÃmysql--------------------------
13£ºcd /usr/local/mysql
14£ºbin/mysql_install_db --user=mysql #³õʼ»¯mysql
15£ºchown -R root . #¸Äµ±Ç°Ä¿Â¼µÄͱÓÐÕßΪroot¡£×¢Ò⣬×îºóÓиö . °¡£¬±íʾµ±Ç°Ä¿Â¼
16£ºchown -R mysql /usr/local/mysql/var #-R±íʾµÝ¹é֮ϵÄËùÓÐĿ¼
&
Ïà¹ØÎĵµ£º
Ò»¡¢×ܽáһϣº
1.linuxÏÂÆô¶¯mysqlµÄÃüÁ
mysqladmin start
/ect/init.d/mysql start (Ç°ÃæΪmysqlµÄ°²×°Â·¾¶)
2.linuxÏÂÖØÆômysqlµÄÃüÁ
mysqladmin restart
/ect/init.d/mysql restart (Ç°ÃæΪmysqlµÄ°²×°Â·¾¶)
3.linuxϹرÕmysqlµÄÃüÁ
mysqladmin shut ......
1. ÔÚLinuxϵͳÖУ¬ÒÔ Îļþ ·½Ê½·ÃÎÊÉ豸 ¡£
2. LinuxÄÚºËÒýµ¼Ê±£¬´ÓÎļþ /etc/fstab ÖжÁÈ¡Òª¼ÓÔصÄÎļþϵͳ¡£
3. LinuxÎļþϵͳÖÐÿ¸öÎļþÓà i½Úµã À´±êʶ¡£
4. È«²¿´ÅÅÌ¿éÓÉËĸö²¿·Ö×é³É£¬·Ö±ðΪÒýµ¼¿é ¡¢×¨ÓÃ¿é ¡¢ i½Úµã±í¿é º ......
Ëæ×ÅLinuxÓ¦ÓõÄÀ©Õ¹Ðí¶àÅóÓÑ¿ªÊ¼½Ó´¥Linux£¬¸ù¾ÝѧϰWindwosµÄ¾ÑéÍùÍùÓÐһЩãȻµÄ¸Ð¾õ£º²»Öª´ÓºÎ´¦¿ªÊ¼Ñ§Æð¡£ÕâÀï½éÉÜѧϰLinuxµÄһЩ½¨Òé¡£
Ò»¡¢´Ó»ù´¡¿ªÊ¼£º³£³£ÓÐЩÅóÓÑÔÚLinuxÂÛ̳ÎÊһЩÎÊÌ⣬²»¹ý£¬ÆäÖдó¶àÊýµÄÎÊÌⶼÊǺܻù´¡µÄ¡£ÀýÈ磺ΪʲôÎÒʹÓÃÒ»¸öÃüÁîµÄʱºò£¬ÏµÍ³¸æËßÎÒÕÒ²»µ½¸ÃĿ¼£¬ÎÒÒªÈçºÎÏÞÖÆ ......
¸ÅÊö
ÔÚÄ¿Ç°ÒÔIPv4Ϊ֧³ÅµÄÍøÂçÐÒéÉϴµÄÍøÂç»·¾³ÖУ¬SYN FloodÊÇÒ»Öַdz£Î£ÏÕ¶ø³£¼ûµÄDoS¹¥»÷·½Ê½¡£µ½Ä¿Ç°ÎªÖ¹£¬Äܹ»ÓÐЧ·À·¶SYN Flood¹¥»÷µÄÊֶβ¢²»¶à£¬¶øSYN Cookie¾ÍÊÇÆäÖÐ×îÖøÃûµÄÒ»ÖÖ¡£SYN CookieÔÀíÓÉD. J. BernstainºÍ Eric Schenk·¢Ã÷¡£Ôںܶà²Ù×÷ϵͳÉ϶¼Óи÷ÖÖ¸÷ÑùµÄʵÏÖ¡£ÆäÖаüÀ¨Linux¡£±¾Îľͷֱð½éÉÜÒ ......
1. ¹ØÓÚ±¾ÎÄ
±¾ÎĽ«ÒÔMySQL 5.0.51ΪÀý£¬ÒÔCentOS 5Ϊƽ̨£¬½²ÊöMySQLÊý¾Ý¿âµÄ°²×°ºÍÉèÖá£
2. ¹ØÓÚMySQL
MySQLÊÇ×îÁ÷ÐеĿªÔ´SQLÊý¾Ý¿â¹ÜÀíϵͳ£¬ËüÓÉMySQL AB¿ª·¢¡¢·¢²¼ºÍÖ§³Ö¡£MySQL ABÊÇÒ»¼ÒÓÉMySQL¿ª·¢ÈËÔ±´´½¨µÄÉÌÒµ¹«Ë¾£¬ËüÊÇÒ»¼ÒʹÓÃÁËÒ»Öֳɹ¦µÄÉÌҵģʽÀ´½áºÏ¿ªÔ´¼ÛÖµºÍ·½·¨Â۵ĵڶþ´ú¿ªÔ´¹«Ë¾¡£MySQLÊÇMySQL ......