1.java Tip: Java.lang.ClassNotFoundException:com.mysql.jdbc.Driver
Processing: Importing Mysql-connector-java-5.1.7-bin.jar
Import java.sql.Connection;
Import Java.sql.DriverManager;
try{
Connection con = null;
Class.forName ("Com.mysql.jdbc.Driver");
Con=drivermanager.getconnection ("Jdbc:mysql://10.0.1.1/ssworkplat", "root", "1111");
System.out.println ("OK");
}
catch (Exception e) {
E.printstacktrace ();
}
2. Cannot connect to the remote server, message from server: "Host ' 14.119.154.27 ' isn't allowed to connect to this MySQL server
Processing: Database Management
A. All addresses can be logged in
GRANT all privileges on * * to ' myuser ' @ ' percent ' identified by ' MyPassword ' with GRANT OPTION;
FLUSH privileges;
b, Specific IP
GRANT all privileges on * * to ' myuser ' @ ' 192.168.1.188 ' identified by ' MyPassword ' with GRANT OPTION;
FLUSH privileges;
3.Java.sql.SQLException:Access denied for user ' root ' @ ' 14.119.154.27 ' (using Password:yes)
--Password or user error
MySQL Connection error problem