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 Ê ......
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°²×°²¢×¢²áΪϵͳ·þÎñ£¬Ê¡È¥Á˲»ÉÙ¹¤×÷Á¿£¬´Ë´¦Ò²¾Í²» ......
MySQLË÷Òý¼ò½é... 1
Ò»¡¢Ë÷Òý·Öµ¥ÁÐË÷ÒýºÍ×éºÏË÷Òý…………………………………………………………………………………&hel ......
ÔÚѧϰ£¼Linux³ÌÐòÉè¼Æ£¾µÚ8ÕÂMySQLÊý¾Ý¿â8.3½Ú£º
ʹÓÃCÓïÑÔ·ÃÎÊMySQL·ÃÎÊÊý¾Ý¿âʱ³¢ÊÔ°ÑSQLÊý¾Ý»»³ÉÁËÖÐÎÄ£¬µ«ÊÇÔÚÔËÐÐʾÀý³ÌÐòʱÖÕ¶ËÊä³öÈ´ÂÒÂ룬MySQL C ÓïÑÔÁ¬½ÓĬÈÏ×Ö·û¼¯ÊÇlatin1
²éÁËÏÂAPIÕÒµ½ÈçϺ¯Êý¿É½â¾öÖÐÎÄÂÒÂëÎÊÌâ¡£
int
mysql_set_character_set(
MYSQL *
mysql,
char
*
csname)
ÃèÊö
¸Ãº¯ÊýÓ ......