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 ÊÔÊÔ¿´£¬ÔÙÓÃÅųý·¨Ò»²½²½ÂýÂ
Ïà¹ØÎÊ´ð£º
import java.sql.Connection;
import java.sql.Date;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
public class QueryTest&n ......
ÎÒÔÚ javaºËÐļ¼ÊõÉÏ ¿´ÁËÒ»¸ö ÀûÓà Java socket emailµÄÀý×Ó ¿ÉÊÇÔõôҲ ²»³É¹¦ Ϊʲô£¿
Ô´Âë
Java code:
package cn.com.test.email;
import java.awt.GridBagLayout;
import java.awt.event.Action ......
org.apache.jasper.JasperException: Unable to compile class for JSP:
An error occurred at line: 52 in the jsp file: /vip_info.jsp
ÕË cannot be resolved
49: <table border="1& ......
ÒªÇó£º
1¡¢¾ßÓÐ2ÄêÒÔÉϵÄjava¿ª·¢¹¤×÷¾Ñ飬¾«Í¨java£»
2¡¢ÊìϤEclipse¿ª·¢¹¤¾ß£¬ÊìϤWEB¿ª·¢£¬¾ßÓÐÁ½ÄêÒÔÉÏJava¿ª·¢¾Ñ飬կÎÕÃæÏò¶ÔÏóµÄÈí¼þÉè¼Æ·½·¨£¬
ÓÐSpring¡¢HibernateÒÔ¼° ......