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

¹ØÓÚmysql¶ÁÈ¡¡¢Ð´Èë³öÏÖÂÒÂëµÄ½â¾ö·½·¨£¨¸öÈË×ܽᣩ

ÎÒʹÓõÄÊÇapserv°²×°°ü£¬°²×°Ê±ÓïÑÔÎÒÑ¡ÔñµÄÊÇgb2312£¬ºóÀ´ÔÚ½¨Á¢ÐµÄÊý¾Ý¿âʱ£¬‘ÕûÀí’Ñ¡ÔñµÄÊÇutf8£¬½ÓÏÂÀ´ÔÚ±íÖвÎÊýÀàÐÍ»ù±¾Ñ¡ÔñµÄ¶¼ÊÇutf8£¬½ÓÏÂÀ´ÎÒ¾ÍÖ±½Óµ÷ÓÃÀ²£¬¸Â¸Â£¬ÎÒдµÄÊÇÒ»¸ö¼òµ¥µÄÁôÑÔ±¾¡£×î¼òµ¥µÄ¶ÁÈ¡Êý¾Ý¿âдÈëÊý¾Ý¿âµÄ³ÌÐò£¬¸Â¸Â£¡Ææ¹ÖµÄÊÇÔÚÊý¾Ý¿âÀïÃæÖ±½Ó²Ù×÷ÖÐÎÄÏÔʾ¶¼ºÜÕý³£¡£¿ÉÊÇÒ»µ½ÍøÒ³É϶ÁÈ¡ÁôÑÔÐÅϢʱ£¬ÖÐÎÄÈ«²¿ÊÇÎʺţ¿£¬È»ºóÎÒÓÖÊÔ×Åд³öдÁôÑÔ´úÂëÊÔÊÔ¿´£¬orz£¬¶Á½øÈ¥µÄ¶¼ÊÇÄǸö²»ÖªµÀʲô·ûºÅ¡£¡£¡£
  ÓÚÊǺõÎÒ¾ÍÈ¥ÍøÉÏ·­Ì츲µØµÄÕÒÁ˺þã¬ÖÕÓÚKOÁËÕâ¸öÎÊÌ⣬¸Â¸Â¡£
Ê×ÏÈÉùÃ÷±¾È˳õѧ£¬Ö»Äܱ£Ö¤ÎÒÕâÖÖ·½·¨ÊÇÄܹ»½â¾ö¶ÁȡдÈëÂÒÂëµÄ¡£µ«ÊDz»´ú±íÖ»ÄÜÕâÑù×ö¡£¡£¡£
ÎҵĽâ¾ö·½·¨ÈçÏ£º
1.my.iniÎļþÖеÄ
[mysql]
default-character-set = utf8  //´Ë´¦ÉèÖÃΪutf8,×¢Òâ²»ÊÇutf-8
2.ÔÚÁ¬½ÓÊý¾Ý¿âÑ¡Ôñ±íÖ®ºó£¬²Ù×÷Êý¾Ýǰ£¬Ìí¼ÓÒ»¾ä mysql_query("SET NAMES  'GB2312'");
¸Â¸Â£¬1²»È·¶¨ÊDz»ÊDZØÒªµÄ£¬µ«ÊÇÎÒÈ·¶¨2ÊDZØÒªµÄ£¬ÆäËûµÄ¾ÍÊÇÔÚ±íÖÐÊý¾Ý¾¡Á¿²ÉÓÃutf8.
ÕâÑùÎÊÌâ¾Í½â¾öÀ²£¡
ºÃ£¬Õ¹Ê¾Ï¸öÈËдµÄµÚÒ»¸ö³¬³¬³¬³¬¼òµ¥µÄÁôÑÔ±¾³ÌÐò£¬¸Õѧphp£¬Ã»×ö¸ñʽ¿ØÖÆ£¬´ó¼Ò±ðЦ»°¡£ÕâÊÇ´¿ÊÖдŶ£¡
/*Ê×Ò³¶ÁÈ¡ÁôÑÔÐÅÏ¢µÄ´úÂëindex.php*/
<?php include("include/config.php");?>
<?PHP include("include/head.php");?>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312" />
<title>ÁôÑÔ±¾</title>
</head>
<body>
<p>
  <?php include("include/conn.php");
$q = "SELECT * from lyb";
mysql_query("SET NAMES 'GB2312'");  // ·ÀÖ¹³öÏÖÂÒÂë
?>
  <?
$rs = mysql_query($q, $dbh);
/*Êä³öÊý¾Ý²¢·ÖÐÐ*/
while($row = mysql_fetch_array($rs)) echo "ÐòºÅ$row[id]    ÐÕÃû:$row[name]    qq:$row[qq]    ÄÚÈÝ:$row[content]<br/>";
?>
  <?php include("include/foot.php")?>
</p>
<p><a href="input2.php">дÁôÑÔ</a></p>
/*input2.phpÖÁÓÚΪʲôȡÃûΪ2£¬ÒòΪÉèÖÃÁËÁ½ÖÖдÈëÒ³Ãæ£¬¸Â¸Â*/
<meta http-equiv="Content-Type" content="text/html; charset=gb2312" />
<title>ÁôÑÔ</title>
</head>
<body>
<form method="post" action


Ïà¹ØÎĵµ£º

MySQL¸ßЧÔËÐбر¸£º¼òµ¥µÄ֪ʶ½ÌÄã¸ßЧÔËÓÃË÷Òý

ÔÚÊý¾Ý¿â±íÖУ¬¶Ô×ֶν¨Á¢Ë÷Òý¿ÉÒÔ´ó´óÌá¸ß²éѯËÙ¶È¡£¼ÙÈçÎÒÃÇ´´½¨ÁËÒ»¸ö mytable±í£º
CREATE TABLE mytable(
ID INT NOT NULL,
username VARCHAR(16) NOT NULL
);
ÎÒÃÇËæ»úÏòÀïÃæ²åÈëÁË10000Ìõ¼Ç¼£¬ÆäÖÐÓÐÒ»Ìõ£º5555, admin¡£
ÔÚ²éÕÒusername="admin"µÄ¼Ç¼ SELECT * from mytable WHERE username='admin';ʱ£¬Èç¹ ......

MYSQL³£ÓÃÃüÁ

1¡¢µÇ½MySQL:
mysql -u root -p
2¡¢²é¿´Óû§ÐÅÏ¢
select user,host,password from mysql.user;
select user,host from mysql.user;
3¡¢ÉèÖÃÃÜÂë
set password for root@localhost=password('
ÔÚÕâÀïÌîÈërootÃÜÂë
');
4¡¢ÐÞ¸ÄÃÜÂë
·½·¨1£ºmysqladmin -u root -p password newpassword
·½·¨2£º ££mysql -u root ......

MySQLÖг£ÓõÄÐ޸ıíµÄÃüÁî

MySQLÖг£ÓõÄÐ޸ıíµÄÃüÁî
¹Ø¼ü×Ö: mysql, Ð޸ıí, ÃüÁî
    ÔÚÊý¾Ý¿â²Ù×÷ÖÐ,¸öÈ˾õµÃʹÓõÃ×î¶àµÄ¾ÍÊDzéѯ,È»ºó¾ÍÊǶԱíµÄÐ޸IJÙ×÷ÁË,ÓÈÆäÊǵ±Êý¾Ý¿âµÄÉè¼Æ¹¤×÷ûÓÐ×öºÃʱ.ÏÂÃæ¾ÍMySQLÖÐһЩ³£ÓõÄÐ޸ıíµÄ²Ù×÷½øÐÐ×ܽá:
    ΪÁË·½±ãºóÃæµÄ˵Ã÷,ÏÈ´´½¨Ò»¸ö±í,´´½¨Óï¾äÈçÏÂ:
Create ......

bind+dlz+mysqlʵÏÖÇøÓò¼Ç¼¶¯Ì¬¸üÐÂ


BIND-DLZʵÑé:http://bind-dlz.sourceforge.net/
ʵÑé»·¾³:RHEL4,BIND-9.5.0-P2.tar.gz(9.4.0ÒÔÉϰ汾¶¼ÒѺ¬DLZ²¹¶¡),Mysql-5.0.56.tar.gz
1¡¢°²×°mysql(ÏȰ²×°gccµÈÏà¹ØÈí¼þ°ü)
   #tar zxvf mysql-5.0.56.tar.gz 
   #cd mysql-5.0.56
   #./configure --prefix=/usr/local/my ......

MysqlÖд´½¨Óû§ÕÊ»§µÄ·½·¨

1.CREATE USER
CREATE USER user [IDENTIFIED BY [PASSWORD] 'password']
    [, user [IDENTIFIED BY [PASSWORD] 'password']] ...
CREATE USERÓÃÓÚ´´½¨ÐµÄMySQLÕË»§¡£ÒªÊ¹ÓÃCREATE USER£¬Äú±ØÐëÓµÓÐmysqlÊý¾Ý¿âµÄÈ«¾ÖCREATE USERȨÏÞ£¬»òÓµÓÐINSERTȨÏÞ¡£¶ÔÓÚÿ¸öÕË»§£¬CREATE USER»áÔÚûÓÐȨÏÞµÄmysq ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ