ÇëÎÊΪʲôÎÒµÄmysqlÓÐÁ½¸öµØ·½ÉèÖö˿Ú
ÒÔÏÂÊÇÎÒÅäÖÃÎļþÀïÃæµÄÄÚÈÝ£¬ÎҸоõºÃÏñÖØ¸´ÁË£¬ÕâÀïclient mysqldÊDz»ÊÇ×¢ÊÍ£¬ÁíÍâportΪʲôÐèÒªÉèÖÃÁ½±ß£¬ÉèÖÃÒ»¸öÓÐʲôӰÏìÄØ£¬Ð»Ð»´ó¼Ò
[client]
port=3306
[mysqld]
# The TCP/IP Port the MySQL Server will listen on
port=3306
Ò»¸öÊÇ[client] µÄ£¬Äã¿ÉÒÔ²»ÅäÖá£Õâ¸öÊÇmysql.exe¹¤¾ßµÄ²ÎÊýÅäÖá£ÄãÔÚÖ´ÐÐmysql -uroot -p123 µÄʱºòÒ»°ãÊÇûÓÐÖ¸¶¨PORTºÅµÄ£¬´Ëʱ¾ÍÒÔÕâ¸öΪ׼¡£
ÁíÒ»¸öÊÇ[mysqld]µÄ£¬Õâ¸öÊÇMYSQLÊý¾Ý¿â·þÎñµÄ£¬ÊÇMYSQLDÆô¶¯Ê±µÄ²ÎÊý£¬Èç¹û²»ÔÚÃüÁîÐÐÖ¸¶¨£¬ÔòMYSQLD»áÒÔÕâ¸ö½ÚÖеIJÎÊýÉèÖÃΪ׼¡£
лл£¬ÇëÎÊÎÒÄÜͨ¹ýʲôÃüÁî¿ÉÒÔ²éѯµ½ÕâЩÅäÖÃÄØ£¬Ð»Ð»
show variables ;
°ïÖúÊÖ²áÖвéÒ»ÏÂÕâ¸öÃüÁî¡£
MySQL¹Ù·½Îĵµ http://dev.mysql.com/doc/refman/5.1/zh/index.html
¸ú½ø£¬Ñ§Ï°ÁË
show variables like '%port%'
Ïà¹ØÎÊ´ð£º
ÎÒÊÇÓÃmysql×Ô´øµÄC API
if(mysql_real_connect(&mysql,"125.0.0.108","root","root","home",3306,NULL,0))
{
AfxMessageBox("Êý¾Ý¿âÁ¬½Óʧ°Ü") ......
ÎÒÓõÄÊÇÁ¬½Ó³Ø×öµÄ£¬ÅäÁ¬½Ó³ØµÄ·½·¨Ó¦¸ÃûÓÐ´í£¬ÎªÊ²¾ÍÊdzöÏÖÕâÖÖÎÊÌâ
javax.servlet.ServletException: javax.naming.NameNotFoundException: No object bound to name java:comp/env/test
ÇëÎÊ´óÏÀÃÇÕâÊÇÔ ......
ÔÚC++³ÌÐòÖÐͨ¹ýmysqlµÄC APIÖ±½ÓÁ¬½ÓÊý¾Ý¿â£¬µ±°ÑÖÐÎIJåÈëmysqlµÄʱºò£¬¾Í±ä³ÉÂÒÂëÁË.
»¹ÓоÍÊÇʹÓÃload°ÑÎı¾Îļþµ¼ÈëmysqlÊý¾Ý¿â£¬ÎÞÂÛÎı¾ÎļþÊÇANSI±àÂ뻹ÊÇutf8±àÂ룬µ¼ÈëÖ®ºó¶¼ÊÇÂÒÂë¡£
ÆäÖÐmysqµÄ±àÂë¸ñʽ ......
PHPCMSÆóÒµ»ÆÒ³2008·ÖÒ³ÎÊÌâ
ÎÒÓÃÒÔÏ·½Ê½Ç󯽾ùÊý
{get sql="SELECT DISTINCT c.*,
(select round(avg(sort1)) from `phpcms_yp_dp` where userid=c.userid) avgsort1,
(select round(avg(avgp ......