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

ÃüÁîÐÐÈçºÎÔ¶³ÌÁ¬½ÓMySQLÊý¾Ý¿â

 ÐÂʹÓÃMySQL£¬ËµÆðÀ´ÊǸö¼òµ¥µÄÊÂÇ飬µ«ÊÇÈ´·ÑÁËЩÖÜÕÛ£º
1¡¢µÇ½·þÎñÆ÷¶Ë£¬½øÈëÃüÁîÐУ¬windows cmd;
2¡¢ÉèÖÃÓû§¡¢ÃÜÂëÈÃÖ¸¶¨µÄIP·ÃÎÊ£ºmysql -u root -p »ò°²×°µÄ¿ì½Ý·½Ê½½øÈë:MySQL Command Line Client,ʹÓÃgrantÃüÁ
grant ȨÏÞ1,ȨÏÞ2,…ȨÏÞn on Êý¾Ý¿âÃû³Æ.±íÃû³Æ to Óû§Ãû@Óû§µØÖ· identified by 'Á¬½Ó¿ÚÁî';
Àý×Ó£º
mysql>grant select,insert,update,delete,create,drop on mydb.mytable to lzpddd@192.168.1.88 identified by 'mypassword';
¸øÀ´×Ô192.168.1.88µÄÓû§lzpddd·ÖÅä¿É¶ÔÊý¾Ý¿â mydbµÄmytable±í½øÐÐselect,insert,update,delete,create,dropµÈ²Ù×÷µÄȨÏÞ£¬²¢É趨¿ÚÁîΪ'mypassword';
mysql>grant all privileges on *.* to lzpddd@192.168.1.88 identified by 'mypassword';
¸øÀ´×Ô192.168.1.88µÄÓû§lzpddd·ÖÅä¿É¶ÔËùÓÐÊý¾Ý¿âµÄËùÓÐ±í½øÐÐËùÓвÙ×÷µÄȨÏÞÏÞ£¬²¢É趨¿ÚÁîΪ'mypassword';
mysql>grant all privileges on *.* to lzpddd@% identified by 'mypassword';
¸øÀ´×ÔÈκÎIPµØÖ·µÄÓû§lzpddd·ÖÅä¿É¶ÔËùÓÐÊý¾Ý¿âµÄËùÓÐ±í½øÐÐËùÓвÙ×÷µÄȨÏÞÏÞ£¬²¢É趨¿ÚÁîΪ'mypassword';
3¡¢¹Ø±Õ·þÎñÆ÷¶Ë·À»ðǽ»òÕß¿ª·Å3306¶Ë¿Ú£¨ºÜÖØÒª£©£»
4¡¢¿Í»§¶ËÁ¬½Ó£º
½øÈëÃüÁîÐУ¬windows cmd£¬Á¬½Ó£º
mysql -u Óû§Ãû -pÃÜÂë -h ·þÎñÆ÷IPµØÖ· -P ·þÎñÆ÷¶ËMySQL¶Ë¿ÚºÅ -D Êý¾Ý¿âÃû
×¢Ò⣺
    (1)·þÎñÆ÷¶Ë¿Ú±êÖ¾-PÒ»¶¨Òª´óЩÒÔÇø±ðÓÚÓû§-p,Èç¹ûÖ±½ÓÁ¬½ÓÊý¾Ý¿â±êÖ¾-DÒ²Òª´óд£»
    (2)Èç¹ûÒªÖ±½ÓÊäÈëÃÜÂë-pºóÃæ²»ÄÜÁôÓпոñÈç-pmypassword;
    (3)ÃüÁî½áÊø¶ÎûÓÐ';'·ÖºÅ¡£
Àý×Ó£º
mysql -u lzpddd -pmypassword -h 192.168.1.88 -P 3306 -D mydb


Ïà¹ØÎĵµ£º

ʹMySQL rootÕË»§ÄÜÔ¶³Ì·ÃÎÊ

1.µÇ¼MySQLÖÕ¶Ë 2.ÊÚȨ:
ÔÊÐíËùÓлúÆ÷·ÃÎÊMySQL·þÎñÆ÷
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%'IDENTIFIED BY 'password' WITH GRANT OPTION;
FLUSH RIVILEGES;
ÔÊÐíÖ¸¶¨»úÆ÷·ÃÎÊMySQL·þÎñÆ÷
GRANT ALL PRIVILEGES ON *.* TO 'root'@'IPµØÖ·'IDENTIFIED BY 'password' WITH GRANT OPTION; ......

Çë×¢ÒâMYSQLÓï¾äÖеÄÒýºÅ

SQL #1: select * from uchome_feed where uid in('0',501...) order by dateline desc limit 0,50;
SQL #2: select * from uchome_feed where uid in(0,501...) order by dateline desc limit 0,50;
SQL #1  ÊÇCSDN ¸öÈ˿ռä»ñÈ¡¸öÈ˶¯Ì¬µÄSQL£¬ÊôUCHÔ­°æSQL¡£
SQL #2 ÊÇÈ¥µôµ¥ÒýºÅ(SQL #1ÖкìÉ«²¿·Ö)ºóµÄSQL£¬Á½¸ ......

ÈçºÎÌá¸ßMysqlÓï¾ä²åÈëÐÔÄÜ

ÔÚ±íÖÐÒÑÓдóÁ¿µÄindexµÄÇé¿öϲåÈë´óÁ¿Êý¾Ý£¬¿ÉÒÔ²ÉÓÃÏȽ«Ë÷Òýɾ³ý£¬È»ºóÔÙ²åÈëÊý¾Ý£¬È»ºóÔÙÖØÐ½¨Á¢Ë÷Òý¡£Ö®ËùÒÔÕâÑù»á¿ìÊÇÒòΪ£¿£¿£¿
7.2.14 Speed of INSERT Statements
The time to insert a record is determined by the following factors, where the numbers indicate approximate proportions:
  & ......

MySQL±¸·ÝµÄ¼¸ÖÖ·½Ê½µÄÌÖÂÛ£¬ÖØµã¹Ø×¢ÔÚÏßÈȱ¸

MySQLµÄ±¸·Ý·½Ê½£¬Ä¿Ç°ÎÒÏëµ½µÄÓÐÎåÖÖ£¬ÓпÉÄÜ»¹ÓÐ
1£¬mysqldump·½Ê½£¬¼ÓÉϾßÌå²ÎÊýÃû£¨µ¥¿â£¬¶à¿â£¬´¥·¢Æ÷£¬´æ´¢¹ý³Ì£¬±í½á¹¹£¬×Ö·û¼¯£¬–single-transaction£¬µÈµÈ£©
2£¬mysqlhotcopy Ö»Äܱ¸·ÝmyisamÊý¾Ý±í±¸·Ý£¬ËÙ¶ÈÏ൱¿ì£¬ÒòΪÊÇÎļþ¿½±´£¬¿ÉÄÜ˲¼ä±»Ëø±í£¬ÈκεÄÊý¾Ý²Ù×÷£¬±ÈÈç²åÈëºÍ¸üж¼»á¹ÒÆð¡£
3£¬LVMµ ......

UbuntuÉÏMySQL°²×°Ö¸ÄÏ


Òª°²×° MySQL£¬¿ÉÒÔÔÚÖÕ¶ËÌáʾ·ûºóÔËÐÐÏÂÁÐÃüÁ
sudo apt-get install mysql-server
sudo apt-get install mysql-client
sudo apt-get install php5-mysql
// °²×°php5-mysql Êǽ«phpºÍmysqlÁ¬½ÓÆðÀ´
Ò»µ©°²×°Íê³É£¬MySQL ·þÎñÆ÷Ó¦¸Ã×Ô¶¯Æô¶¯¡£Äú¿ÉÒÔÔÚÖÕ¶ËÌáʾ·ûºóÔËÐÐÒÔÏÂÃüÁîÀ´¼ì²é MySQL ·þÎñÆ÷ÊÇ·ñÕýÔÚÔËÐУº ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ