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

linux mysqlµÄ°²×°¼°Ò»Ð©ÅäÖ÷½·¨

1.¼ì²éÒÔǰ°²×°µÄMySQL,Ð¶ÔØ¡£
rpm -qa|grep -i mysql
rpm -e XXXXX
×¢Èç¹û³öÏÖÁ½ÌõÏàͬµÄ£¬ÔòʹÓÃrpm -e --allmatches
2.°²×°rpm°ü¡£
rpm -ivh MySQL-server-community-5.1.37-0.rhel5.x86_64.rpm
rpm -ivh MySQL-shared-community-5.1.37-0.rhel5.x86_64.rpm
rpm -ivh MySQL-devel-community-5.1.37-0.rhel5.x86_64.rpm
rpm -ivh MySQL-client-community-5.1.37-0.rhel5.x86_64.rpm
3.cp ²ÎÊýÎļþµ½ /etc/my.cnf
find / -name "my*.cnf"
Ìí¼Ó²ÎÊý
transaction-isolation=READ-COMMITTED
default-storage-engine=INNODB
innodb_flush_log_at_trx_commit=2
4.¸üÐÂȨÏÞ¼°Óû§
mysql -u root -p
use mysql;
select user,host from user;
delete from user where user <> 'root';
delete from user where host <> 'localhost';
update user set host ='%' where user ='root';
select user,host from user;
¸üÐÂuser±íµ½ÈçÏÂ״̬
mysql> select user,host from user;
+------+------+
| user | host |
+------+------+
| root | %    |
+------+------+
1 row in set (0.00 sec)
´´½¨Óû§
grant select,insert,update,delete,create,drop,alter,index,RELOAD, lock tables, execute, create routine, alter routine,Create temporary tables 
on *.* to mysql@"%" identified by "123456";
set global transaction isolation level read committed;
set session transaction isolation level read committed;
¸üÐÂȨÏÞ
flush privileges;
5.ÉèÖÃÃÜÂë(123456)
mysqladmin -u root -p password ×××
####mysqladmin -u root -p password mypasswd
6.ÖØÆô·þÎñ£¬ÑéÖ¤ÉèÖá£
/etc/init.d/mysql restart
怫mysql
Ð¶ÔØÇý¶¯
rpm -e --justdb mysql-connector-odbc-5.1.5-0
key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 1234 K
bytes of memory
MySQL Íü¼Ç¿ÚÁîµÄ½â¾ö°ì·¨
Èç¹û MySQL ÕýÔÚÔËÐУ¬Ê×ÏÈɱ֮£º killall -TERM mysqld¡£
Æô¶¯ MySQL £ºbin/safe_mysqld --skip-grant-tables &
¾Í¿ÉÒÔ²»ÐèÒªÃÜÂë¾Í½øÈë MySQL ÁË¡£
È»ºó¾ÍÊÇ
use mysql;
update user set password=password("new_pass") where user="root";
update user set password=password(


Ïà¹ØÎĵµ£º

ʵսLinux Bluetooth±à³Ì£¨Èý£© HCI²ã±à³Ì

1. HCI²ãЭÒé¸ÅÊö£º
HCIÌṩһÌ×ͳһµÄ·½·¨À´·ÃÎÊBluetoothµ×²ã¡£ÈçͼËùʾ£º
´ÓͼÉÏ¿ÉÒÔ¿´³ö£¬Host Controller Interface(HCI)  ¾ÍÊÇÓÃÀ´¹µÍ¨HostºÍModule¡£Hostͨ³£¾ÍÊÇPC£¬ ModuleÔòÊÇÒÔ¸÷ÖÖÎïÀíÁ¬½ÓÐÎʽ£¨USB,serial,pc-cardµÈ£©Á¬½Óµ½PCÉϵÄbluetooth Dongle¡£
ÔÚHostÕâÒ»¶Ë£ºapplication,SDP,L2capµÈЭÒé ......

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

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

Linux¼¯Èº

Linux¼¯Èº´óÈ«
2009-12-29 20:54
¼ÆËã Linux Öм¯ÈºÏîÄ¿µÄÊýÁ¿¾ÍÏó¼ÆËã¹è¹ÈÖд´Òµ¹«Ë¾µÄÊýÁ¿Ò»Ñù¡£²»Ïó Windows NT ÒѾ­ÊÜÆä×ÔÉíµÄ·â±Õ»·¾³×è°­£¬Linux ÓдóÁ¿µÄ¼¯ÈºÏµÍ³¿É¹©Ñ¡Ôñ£¬ÊʺÏÓÚ²»Í¬µÄÓÃ;ºÍÐèÒª¡£µ«È·¶¨Ó¦¸ÃʹÓÃÄÄÒ»¸ö¼¯ÈºµÄ¹¤×÷ȴûÓÐÒò´Ë±äµÃ¼òµ¥¡£
ÎÊÌâµÄ²¿·ÖÔ­ÒòÔÚÓÚÊõÓOȺÓÃÓÚ²»Í¬³¡ºÏ¡£IT ¾­Àí¿ÉÄܹØÐ ......

MySQL Êý¾Ý¿âÓï¾äÓÅ»¯µÄÔ­Ôò

1¡¢Ê¹ÓÃË÷ÒýÀ´¸ü¿ìµØ±éÀú±í¡£
ȱʡÇé¿öϽ¨Á¢µÄË÷ÒýÊÇ·ÇȺ¼¯Ë÷Òý£¬µ«ÓÐʱËü²¢²»ÊÇ×î¼ÑµÄ¡£ÔÚ·ÇȺ¼¯Ë÷ÒýÏ£¬Êý¾ÝÔÚÎïÀíÉÏËæ»ú´æ·ÅÔÚÊý¾ÝÒ³ÉÏ¡£ºÏÀíµÄË÷ÒýÉè¼ÆÒª½¨Á¢ÔÚ¶Ô¸÷ÖÖ²éѯµÄ·ÖÎöºÍÔ¤²âÉÏ¡£Ò»°ãÀ´Ëµ£º
a.ÓдóÁ¿Öظ´Öµ¡¢ÇÒ¾­³£Óз¶Î§²éѯ( > ,< £¬> =,< =)ºÍorder by¡¢group by·¢ÉúµÄÁУ¬¿É¿¼Âǽ¨Á¢Èº¼¯Ë÷ ......

MySQL µÄ±í¼¶Ëø

 ÔÚ¿ª·¢ÏîĿʱ£¬Óöµ½Ò»¸öÎÊÌ⣬¾ÍÊÇÒªËæ»ú¶ÁȡһÕűíµÄ²¿·Ö¼Ç¼£¬²¢updateÉèÖÃΪ²»¿ÉÔÚ¶Á£¬ÕâÀï¾ÍÓÐÒ»¸öÎÊÌ⣬¿ÉÄܶà¸öÈËÍ¬Ê±Ëæ»úµ½ÏàͬµÄ¼Ç¼£¬²¢Öظ´×öupdate²Ù×÷£¬ÒýÆðÊý¾ÝÔà¶ÁºÍÖØ¸´²Ù×÷£¬
Òò´Ë¿¼ÂǸø±í¼ÓËø¡£µ«ÊDzÉÓÃÁËMyISAM£¬²»Ö§³ÖÊÂÎñ£¬Ö»ÄÜ¼Ó±í¼¶Ëø£¬¶øÇÒ±ðÈËÁ¬¶ÁµÄȨÏÞ¶¼Ã»ÓС£ÏÂÃæÊÇ2¸ö²âÊÔÎļþ£¬ÔÚfiref ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ