java Á¬½ÓmysqlÒì³££¬ ÇëÎÊÔÒò¡£
Class.forName("com.mysql.jdbc.Driver").newInstance();
conn = DriverManager.getConnection("jdbc:mysql://db.153.com/test","root","bcmedia");
Òì³£·¢ÉúÔÚÕâÒ»¾ä£¬·µ»ØÒì³££º java.sql.SQLException: null, message from server: "#HY000Host '172.16.16.55' is not allowed to connect to this mysql server"
'172.16.16.55' ÊÇÎÒ±¾»úIP. ʲôÔÒò£¿
Ô¶³ÌÁ¬½Ómysql³öµÄ´íÎó°É
ÔÒòÊÇÄãµÄÕʺŲ»ÔÊÐí´ÓÔ¶³ÌµÇ½£¬Ö»ÄÜÔÚlocalhostÖеǼ¡£´ËʱֻҪÔÚ localhostµÄÄÇ̨µçÄÔ£¬µÇÈëmysqlºó£¬¸ü¸Ä "mysql" Êý¾Ý¿âÀïµÄ "user" ±íÀïµÄ "host" Ï´Ó"localhost"¸Ä³Æ"%"£¨unixΪÀý£©
mysql -u root -pvmwaremysql>use mysql;
mysql>update user set host = '%' where user = 'root';
mysql>select host, user from user;
linuxÏÂÊÇ·ñºÍunixÒ»Ñù£¿
°ï¶¥..............
Ò»Ñù ÕÕÉÏÃæ²Ù×÷ÊÔÊÔ¿´
ÎÊÌâÒÀÈ»´æÔÚ£¬ÇëÎÊ»¹ÓÐûÓÐÆäËûÔÒò£¿
java.sql.SQLException: null, message from server: "#HY000Host '172.16.16.55' is not allowed to connect to this mysql server"
˵Ã÷ÄãµÄ±¾»úûÓÐȨÏÞÁ¬½Óµ½db.153.com/test
db.153.comÕâÊÇÒ»¸öʲôµØÖ·£¿ ÇëÎÊLZµÃµ½ÊÚȨÁËô£¿
Èç¹ûÊÇÄã±¾»úµÄ»°×îºÃÓÃ127.0.0.1
ÄãÊÔÊÔ
Ó¦¸ÃÊÇȨÏÞÎÊÌâ
ÄãºÃ£¬Â¥Ö÷£¡
Õâ¿Ï¶¨ÊÇÊý¾Ý¿â·ÃÎÊȨÏÞµÄÎÊÌâ¡£
ÊDz»ÊÇÔÚ×°MySql µÄʱºò£¬Ã»ÓÐÉèÖÃMySql µÄ·þÎñ¶ËŶ£¬µ¼ÖÂÎÞ·¨Á¬½Ó¡£
ÄãÏÈÓÃlocalhost ÊÔÊÔ¿´£¬ÔÙÓÃÅųý·¨Ò»²½²½ÂýÂ
Ïà¹ØÎÊ´ð£º
±¾ÈËÕýÔÚÓÃJava×öÒ»¸öC/S¼Ü¹¹µÄÏîÄ¿£¬
¿ÉÊÇÓÉÓÚÏîÄ¿±È½Ï´ó£¬Ç°ÆÚ¶Ô¼Ü¹¹µÄÉè¼ÆÓÈÆäÖØÒª£¬ÒòΪºóÆÚ¿ÉÄÜËæÊ±»á¼Ó¸ö¹¦ÄÜ»òÕßÈ¥µôijЩ¹¦ÄÜ¡£
ËùÒÔÌØµØÑ°ÇóÈçºÎÉè¼ÆC/SµÄ¼Ü¹¹Ê¹³ÌÐò¸ü¼ÓÃæÏò¶ÔÏó¸ü¼ÓÒ×ÓÚά ......
ÎÒJSPµÄÒ³ÃæÊÇ£º
<%@ page language="java" contentType="text/html; charset=gb2312"
%>
<script>
function Save(){
xmlHttp=GetXmlHttpObject()
if(xmlHttp==nul ......
ÇëÎÒÓÃFCKÉÏ´«Îļþ,ÔÚ±¾µØµÄwindows»úÉϲâÊÔ¿ÉÒÔ£¬µ«²¿Êðµ½linux·þÎñÆ÷ÉϾÍÉÏ´«²»ÁËÎļþ£¬ÉÏ´«Îļþʱһֱ¿¨ÔÚÄÇÀï¡£Íû¸÷λ´óϺָµã£¬Ð»Ð»£¡
·¹ý£¬°ïÄ㶥һϡ£¡£¡£¡£¡£¡£¡£¡£¡£¡£¡£¡£¡£¡£
ÉÏ´«ÎļþµÄ·¾¶ÎÊÌ⣬ ......
ÌâÄ¿£º
ÓÐ1,2,3£¬4,5,6Áù¸öÊý×ÖÅÅÐò£¬ÓÃjava³ÌÐò¼ÆËã³öÅÅÐòµÄÖÖÀà¡£
ÒªÇó£ºÒ»£¬ÒÔ4¿ªÍ·
¶þ£¬2,3²»ÄÜÏàÁÚ
Èý£¬²»ÄÜÒÔ5¿ªÍ·
Ï£Íû´ó¼ÒÄܼ´ ......