mysqlÃüÁîÐзDZê×¼¶Ë¿ÚÔõôÁ¬½Ó£¿
mysql -u root -p
×ÜÊÇÌáʾAccess denied
mysql -u root -p -P3306
¸øÄã¸öÀý×Ó£º
mysql -h192.168.1.5 -P3306 -uroot -p123456
·Ö±ðÊÇ-h ÒªÁ¬½ÓµÄÖ÷»úIP£»
-P £¨´óд£©¶Ë¿Ú£»
-u Óû§Ãû£»
-p £¨Ð¡Ð´£©ÃÜÂë¡£
-P, --port=# Port number to use for connection or 0 for default to, in
order of preference, my.cnf, $MYSQL_TCP_PORT,
/etc/services, built-in default (3306).
C:\>mysql -h 192.168.20.107 -P 3770 -u myusername -p
Ïà¹ØÎÊ´ð£º
±àÒëÆ÷£ºC-Free4
mysql µ¥¶À°²×°µÄ£¬ÏÖÔÚΪapache+php+mysql¿ÉÒÔʹÓá£
×î½üÔÚÁ·Ï°c£¬c++£»ÏëÓÃc£¬c++Á¬½ÓÏÂÎÒµÄmysql£¬ºÃ¶àµØ·½¶à˵mysql.hÕÒ²»µ½¡£¶øÇÒÎÒmysqlûÓÐËùνµÄincludeÎļþ¼Ð°¡¡£
Íü¸ßÊÖÖ¸µãÒ»¶ ......
ÎÒµÄmysqlÔõôûÓа취дÈëÖÐÎÄÊý¾Ý£¿Ö»ÒªÊÇÊý¾ÝдÈëÊý¾Ý¿âʱ ¾Í»á±ä³ÉÈý¸öÎʺŠ£¿Çë½Ì¸ßÈË£¡£¡
linux? ÔõôдÈëµÄ
ÔÚmysqlÖÐÖ´ÐÐ show variables like 'character%'Ìù½á¹û³öÀ´¡£
ÔÚ°²×°MYSLQʱ½«Êý¾Ý¿âµÄ×Ö· ......
id INT NOT NULL PRIMARY KEY AUTO_INCREMENT
È»ºóɾ³ýÊý¾Ý¿âÖеÄÈô¸ÉÖØ¸´¼Ç¼ºóID±äµÄ²»Á¬Ðø£¬ÈçºÎ±äµÃÁ¬Ðø£¿£¿
ÔËÐÐ
ALTER TABLE tablename DROP id;
ALTER TABLE tablename ADD id INT NOT NULL PRIMARY KEY ......
¸Õ¸Õ½Ó´¥MySQL,²»ÖªµÀ¸ÃÈçºÎÈ¥²é¿´Êý¾Ý£¬²åÈëÊý¾Ý£¬´´½¨Êý¾Ý¿â¡¢±í£¬ÓÃÄÄΪǰ±²ÄÜÖ¸½ÌÒ»¶þ£¿
MySQL 5.1²Î¿¼ÊÖ²á
ÒýÓÃ
ÐÖµÜÄã»á½áÌùÂð£¿
mysql ²Î¿¼ÊÖ²á
baidu
MySQL¹Ù·½Îĵµ http://dev.mysql.com/doc ......
iocpͬmysql´¦ÀíÊý¾Ý ¾ä±úÒ»Ö±Ôö¼Ó
·ÖÏí ³ÌÐòÔ±Ö®¼Ò£¨www.phome.asia£©¼¼Êõ¹Ù·½Èº£¬Ï£ÍûÓÐ־֮ʿµÄ¼ÓÈëŶ~~ºÙºÙ£¡
javaȺ£º
javaÐÂÊÖȺ£º 19976477
javaÐÂÊÖȺ2£º61983722
......