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

debian mysql ÔÊÐíÍⲿÁ´½Ó·½·¨

1 modify the  /etc/mysql/my.cnf
# Instead of skip-networking the default is now to listen only on
# localhost which is more compatible and is not less secure.
bind-address           = 127.0.0.1
#
you see the bind-address, comment it. ×¢µôËü¡£
2 update the database -- mysql.
shell > mysql -uroot -p
mysql> show databases;
+--------------------+
| Database           |
+--------------------+
| mysql              |
+--------------------+
5 rows in set (0.00 sec)
mysql> select t.host, t.user from user t;
+-----------+------------------+
| host      | user             |
+-----------+------------------+
|127.0.0.1 | debian-sys-maint |
|127.0.0.1 | james            |
| 127.0.0.1 | root             |
| debian    | root             |
| localhost | root             |
+-----------+------------------+
5 rows in set (0.00 sec)
mysql > update user set host='%' where user='yourUsername';
mysql > flush privileges;
remark:
if wanna create user please follow:
create user 'james'@'%' identified by 'password';


Ïà¹ØÎĵµ£º

MySQLѧϰ1


Ò»¡¢Á¬½ÓMYSQL
¡¡¡¡¸ñʽ£º mysql -hÖ÷»úµØÖ· -uÓû§Ãû £­pÓû§ÃÜÂë
¡¡¡¡1¡¢Àý1£ºÁ¬½Óµ½±¾»úÉϵÄMYSQL¡£
¡¡¡¡Ê×ÏÈÔÚ´ò¿ªDOS´°¿Ú£¬È»ºó½øÈëĿ¼ mysqlbin£¬ÔÙ¼üÈëÃüÁîmysql -uroot -p£¬»Ø³µºóÌáʾÄãÊäÃÜÂ룬Èç¹û¸Õ°²×°ºÃMYSQL£¬³¬¼¶Óû§rootÊÇûÓÐÃÜÂëµÄ£¬¹ÊÖ±½Ó»Ø³µ¼´¿É½øÈëµ½MYSQL ......

Linux°²×°Mysql+Apach+PHP+phpMyAdmin

ÎÒµÄϵͳÊÇredhat as5 ½¨Òé´ó¼ÒÍêÈ«°²×°£¬ÒÔÃⰲװʱȱÉÙÏà¹ØµÄ±àÒëÆ÷µÈµÈ¡£
Ò»¡¢°²×°mysql£¨mysql-5.0.21.tar.gz£©  
# tar zxf mysql-5.0.21.tar.gz
# cd mysql-5.0.21
#./configure --prefix=/usr/local/mysql --sysconfdir=/etc --localstatedir=/var/lib/mysql/
˵Ã÷£º
   #prefix=/usr/lo ......

mysql textºÍblob±È½Ï


1.
blobÊǶþ½øÖÆ´ó¶ÔÏó,¿ÉÒÔÈÝÄɿɱäÁ¿ÊýÁ¿µÄÊý¾Ý,ÆäÖÐblob·ÖΪ4ÖÐÀàÐÍ:TINYBLOB,BLOB,mediumblobºÍLongBlob,ËûÃÇÈÝÄɵij¤¶ÈÊDz»Í¬µÄ.
TextͬÑùÒ²·ÖΪËÄÖÖÀàÐÍ:TINYTEXT¡¢TEXT¡¢MEDIUMTEXTºÍLONGTEXT
2.
blob±»ÊÓΪ¶þ½øÖÆ×Ö·û´®,Text±»ÊÓΪ·Ç¶þ½øÖÆ×Ö·û´®;
blobÁÐûÓÐ×Ö·û¼¯£¬²¢ÇÒÅÅÐòºÍ±È½Ï»ùÓÚÁÐÖµ×Ö½ÚµÄÊýÖµÖµ¡£ ......

MySQLÐÔÄÜÓÅ»¯µÄ×î¼Ñ20+Ìõ¾­Ñé

MySQLÐÔÄÜÓÅ»¯µÄ×î¼Ñ20+Ìõ¾­Ñé
ÎÄÕ·ÖÀà:Êý¾Ý¿â
from£ºhttp://www.uml.org.cn/sjjm/201001041.asp
½ñÌ죬Êý¾Ý¿âµÄ²Ù×÷Ô½À´Ô½³ÉΪÕû¸öÓ¦ÓõÄÐÔÄÜÆ¿¾±ÁË£¬Õâµã¶ÔÓÚWebÓ¦ÓÃÓÈÆäÃ÷ÏÔ¡£¹ØÓÚÊý¾Ý¿âµÄÐÔÄÜ£¬Õâ²¢²»Ö»ÊÇDBA²ÅÐèÒªµ£ÐĵÄÊ£¬¶øÕâ¸üÊÇÎÒÃdzÌÐòÔ±ÐèҪȥ¹Ø×¢µÄÊÂÇé¡£µ±ÎÒÃÇÈ¥Éè¼ÆÊý¾Ý¿â±í½á¹¹£¬¶Ô²Ù×÷Êý¾Ý¿âʱ£¨ÓÈÆäÊ ......

MySQL+PHPÂÒÂë½â¾ö ÄÏÈý·½

 MySQL+PHP²úÉúÂÒÂëÔ­Òò£º
¡ô MySQLÊý¾Ý¿âĬÈϵıàÂëÊÇutf8,Èç¹ûÕâÖÖ±àÂëÓëÄãµÄPHPÍøÒ³²»Ò»ÖÂ,¿ÉÄܾͻáÔì³ÉMySQLÂÒÂ룻
¡ô MySQLÖд´½¨±íʱ»áÈÃÄãÑ¡ÔñÒ»ÖÖ±àÂë,Èç¹ûÕâÖÖ±àÂëÓëÄãµÄÍøÒ³±àÂë²»Ò»ÖÂ,Ò²¿ÉÄÜÔì³ÉMySQLÂÒÂ룻
¡ô MySQL´´½¨±íʱÌí¼Ó×Ö¶ÎÊÇ¿ÉÒÔÑ¡Ôñ±àÂëµÄ,Èç¹ûÕâÖÖ±àÂëÓëÄãµÄÍøÒ³±àÂë²»Ò»ÖÂ,Ò²¿ÉÄÜÔì³ÉMySQ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ