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

LinuxÍø¹Ü±Ê¼Ç£¨24£©ÖØÐÂÕÒµ½MySQLÊý¾Ý¿âµÄrootÃÜÂë

Íü¼ÇMySQL ROOTÃÜÂëÊÇÔÚMySQLʹÓÃÖкܳ£¼ûµÄÎÊÌ⡣ûÏëµ½½ñÌì¾ÍÅöµ½ÕâÑùÒ»¸öÎÊÌ⣺ÄÚ²¿µÄmysqlµÄrootÃÜÂë±»ÐÞ¸ÄÁË¡£²éÔÄ×ÊÁÏ£¬ÓÐÈçÏ·½·¨£º Unix&Linux£º
1.ÓÃroot»òÕßÔËÐÐmysqldµÄÓû§µÇ¼ϵͳ£»
2£®ÀûÓÃkillÃüÁî½áÊøµômysqldµÄ½ø³Ì£»
3£®Ê¹ÓÃ--skip-grant-tables²ÎÊýÆô¶¯MySQL Server
shell>mysqld_safe --skip-grant-tables &
4.Ϊroot@localhostÉèÖÃÐÂÃÜÂë
shell>mysqladmin -u root flush-privileges password "newpassword"5£®ÖØÆôMySQL Server µ«×ܵÃ×Ô¼ºÊµ¼ùһϣ¬·½·¨ÈçÏ£º 1.¹Ø±Õmysql·þÎñ /etc/init.d/mysqld stop
2.ʹÓÖskip-grant-tablesÑ¡ÏîÆô¶¯MySQL·þÎñ,¿ÉÒÔÐÞ¸Ä/etc/inin.d/mysqld½Å±¾Æô¶¯Î»ÖÃÔö¼Ó´ËÑ¡Ï vi /etc/init.d/mysqld
ÔÚÏÂÃæÔËÐÐÆô¶¯µÄÓï¾äÀïÔö¼Ó--skip-grant-tables /usr/bin/mysqld_safe --skip-grant-tables --datadir="$datadir" --socket="$socketfile" \
--log-error="$errlogfile" --pid-file="$mypidfile" \ ¼ÓÈë--skip-grant-tablesµÄÒâ˼ÊÇÆô¶¯MySQL·þÎñµÄʱºòÌø¹ýȨÏÞ±íÈÏÖ¤¡£Æô¶¯ºó£¬Á¬½Óµ½MySQLµÄroot²»ÐèÒª¿ÚÁî 3.ÖØÐÂÆô¶¯mysql·þÎñ /etc/init.d/mysqld start
4.ÐÞ¸ÄrootÓû§µÄÃÜÂ룻 mysql> update mysql.user set password=PASSWORD£¨'123456'£© where User=root£»
mysql> flush privileges£»
mysql> quit 5. ÖØÐÂÆô¶¯MySQL£¬¾Í¿ÉÒÔʹÓÃÐÂÃÜÂëµÇ¼ÁË¡£ mysql -u root –p
ÊäÈëÃÜÂ룺123456
6.¹Ø±Õmysql·þÎñ /etc/init.d/mysqld stop
7.ÖØÐÂÐ޸ĵÚ2²½Ð޸ĵÄ/etc/init.d/mysqld£¬Ê¹Æä±£³ÖÔ­À´²»±ä£¬Ò²¾ÍÊÇÈ¡Ïû--skip-grant-tablesÓï¾ä8.ÖØÐÂÆô¶¯mysql·þÎñ
/etc/init.d/mysqld start


Ïà¹ØÎĵµ£º

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

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

linuxÏÂcscopeµÄʹÓÃ

 ÔÚfcdµÄÏîÄ¿ÖУ¬Ê¹ÓÃvim×÷Ϊide¡£ÄÇôcscope¿ÉÒÔ°ïÖúvimÀ©Õ¹ÀàËÆÓÚº¯Êý¡¢¶ÔÏóµÄ²éÕÒ¡¢½»²æÒýÓòéѯµÈ¹¦ÄÜ¡£
ÃüÁîÐÐΪ£º
cscope -Rbkq
Éú³Éµ±Ç°Ä¿Â¼ÏÂcscope.outÎļþÐÅÏ¢£¬±£´æ×Ž»²æÒýÓõÄÐÅÏ¢¡£
vimÖУ¬cscoupʹÓãº
cs add cscope.out
È»ºó²éÕÒ£º
cs find s Òª²éÕÒµÄÃû³Æ
ÆäÖÐs´¦¿ÉÒÔÊÇ£º ......

MySQL 5.0°²×°Í¼½â

ÏÂÃæµÄÊÇMySQL°²×°µÄͼ½â:¡¡¡¡
Ë«»÷ÔËÐГsetup.exe”£¬³öÏÖÈçϽçÃæ£º 
mysql°²×°Ïòµ¼Æô¶¯£¬°´“Next”¼ÌÐø
Ñ¡Ôñ°²×°ÀàÐÍ£¬ÓГTypical£¨Ä¬ÈÏ£©”¡¢“Complete£¨ÍêÈ«£©”¡¢“Custom£¨Óû§×Ô¶¨Ò壩”Èý¸öÑ¡ÏÎÒÃÇÑ¡Ôñ“Custom”£¬Óиü¶àµÄÑ¡ÏҲ· ......

mysql ÐÞ¸ÄÕʺÅÔ¶³ÌµÇ½ȨÏÞ

GRANT ALL PRIVILEGES
1¡£ ¸Ä±í·¨¡£¿ÉÄÜÊÇÄãµÄÕʺŲ»ÔÊÐí´ÓÔ¶³ÌµÇ½£¬Ö»ÄÜÔÚlocalhost¡£Õâ¸öʱºòÖ»ÒªÔÚlocalhostµÄÄÇ̨µçÄÔ£¬µÇÈëmysqlºó£¬¸ü¸Ä "mysql" Êý¾Ý¿âÀïµÄ "user" ±íÀïµÄ "host" Ï´Ó"localhost"¸Ä³Æ"%"
Sql´úÂë ¸´ÖÆ´úÂë
   1. mysql -u root -pvmwaremysql>use mysql; 
   ......

ÐÞ¸ÄmysqlµÄĬÈÏ×Ö·û¼¯

 °²×°mysql
sudo apt-get install mysql-server#Ö±½Ó×Ô¶¯»ñµÃ¿ÉÓð汾
Ò²¿ÉÒÔÕâÑùд
sudo apt-geti nstall mysql-server-5.0#°²×°mysql·þÎñÆ÷5.0°æ±¾
°²×°ºó
/etc/init.d/mysqlstart(stop)ΪÆô¶¯ºÍÍ£Ö¹·þÎñÆ÷
/etc/mysql/Ö÷ÒªÅäÖÃÎļþËùÔÚλÖÃmy.cnf
/var/lib/mysql/·ÅÖõÄÊÇÊý¾Ý¿â±íÎļþ¼Ð£¬ÕâÀïµÄmysqlÏ൱ÓÚ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ