Linux Enterprise5 ÏÂ×Ô¶¯Æô¶¯ Mysql ºÍApacheµÄÅäÖÃ
1. Mysql ×Ô¶¯Æô¶¯µÄÅäÖÃ
ÔÚMySQL°²×°³ÌÐòµÄ½âѹ°ü
/usr/local/mysql/support-files
myslq.serverµÄÆô¶¯½Å±¾³ÌÐò=¡· ¸´ÖÆ/etc/rc.d/init.dĿ¼
[root@localhost ~]# cd /etc/rc.d/init.d
¸´ÖƲ¢ÖØÃüÃûΪmysql
[root@localhost init.d]# cp /usr/local/mysql/support-files/mysql.server mysql
¸ü¸ÄÊôÐÔ¸ÄΪ“x”£¨executable£¬¿ÉÖ´ÐУ©
[root@localhost init.d]# chmod +x mysql
Ìí¼Óµ½ÏµÍ³µÄÆô¶¯·þÎñ×éÖÐ
chkconfig --add mysql
Æô¶¯·þÎñ
service mysql start
Áí£ºÈ·ÈÏ
chkconfig --list [name] ÓÃÀ´Áбí·þÎñ À´È·ÈÏ
chkconfig --list [mysql] »ò chkconfig --list
chkconfig --add name Ìí¼Ó·þÎñ
chkconfig --del name ɾ³ý·þÎñ
2. Apache ×Ô¶¯Æô¶¯µÄÅäÖÃ
·½·¨Ò»£º
apachectlÃüÁ±´ÖÁ/etc/rc.d/init.dĿ¼Ï£¬¸ÄÃûΪhttpd
ʹÓÃ±à¼Æ÷´ò¿ªhttpdÎļþ£¬²¢ÔÚµÚÒ»ÐÐ#!/bin/shÏÂÔö¼ÓÁ½ÐÐÎÄ×ÖÈçÏÂ
# chkconfig: 35 70 30
# description: Apache
½Ó×Å×¢²á¸Ã·þÎñ
chkconfig --add httpd
service httpd start
ÆäÖÐËùÔö¼ÓµÄµÚ¶þÐÐÖÐÈý¸öÊý×ÖµÚÒ»¸ö±íʾÔÚÔËÐм¶±ð3ºÍ5ÏÂÆô¶¯apache£¬
µÚ¶þ¡¢ÈýÊǹØÓÚÆô¶¯ºÍÍ£Ö¹µÄÓÅÏȼ¶ÅäÖã¬Î޹ؽôÒª
·½·¨¶þ£º ÔÚ/etc/rc.d/rc.localÖÐÔö¼ÓÆô¶¯apacheµÄÃüÁÀýÈ磺/usr/local/httpd/bin/apachectl start
Æô¶¯·þÎñ
Ïà¹ØÎĵµ£º
£¨L2CAPÐÒé¼ò½é£¬L2CAPÔÚBlueZÖеÄʵÏÖÒÔ¼°L2CAP±à³Ì½Ó¿Ú£©
Ò»£ºL2CAPÐÒé¼ò½é£º
Logical Link Control and Adaptation Protocol(L2CAP)
Âß¼Á¬½Ó¿ØÖƺÍÊÊÅäÐÒé (L2CAP) ΪÉϲãÐÒéÌá¹©ÃæÏòÁ¬½ÓºÍÎÞÁ¬½ÓµÄÊý¾Ý·þÎñ£¬²¢Ìṩ¶àÐÒ鹦ÄܺͷָîÖØ×é²Ù×÷¡£L2CAP ³äÐíÉϲãÐÒéºÍÓ¦ÓÃÈí¼þ´«ÊäºÍ½ÓÊÕ×î´ó³¤¶ÈΪ 64K µÄ L2CAP Ê ......
Service Discovery Protocol(SDP)ÌṩһÖÖÄÜÁ¦£¬ÈÃÓ¦ÓóÌÐòÓз½·¨·¢ÏÖÄÄÖÖ·þÎñ¿ÉÓÃÒÔ¼°ÕâÖÖ·þÎñµÄÌØÐÔ¡£
·þÎñ·¢ÏÖÐÒé(SDP»òBluetooth SDP)ÔÚÀ¶ÑÀÐÒéÕ»ÖжÔÀ¶ÑÀ»·¾³ÖеÄÓ¦ÓóÌÐòÓÐÌØÊâµÄº¬Ò⣬·¢ÏÖÄĸö·þÎñÊÇ¿ÉÓõĺÍÈ·¶¨ÕâЩ¿ÉÓ÷þÎñµÄÌØÕ÷¡£SDP¶¨ÒåÁËbluetooth client·¢ÏÖ¿ÉÓÃbluetooth server·þÎñºÍËüÃǵÄÌØÕ÷µÄ·½·¨¡£ ......
InnoDBÒ²Ö§³ÖÍâ¼üÔ¼Êø¡£InnoDBÖжÔÍâ¼üÔ¼Êø¶¨ÒåµÄÓï·¨¿´ÆðÀ´ÈçÏ£º
[CONSTRAINT symbol] FOREIGN KEY [id] (index_col_name, ...)
REFERENCES tbl_name (index_col_name, ...)
[ON DELETE {RESTRICT | CASCADE | SET NULL | NO ACTION}]
[ON UPDATE ......
LinuxϵݲװÓëÅäÖÃ
Èç¹ûËù°²×°µÄLinuxϵͳûÓÐÄÚÖõÄMySQL£¬±ÊÕß½¨ÒéÔÚLinuxÖÐʹÓÃRPM°üÀ´°²×°MySQL£¬Í¬ÑùÕâÒ²ÊÇMySQL¹Ù·½ÌṩµÄ½¨Òé¡£±ÊÕß½Ó´¥×î¶àµÄLinuxϵͳÊÇRadhatµÄ“½üÇ×”£ºCentOS£¬ÓÉÓÚCentOS½Ïеİ汾¶¼ÄÚÖÃÁËMySQL£¬Òò´ËÔÚ°²×°ÏµÍ³Ê±¾Í½«MySQL°²×°²¢×¢²áΪϵͳ·þÎñ£¬Ê¡È¥Á˲»ÉÙ¹¤×÷Á¿£¬´Ë´¦Ò²¾Í²» ......
±à¼/etc/mysql/my.cnfÎļþ£¬Ï൱ÓÚwindowsÖеÄmy.ini£º
ÕÒµ½[client]
Ìí¼Ó£º
default-character-set = utf8 // ĬÈÏ×Ö·û¼¯Îªutf8
ÕÒµ½[mysqld]
Ìí¼Ó:
default-character-set = utf8 //ĬÈÏ×Ö·û¼¯Îªutf8
init_connect = 'SET NAMES utf8' //É趨Á¬½ÓmysqlÊý¾Ý¿âʱʹÓÃutf8±àÂ룬ÒÔÈÃmysqlÊý¾Ý¿âΪutf8ÔËÐÐ
Ð޸ĺú ......