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

linux mysqlÍü¼ÇÃÜÂëµÄ¶àÖÖ½â¾ö·½·¨¡£


ÎÒµÄϵͳÊÇubuntu6.06£¬×î½üÐÂ×°ºÃµÄmysqlÔÚ½øÈëmysql¹¤¾ßʱ£¬×ÜÊÇÓдíÎóÌáʾ:
# mysql -uroot -p
Enter password:
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
ʹÓÃÍøÉϽéÉܵķ½·¨ÐÞ¸ÄrootÓû§µÄÃÜÂ룺
# mysqladmin -uroot -p password 'newpassword'
Enter password:
mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user 'root'@'localhost' (using password: YES)'
ÏÖÔÚÖÕÓÚ±»ÎÒÕÒµ½Á˽â¾ö·½·¨£¬ÈçÏ£¨ÇëÏȲâÊÔ·½·¨Èý£¬Ð»Ð»£¡£©£º
·½·¨Ò»£º
# /etc/init.d/mysql stop
# mysqld_safe --user=mysql --skip-grant-tables --skip-networking &
# mysql -u root mysql
mysql> UPDATE user SET Password=PASSWORD('newpassword') where USER='root';
mysql> FLUSH PRIVILEGES;
mysql> quit
# /etc/init.d/mysql restart
# mysql -uroot -p
Enter password: <ÊäÈëÐÂÉèµÄÃÜÂënewpassword>
mysql>
·½·¨¶þ£º
Ö±½ÓʹÓÃ/etc/mysql/debian.cnfÎļþÖÐ[client]½ÚÌṩµÄÓû§ÃûºÍÃÜÂë:
# mysql -udebian-sys-maint -p
Enter password: <ÊäÈë[client]½ÚµÄÃÜÂë>
mysql> UPDATE user SET Password=PASSWORD('newpassword') where USER='root';
mysql> FLUSH PRIVILEGES;
mysql> quit
# mysql -uroot -p
Enter password: <ÊäÈëÐÂÉèµÄÃÜÂënewpassword>
mysql>
·½·¨Èý£º
ÕâÖÖ·½·¨ÎÒûÓнøÐйý²âÊÔ£¬ÒòΪÎÒµÄrootÓû§Ä¬ÈÏÃÜÂëÒѾ­±»ÎÒÐ޸ĹýÁË£¬ÄÇλÓпղâÊÔһϣ¬°Ñ½á¹û¸æËßÎÒ£¬Ð»Ð»£¡£¡
# mysql -uroot -p
Enter password: <ÊäÈë/etc/mysql/debian.cnfÎļþÖÐ[client]½ÚÌṩµÄÃÜÂë>
ÖÁ´Ë£¬À§»ó¶àʱµÄÎÊÌâ½â¾öÁË£¡


Ïà¹ØÎĵµ£º

ʵս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µÈЭÒé ......

mysql ÖеÄ×Ö·û´®Á¬½Ó CONCAT(str1,str2,...)

·µ»ØÀ´×ÔÓÚ²ÎÊýÁ¬½áµÄ×Ö·û´®¡£Èç¹ûÈκβÎÊýÊÇNULL£¬·µ»ØNULL¡£¿ÉÒÔÓг¬¹ý2¸öµÄ²ÎÊý¡£Ò»¸öÊý×Ö²ÎÊý±»±ä»»ÎªµÈ¼ÛµÄ×Ö·û´®ÐÎʽ¡£
mysql> select CONCAT('My', 'S', 'QL');
-> 'MySQL'
mysql> select CONCAT('My', NULL, 'QL');
-> NULL
mysql> select CONCAT(14.3);
-> '14.3'
È磺update test set ......

Ubuntu Linuxϵͳ½¨Á¢FTP·þÎñÆ÷·½·¨²½Öè

¡¡¡¡Îļþ´«ÊäЭÒé (FTP) ÊÇÒ»¸ö TCP ЭÒ飬ÓÃÓÚÔÚ¼ÆËã»úÖ®¼äÉÏ´«ºÍÏÂÔØÎļþ¡£FTP ¹¤×÷ÔÚ¿Í»§¶Ë/·þÎñÆ÷ģʽÏ¡£·þÎñÆ÷×é¼þ±»³ÆÎª FTP ÊØ»¤³ÌÐò¡£Ëü³ÖÐø²»¶ÏµØÁÙÌýÀ´×ÔÔ¶³Ì¿Í»§¶ËµÄ FTP ÇëÇó¡£µ±Ò»¸öÇëÇóµ½´ïʱ£¬Ëü¹ÜÀíµÇ¼ºÍ½¨Á¢Á¬½Ó¡£ÔÚÕû¸ö»á»°ÆÚ¼äËüÖ´ÐÐ FTP ¿Í»§¶Ë·¢ËÍÀ´µÄÈκÎÃüÁî¡£ ¿ÉÒÔͨ¹ýÁ½ÖÖ·½Ê½À´¹ÜÀí FTP ·þÎñÆ÷ ......

Linuxµç×ÓÊéÏÂÔØ

Linuxµç×ÓÊéÏÂÔØ——µÚÒ»²¿·Ö£º Linux»ù´¡Ó¦ÓÃ
µÚÒ»²¿·Ö£ºLinux»ù´¡Ó¦ÓÃ
1¡¢¡¶Linux´ÓÈëÃŵ½¾«Í¨¡·
http://www.gouhuo.com/study/linuxbook.zip
2¡¢ Linux ϵͳ°²È«ÓëÓÅ»¯ÖÐÎİæ
Õâ±¾ÊéµÄÓ¢Îİæ“Get Acquainted with Linux Security and Optimization System”£¨¼ò³ÆLinuxSOS£©ÊÇLinuxÎĵµ¼Æ»®£¨ ......

linuxÍøÂçѧϰ±Ê¼Ç Íø¿¨Çý¶¯Êý¾Ý½ÓÊÕ[zz]

ת×Ôhttp://blog.chinaunix.net/u3/105004/showart_2088056.html
Êý¾Ý½ÓÊÕ
Íø¿¨Çý¶¯µÄÊý¾Ý½ÓÊÕ£¬Êµ¼ÊÉÏÊÇÒ»¸öÉú²úÕß/Ïû·ÑÕßÄ£ÐÍ¡£ºËÐÄÊÇÊäÈë¶ÓÁУ¨È«¾ÖµÄ£¬»òÕßÍø¿¨Ë½Óеģ©¡£Íø¿¨ÊÕµ½Êý¾Ýʱ£¬´¥·¢Öжϡ£ÔÚÖжÏÖ´ÐÐÀý³ÌÖУ¬°Ñskb¹ÒÈëÊäÈë¶ÓÁУ¬²¢³ö·¢ÈíÖжϡ£ÉÔºóµÄij¸öʱ¿Ì£¬µ±ÈíÖжÏÖ´ÐÐʱ£¬ÔٴӸöÓÁÐÖаÑskbÈ¡ÏÂÀ´£¬Í ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ