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
Ïà¹ØÎÊ´ð£º
ÎÒÊÇÐÂÊÖ£¬³õѧMYSQL£¬Óкܶ಻¶®£¬Íû´Í½Ì£¡£¡
±ÈÈç˵ÎÒн¨Ò»¸öMYSQLÊý¾Ý¿âUSER Êý¾Ý¿âÖÐÓбíLIST
È»ºóÎÒÔÚVCÖÐн¨Ò»¸öMFC¶Ô»°¿ò¹¤³Ì£¬È»ºóÎÒÔõôÑù²ÅÄÜÓÃVC»ñµÃÊý¾Ý¿âÖбíµÄÊý¾Ý£¿
Ï£Íû¸ø³ö¾ßÌåµÄ²Ù×÷² ......
ÏÈÉÏ´íÎó
ÎÞ·¨Áª½ÓÊý¾Ý¿â
java.sql.SQLException: Before start of result set
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:910)
at com.mysql.jdbc.ResultSet.checkRowPos(ResultSet.java: ......
CREATE DATABASE ADDRESSLIST;
USE ADDRESSLIST;
DROP TABLE IF EXISTS FRIEND;
CREATE TABLE FRIEND
(FRIEND_ID INTEGER NOT NULL AUTO_INCREMENT PRIMARY KEY ,
FRIEND_NAME VARCHAR(20) NOT N ......
ÔÚC++³ÌÐòÖÐͨ¹ýmysqlµÄC APIÖ±½ÓÁ¬½ÓÊý¾Ý¿â£¬µ±°ÑÖÐÎIJåÈëmysqlµÄʱºò£¬¾Í±ä³ÉÂÒÂëÁË.
»¹ÓоÍÊÇʹÓÃload°ÑÎı¾Îļþµ¼ÈëmysqlÊý¾Ý¿â£¬ÎÞÂÛÎı¾ÎļþÊÇANSI±àÂ뻹ÊÇutf8±àÂ룬µ¼ÈëÖ®ºó¶¼ÊÇÂÒÂë¡£
ÆäÖÐmysqµÄ±àÂë¸ñʽ ......
iocpͬmysql´¦ÀíÊý¾Ý ¾ä±úÒ»Ö±Ôö¼Ó
·ÖÏí ³ÌÐòÔ±Ö®¼Ò£¨www.phome.asia£©¼¼Êõ¹Ù·½Èº£¬Ï£ÍûÓÐ־֮ʿµÄ¼ÓÈëŶ~~ºÙºÙ£¡
javaȺ£º
javaÐÂÊÖȺ£º 19976477
javaÐÂÊÖȺ2£º61983722
......