Mysql5.1 for PHP
×¼±¸£ºÏÂÔØMysql5.1<mysql-essential-5.1.41-win32.msi>
°²×°£ºstep by step
²âÊÔ£º1.MySQL²âÊÔ
µã¿ªMySQL Command Line Client, ÊäÈ밲װʱ½¨Á¢µÄÃÜÂë¡£
mysql>show databases;
mysql>use <<database name>>;
mysql>show tables;
mysql>select * from <<table name>>;
2.PHP²âÊÔ
½¨Á¢php²âÊÔÒ³db.php
<?php
mysql_connect('localhost','<<user name>>','<<password>>') or die(mysql_error());
mysql_select_db("<<database name>>");
$query='select now()';
$conn=mysql_query($query) or die (mysql_error());
echo "QUERY: $query<br>";
$res=mysql_fetch_array($conn);
echo $res[0];
?>
Ïà¹ØÎĵµ£º
MySQLĬÈÏûÓÐÃÜÂ룬°²×°Íê±ÏÔö¼ÓÃÜÂëµÄÖØÒªÐÔÊDz»ÑÔ¶øÓ÷µÄ¡£
£¨1£©ÃüÁî
/usr/bin/mysqladmin -u root –p ‘old-password’ password 'new-password'
¸ñʽ£ºmysqladmin -uÓû§Ãû -p¾ÉÃÜÂë password ÐÂÃÜÂë
£ ......
ÎÊÌ⣺һ¿ªÊ¼ÎÒÓÃNavicat Lite for mysql ½«Êý¾Ý¿âת´æ´¢Î»sqlÎļþ¡£´ò¿ªÖ®ºó·¢ÏÖ£¬ÖÐÎĶ¼±ä³ÉÁËÂÒÂë¡£
ËùÒÔ ÔÚÍøÉÏËÑË÷ÁËЩ×ÊÁÏ¿´¿´¡£·¢¾õ´ó¼Ò¶¼ÊÇÓÃÃüÁîµ¼³öµÄ¡£ÓÃÁËÖ®ºó£¬ÖÐÎľͲ»ÂÒÂëÁË¡£½â¾öÁËÎÒµÄÒ»¸öÄÑÌâ¡£Ìش˼ÇÏ¡£
·½·¨:
Ê×ÏÈÈ·ÈÏ mysql·þÎñÊÇ¿ªÆôµÄ¡£
È»ºóµã“¿ªÊ¼”ÔËÐÐÊäÈëcmd£¬½øÈëDOS»·¾³¡£cd ......
Ò»¡¢Êý×ÖÀàÐÍ
ËùνµÄ“Êý×ÖÀà”£¬¾ÍÊÇÖ¸ DECIMAL ºÍ
NUMERIC£¬ËüÃÇÊÇͬһÖÖÀàÐÍ¡£ËüÑϸñµÄ˵²»ÊÇÒ»ÖÖÊý×ÖÀàÐÍ£¬ÒòΪËûÃÇʵ¼ÊÉÏÊǽ«Êý×ÖÒÔ×Ö·û´®ÐÎʽ±£´æµÄ£»ËûµÄÖµµÄÿһ루°üÀ¨Ð¡Êýµã£©Õ¼Ò»¸ö×ֽڵĴ洢¿Õ¼ä£¬Òò´ËÕâÖÖÀàÐͺķѿռä±È½Ï´ó¡£µ«ÊÇËüµÄÒ»¸öÍ»³öµÄÓŵãÊÇСÊýµÄλÊý¹Ì¶¨£¬ÔÚÔËËãÖв»»á“ʧ ......
¡¡¡¡1006£ºMYSQL ´´½¨Êý¾Ý¿âʧ°Ü ......