ÔÚLinux»·¾³Ïµ¥»úÉÏʵÏÖMySQL5Ö÷´ÓÊý¾Ý¿âͬ²½¸´ÖÆ
1.°²×°MySQL£¨ÂÔ£©
2.Æô¶¯¶à¸öMySQL·þÎñÆ÷
ҪʵÏÖÔÚµ¥»úÉÏÆô¶¯¶à¸öMySQL·þÎñÆ÷£¬ÓÐÁ½ÖÖ·½·¨£¬Ò»ÖÖÊÇÖ±½ÓʹÓÃmysqld_safeÀ´ÔËÐжà¸ö·þÎñÆ÷
µ±È»ÕâÑù·Ö±ð±à¼ÅäÖÃÎļþ£¬¶øÇҹرշþÎñÆ÷µÄʱºòÒ²Òª¶ÁÈ¡ÅäÖÃÎļþ£¬ËùÒԱȽÏÂé·³£¬ÁíÒ»ÖÖ·½·¨ÊÇʹÓÃ
MySQLÌṩµ½¹¤¾ßmysqld_multi½Å±¾À´¹ÜÀí¶à¸ö·þÎñÆ÷£¬ÏÂÃæÊ¹Óõķ½·¨ÊÇmysqld_safeÀ´ÊµÏÖ¡£
3.ǰÖÃÌõ¼þ
¼ÙÉèMySQL°²×°µ½Ä¿Â¼Îª/usr/local/mysql/£¬ÉèΪMYSQL_DIRͨ³£ËüÊÇÒ»¸öÁ´½ÓÎļþ¡£
Êý¾ÝÎļþĿ¼Ϊ$MYSQL_DIR/data¡£
ÏÖÔÚÒªÌí¼ÓÁíÒ»¸ö·þÎñÆ÷µÄÊý¾ÝĿ¼£¬ÒòΪΪÁËÄ£Äâ·Ö²¼Ê½·þÎñÆ÷µ½Í¬²½£¬²»¿ÉÄÜÈöà¸ö·þÎñÆ÷¹²ÏíÒ»¸öÊý¾ÝĿ¼¡£
$cd $MYSQL_DIR
$sudo cp -r -p data var2
ÉÏÃæµÄÖ¸Ádata±£ÁôÔÀ´µ½È¨ÏÞ¸´ÖÆÒ»·Ýµ½var2£¬var2Ò²¾ÍÊÇÁíÒ»¸ö·þÎñÆ÷µÄÊý¾ÝĿ¼£¬ÕâÑù£¬ÔÚÔʼ
״̬Ï£¬Á½¸öÊý¾Ý¿â·þÎñÆ÷µÄÊý¾ÝÊÇÒ»Öµġ£
4.¼ÙÉèÓÐMySQLµÄºÏ·¨Óû§root:root¡£
5.Æô¶¯°²×°ºÃÒÔºóµÄÄǸö·þÎñÆ÷
$cd $MYSQL_DIR/bin
$sudo ./mysqld_safe --user=mysql --binlog-do-db=test &
ÉÏÃæµÄÃüÁî±íʾÆô¶¯·þÎñÆ÷²¢ÇÒʹÓöþ½øÖÆÈÕÖ¾¼Ç¼Êý¾Ý¿âtestµÄ¸üж¯×÷¡£
6.²âÊÔÊÇ·ñÆô¶¯³É¹¦
$mysql -u root -p -S/tmp/mysql.sock
ÊäÈëÃÜÂëºó£¬Èç¹ûÄܹ»³É¹¦µÇ¼µÄ»°±íʾ³É¹¦£¬ÕâÀï×îÈÝÒ׳öÏÖ2002´íÎ󣬱íʾsocketÎļþ´íÎó£¬Äã¿ÉÒÔ
ʹÓÃÃüÁî
$ps aux|grep mysql
À´²é¿´µ±Ç°·þÎñÆ÷ʹÓõÄsocketÎļþ£¬È»ºóÔڵǼµÄʱºòʹÓÃÏàÓ¦µÄsocketÎļþ¡£
7.±à¼ÅäÖÃÎļþ
$sudo vi /etc/my.cnf
×î³õµÄʱºò£¬Õâ¸öÅäÖÃÎļþÊÇÕë¶ÔÇ°ÃæÆô¶¯µÄ·þÎñÆ÷µÄ£¬ÏÖÔÚÎÒÃǰÑËüÐÞ¸Äһϣ¬È»ºó¾Í¿ÉÒÔÆô¶¯ÁíÒ»¸ö·þÎñÆ÷
ÕÒµ½[mysqld]¶ÎÂ䣬ȻºóÐÞ¸ÄÈçÏ£º
[mysqld]
server-id=2 #ÔÀ´ÊÇ1
socket=/tmp/mysql.sock2 #ÔÀ´ÊÇ/tmp/mysql.sock
port=3307 #ÔÀ´ÊÇ3306
#ÏÂÃæ3ÐÐÊÇÌí¼ÓµÄ
pid-file=$MYSQL_DIR/var2/localhost.pid2
datadir=$MYSQL_DIR/var2
log=$MYSQL_DIR/var2/db2.log
×¢ÒâʹÓÃ×îÇ°ÃæµÄMySQL°²×°Ä¿Â¼À´´úÌæÉÏÃæµÄ$MYSQL_DIR¡£
8.Æô¶¯µÚ¶þ¸ö·þÎñÆ÷
&n
Ïà¹ØÎĵµ£º
£¨L2CAPÐÒé¼ò½é£¬L2CAPÔÚBlueZÖеÄʵÏÖÒÔ¼°L2CAP±à³Ì½Ó¿Ú£©
Ò»£ºL2CAPÐÒé¼ò½é£º
Logical Link Control and Adaptation Protocol(L2CAP)
Âß¼Á¬½Ó¿ØÖƺÍÊÊÅäÐÒé (L2CAP) ΪÉϲãÐÒéÌá¹©ÃæÏòÁ¬½ÓºÍÎÞÁ¬½ÓµÄÊý¾Ý·þÎñ£¬²¢Ìṩ¶àÐÒ鹦ÄܺͷָîÖØ×é²Ù×÷¡£L2CAP ³äÐíÉϲãÐÒéºÍÓ¦ÓÃÈí¼þ´«ÊäºÍ½ÓÊÕ×î´ó³¤¶ÈΪ 64K µÄ L2CAP Ê ......
Ò»£ºÇ°ÑÔ
×î½üÔÚÑо¿androidµÄsensor driver£¬Ö÷ÒªÊÇE-compass£¬ÆäÖÐÓõ½ÁËLinux input×Óϵͳ.ÔÚÍøÉÏÒ²¿´Á˺ܶàÕâ·½ÃæµÄ×ÊÁÏ£¬¸Ð¾õ»¹ÊÇÕâÆª·ÖÎöµÄ±È½ÏϸÖÂ͸³¹£¬Òò´Ë×ªÔØÒ»ÏÂÒÔ±ã×Ô¼ºÑ§Ï°£¬Í¬Ê±ºÍ´ó¼Ò·ÖÏí£¡
£¨ÕâÆª²©¿ÍÖ÷ÒªÊÇÒÔ¼üÅÌÇý¶¯ÎªÀýµÄ£¬²»¹ý½²½âµÄÊÇLinux Input Subsystem£¬¿ÉÒÔ×ÐϸµÄÑо¿Ò»Ï£¡£©
¼üÅÌÇý¶¯½«¼ì ......
Á¬½ÓMySQLÊý¾Ý¿âʱ³£»á³öÏÖÈçϵĴíÎóÌáʾ£º
#1251 - Client does not support authentication protocol requested by server; consider upgrading MySQL client
³öÏÖÕâÖÖÎÊÌâÊÇÔÚMySQL4.1ÒÔÉϰ汾£¬ÔÒòMySQL·þÎñÆ÷°æ±¾Ê¹ÓÃÁËеÄÃÜÂëÑéÖ¤»úÖÆ£¬Æä½â¾ö·½·¨ÈçÏ£º
mysql>;set password for 'Óû§Ãû' @ 'Ö÷»úÃû' = old ......
×î½ü×öÁ˼¸ÖܵÄLoadRunner²âÊÔ£¬ÓÐһЩÐĵ㬼ǼÏÂÀ´£¬ÒÔ±ãÒÔºó²éÕÒ¡£
LoadRunner²âÊÔÊý¾Ý¿âÊÇÄ£Äâ¿Í»§¶ËÈ¥Á¬½ÓÊý¾Ý¿â·þÎñÆ÷£¬Òò´Ë£¬ÐèÒªÐÒ飨»òÕß˵Çý¶¯µÄÖ§³Ö£©¡£LoadRunner±¾ÉíÖ±½ÓÖ§³ÖOracle¡¢SqlServerÊý¾Ý¿â£¬ÕâÁ½¸öÊý¾Ý¿âÖ±½ÓÑ¡ÔñÏàÓ¦µÄÐÒé¾Í¿ÉÒÔÂ¼ÖÆ½Å±¾¡£¶øMySqlÊý¾Ý¿â ......