Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

ÔÚ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


Ïà¹ØÎĵµ£º

ʵսLinux Bluetooth±à³Ì£¨ËÄ£© L2CAP²ã±à³Ì

£¨L2CAPЭÒé¼ò½é£¬L2CAPÔÚBlueZÖеÄʵÏÖÒÔ¼°L2CAP±à³Ì½Ó¿Ú£©
Ò»£ºL2CAPЭÒé¼ò½é£º
Logical Link Control and Adaptation Protocol(L2CAP)
Âß¼­Á¬½Ó¿ØÖƺÍÊÊÅäЭÒé (L2CAP) ΪÉϲãЭÒéÌá¹©ÃæÏòÁ¬½ÓºÍÎÞÁ¬½ÓµÄÊý¾Ý·þÎñ£¬²¢Ìṩ¶àЭÒ鹦ÄܺͷָîÖØ×é²Ù×÷¡£L2CAP ³äÐíÉϲãЭÒéºÍÓ¦ÓÃÈí¼þ´«ÊäºÍ½ÓÊÕ×î´ó³¤¶ÈΪ 64K µÄ L2CAP Ê ......

LinuxÉ豸ģÐÍÖ®input×ÓϵͳÏê½â

Ò»£ºÇ°ÑÔ
×î½üÔÚÑо¿androidµÄsensor driver£¬Ö÷ÒªÊÇE-compass£¬ÆäÖÐÓõ½ÁËLinux input×Óϵͳ.ÔÚÍøÉÏÒ²¿´Á˺ܶàÕâ·½ÃæµÄ×ÊÁÏ£¬¸Ð¾õ»¹ÊÇÕâÆª·ÖÎöµÄ±È½ÏϸÖÂ͸³¹£¬Òò´Ë×ªÔØÒ»ÏÂÒÔ±ã×Ô¼ºÑ§Ï°£¬Í¬Ê±ºÍ´ó¼Ò·ÖÏí£¡
£¨ÕâÆª²©¿ÍÖ÷ÒªÊÇÒÔ¼üÅÌÇý¶¯ÎªÀýµÄ£¬²»¹ý½²½âµÄÊÇLinux Input Subsystem£¬¿ÉÒÔ×ÐϸµÄÑо¿Ò»Ï£¡£©
¼üÅÌÇý¶¯½«¼ì ......

Á¬½ÓMySQLÊý¾Ý¿âʱ³öÏÖ#1251´íÎóµÄ½â¾ö·½·¨

Á¬½ÓMySQLÊý¾Ý¿âʱ³£»á³öÏÖÈçϵĴíÎóÌáʾ£º
#1251 - Client does not support authentication protocol requested by server; consider upgrading MySQL client
³öÏÖÕâÖÖÎÊÌâÊÇÔÚMySQL4.1ÒÔÉϰ汾£¬Ô­ÒòMySQL·þÎñÆ÷°æ±¾Ê¹ÓÃÁËеÄÃÜÂëÑéÖ¤»úÖÆ£¬Æä½â¾ö·½·¨ÈçÏ£º
mysql>;set password for 'Óû§Ãû' @ 'Ö÷»úÃû' = old ......

LoadRunnerÀûÓÃODBC±àдMySql½Å±¾

    ×î½ü×öÁ˼¸ÖܵÄLoadRunner²âÊÔ£¬ÓÐһЩÐĵ㬼ǼÏÂÀ´£¬ÒÔ±ãÒÔºó²éÕÒ¡£
    LoadRunner²âÊÔÊý¾Ý¿âÊÇÄ£Äâ¿Í»§¶ËÈ¥Á¬½ÓÊý¾Ý¿â·þÎñÆ÷£¬Òò´Ë£¬ÐèҪЭÒ飨»òÕß˵Çý¶¯µÄÖ§³Ö£©¡£LoadRunner±¾ÉíÖ±½ÓÖ§³ÖOracle¡¢SqlServerÊý¾Ý¿â£¬ÕâÁ½¸öÊý¾Ý¿âÖ±½ÓÑ¡ÔñÏàÓ¦µÄЭÒé¾Í¿ÉÒÔÂ¼ÖÆ½Å±¾¡£¶øMySqlÊý¾Ý¿â ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ