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

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

GRANT ALL PRIVILEGES
1¡£ ¸Ä±í·¨¡£¿ÉÄÜÊÇÄãµÄÕʺŲ»ÔÊÐí´ÓÔ¶³ÌµÇ½£¬Ö»ÄÜÔÚlocalhost¡£Õâ¸öʱºòÖ»ÒªÔÚlocalhostµÄÄÇ̨µçÄÔ£¬µÇÈëmysqlºó£¬¸ü¸Ä "mysql" Êý¾Ý¿âÀïµÄ "user" ±íÀïµÄ "host" Ï´Ó"localhost"¸Ä³Æ"%"
Sql´úÂë ¸´ÖÆ´úÂë
   1. mysql -u root -pvmwaremysql>use mysql; 
   2. mysql>update user set host = '%' where user = 'root'; 
   3. mysql>select host, user from user; 
2. ÊÚȨ·¨¡£ÀýÈ磬ÄãÏëmyuserʹÓÃmypassword´ÓÈκÎÖ÷»úÁ¬½Óµ½mysql·þÎñÆ÷µÄ»°¡£
Sql´úÂë ¸´ÖÆ´úÂë
  1. GRANT ALL PRIVILEGES ON *.* TO 'myuser'@'%' IDENTIFIED BY 'mypassword' WITH
      GRANT OPTION;  
  2.FLUSH   PRIVILEGES; 
Èç¹ûÄãÏëÔÊÐíÓû§myuser´ÓipΪ192.168.1.6µÄÖ÷»úÁ¬½Óµ½mysql·þÎñÆ÷£¬²¢Ê¹ÓÃmypassword×÷ΪÃÜÂë
Sql´úÂë ¸´ÖÆ´úÂë
   1. GRANT ALL PRIVILEGES ON *.* TO 'myuser'@'192.168.1.3' IDENTIFIED BY  
   2. 'mypassword' WITH GRANT OPTION;  
   3. FLUSH   PRIVILEGES; 
GRANT ALL PRIVILEGES ON *.* TO 'myuser'@'192.168.1.3' IDENTIFIED BY
'mypassword' WITH GRANT OPTION;
FLUSH   PRIVILEGES;
Èç¹ûÄãÏëÔÊÐíÓû§myuser´ÓipΪ192.168.1.6µÄÖ÷»úÁ¬½Óµ½mysql·þÎñÆ÷µÄdkÊý¾Ý¿â£¬²¢Ê¹ÓÃmypassword×÷ΪÃÜÂë
Sql´úÂë ¸´ÖÆ´úÂë
   1. GRANT ALL PRIVILEGES ON dk.* TO 'myuser'@'192.168.1.3' IDENTIFIED BY  
   2. 'mypassword' WITH GRANT OPTION;  
   3. FLUSH   PRIVILEGES; 
GRANT ALL PRIVILEGES ON dk.* TO 'myuser'@'192.168.1.3' IDENTIFIED BY
'mypassword' WITH GRANT OPTION;
FLUSH   PRIVILEGES;
×¢ÒâÊÚȨºó±ØÐëFLUSH PRIVILEGES;·ñÔòÎÞ·¨Á¢¼´ÉúЧ¡£
ÁíÍâÒ»ÖÖ·½·¨.
ÔÚ°²×°mysqlµÄ»úÆ÷ÉÏÔËÐУº
1¡¢d:\mysql\bin\>mysql -h localhost -u root
//ÕâÑùÓ¦¸Ã¿ÉÒÔ½øÈëMySQL·þÎñÆ÷
2¡¢mysql>GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' WITH GRANT OPTION
//¸³ÓèÈκÎÖ÷»ú·ÃÎÊÊý¾ÝµÄȨÏÞ
3¡¢mysql>FLUSH PRIVILEGES
//ÐÞ¸ÄÉúЧ
4¡¢mysql>EXIT


Ïà¹ØÎĵµ£º

PHP mysqlÊÂÎñ´¦Àí »Ø¹ö²Ù×÷

MYSQLÖÐÖ»ÓÐINNODBºÍBDBÀàÐ͵ÄÊý¾Ý±í²ÅÄÜÖ§³ÖÊÂÎñ´¦Àí£¡ÆäËûµÄÀàÐÍÊDz»Ö§³ÖµÄ£¡
$lnk = mysql_connect("localhost", "root", "");
mysql_select_db("test");
mysql_query("BEGIN");
$query = mysql_query("INSERT INTO test VALUES(1, 'yangjun')&quo ......

MySQL×Ö·û´®ÁÐÀàÐÍÇø·Ö

 MySQL×Ö·û´®ÁÐÀàÐÍÇø·Ö
1.
Ê×ÏÈCHAR, VARCHAR, TEXTºÍBINARY, VARBINARY, BLOBµÄÇø±ð£º
CHAR, VARCHAR, TEXT³ÆÎª·Ç¶þ½øÖÆ×Ö·û´®£»
BINARY, VARBINARY, BLOB³ÆÎª¶þ½øÖÆ×Ö·û´®£»
¶þ½øÖÆ×Ö·û´®ºÍ·Ç¶þ½øÖÆ×Ö·û´®µÄÇø±ðÊÇ£º
¶þ½øÖÆ×Ö·û´®°üº¬µÄÊÇ×Ö½Ú×Ö·û´®£¬·Ç¶þ½øÖÆ×Ö·û´®°üº¬µÄÊÇ×Ö·û×Ö·û´®£»
ºóÕß¿ÉÒÔ¶¨Òå×Ö·û¼ ......

MySQLµÄMyISAMºÍInnoDB¶Ô±È¼°ÓÅ»¯

±¾ÎÄ×ªÔØ×Ô£ºhttp://hi.baidu.com/xiaoxiaolq/blog/item/7984dcbf15dd030018d81f27.html 
MyISAMºÍInnoDBÊÇÔÚʹÓÃMySQL×î³£ÓõÄÁ½¸ö±íÀàÐÍ£¬¸÷ÓÐÓÅȱµã£¬ÊÓ¾ßÌåÓ¦Óöø¶¨¡£»ù±¾µÄ²î±ðΪ£ºMyISAMÀàÐͲ»Ö§³ÖÊÂÎñ´¦ÀíµÈ¸ß¼¶´¦Àí£¬¶øInnoDBÀàÐÍÖ§³Ö¡£MyISAMÀàÐ͵ıíÇ¿µ÷µÄÊÇÐÔÄÜ£¬ÆäÖ´ÐÐÊý¶È±ÈInnoDBÀàÐ͸ü¿ì£¬µ«ÊDz»Ìá¹©Ê ......

MySQL µÄÍâ¼üÓë²ÎÕÕÍêÕûÐÔ

 
1. Ê²Ã´ÊDzÎÕÕÍêÕûÐÔ?
——————–
²ÎÕÕÍêÕûÐÔ(ÍêÕûÐÔÔ¼Êø)ÊÇÊý¾Ý¿âÉè¼ÆÖеÄÒ»¸öÖØÒª¸ÅÄµ±Êý¾Ý¿âÖеÄÒ»¸ö±íÓëÒ»¸ö»ò¶à¸ö±í½øÐйØÁªÊ±¶¼»áÉæ¼°µ½²ÎÕÕÍêÕûÐÔ¡£±ÈÈçÏÂÃæÕâ¸öÀý×Ó£º
ÎÄÕ·ÖÀà±í -  categories
category_id    &n ......

linuxϵͳµÄ°²×°(redhat7.2)+jsp»·¾³+mysql+°²È«ÉèÖÃ

 1 1 Linux Red Hat 7.2 °²×°
¡¡¡¡Red Hat Linux 7.2µÄ°²×°¹âÅ̹²ÓÐÁ½ÕÅ£ºµÚÒ»ÕÅ¿ÉÒÔÖ±½Ó´Ó¹âÅÌÆô¶¯£¬°üº¬Á˴󲿷ֵÄÈí¼þ°üºÍһЩ°²×°¹¤¾ß£»µÚ¶þÕŹâÅ̳ýÁ˸½¼ÓµÄÈí¼þ°üÍ⣬Ö÷ÒªÊÇÔ´Âë¡¢Ô¤ÀÀ°æÈí¼þµÈ¡£
¡¡¡¡Red Hat Linux 7.2µÄ°²×°½çÃæ·Ç³£ÓѺã¬×óÃæÓм´Ê±Ï꾡µÄ°ïÖúÐÅÏ¢£¬ÓÒÃæÊÇÑ¡ÏÍêȫ֧³ÖÊó±ê²Ù×÷¡£
¡¡¡¡½« ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ