Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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ËÙ¶ÈÂýµÄ½â¾ö·½·¨

Ô¶³ÌÁ¬½ÓmysqlËÙ¶ÈÂýµÄ½â¾ö·½·¨
http://www.xishuiw.com
¡¡¡¡PHP Ô¶³ÌÁ¬½ÓMYSQLËÙ¶ÈÂý,ÓÐʱԶ³ÌÁ¬½Óµ½MYSQLÓÃʱ4-20Ãë²»µÈ,±¾µØÁ¬½ÓMYSQLÕý³£,³öÏÖÕâÖÖÎÊÌâµÄÖ÷ÒªÔ­ÒòÊÇ,ĬÈϰ²×°µÄMYSQL¿ªÆôÁËDNSµÄ·´Ïò½âÎö,ÔÚMY.INI(WINDOWSϵͳÏÂ)»òMY.CNF(UNIX»òLINUXϵͳÏÂ)ÎļþµÄ[mysqld]ϼÓÈëskip- name-resolveÕâÒ»¾ä¡£Á¬½Ómysq ......

ÁÙʱ±íÔÚSQL ServerºÍMySqlÖд´½¨µÄ·½·¨

SQL Server´´½¨ÁÙʱ±í£º
´´½¨ÁÙʱ±í
·½·¨Ò»£º
create table #ÁÙʱ±íÃû(×Ö¶Î1 Ô¼ÊøÌõ¼þ,
×Ö¶Î2 Ô¼ÊøÌõ¼þ,
.....)
create table ##ÁÙʱ±íÃû(×Ö¶Î1 Ô¼ÊøÌõ¼þ,
×Ö¶Î2 Ô¼ÊøÌõ¼þ,
.....)
·½·¨¶þ£º
select * into #ÁÙʱ±íÃû from ÄãµÄ±í;
select * into ##ÁÙʱ±íÃû from ÄãµÄ±í;
×¢£ºÒÔÉϵÄ#´ú±í¾Ö²¿ÁÙʱ±í£¬##´ú±íÈ«¾ ......

Mysqlµ¼³öÃüÁîÎļþºÍÃüÁîÎļþµ¼Èë

1)ÃüÁîµ¼³ö
ÔÚÃüÁîÌáʾ·ûģʽÏ£º
mysqldump -u  Óû§ -p Êý¾Ý¿â ±íÃû>ÎļþÃû.sql
eg:
mysqldump -u root -p mysql tbcustomerid>a.sql
µ¼³öµÄÃüÁîÎļþÔÚµ±Ç°ÃüÁîÌáʾ·û·¾¶Ï¡£
Èç¹ûÒªµ¼³öÕû¸öÊý¾Ý¿âÃüÁîΪ£º
mysqldump -u  Óû§ -p Êý¾Ý¿â ±íÃû>ÎļþÃû.sql
2£©ÃüÁîÎļþµ¼Èë
   ¢Ùµ ......

vc mysql Á¬½ÓʵÀý

MySQLÊý¾Ý¿â½Ó¿ÚµÄVCʵÏÖÓëÓ¦ÓÃ...phpma¿ªÔ´
        ÕªÒª£ºMySQLÊý¾Ý¿â×÷ΪһÖÖÍøÂçÊý¾Ý¿âÐÔÄÜÊ®·Ö³öÉ«£¬µ«ÆäÔÚÓ¦ÓÃÈí¼þÖÐʹÓýÏÉÙ¡£±¾ÎĽ«Ö÷Ҫ̽ÌÖMySQLÌṩµÄÁ½ÖÖÊý¾Ý¿â½Ó¿Ú ——£¨ODBC APIºÍC API£©ÔÚVCÖеÄÓ¦Ó㬲¢ÇÒÐγÉÒ»¸öÀàÓÃÒÔ·â×°C APIÊý¾Ý¿â½Ó¿ÚµÄ¹¦ÄÜ¡£phpma¿ª ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ