呵呵,
这是因为在你的 mysql.user 表中的用户信息是这样的+------------+----------+-------------
| Host | User | Password
+------------+----------+-------------
| localhost | root |
+------------+----------+-------------
这是因为在你的 mysql.user 表中的用户信息是这样的+------------+----------+-------------
| Host | User | Password
+------------+----------+-------------
| localhost | root |
+------------+----------+-------------
> mysqld-nt --defaults-file=c:/my.cnfok!
import org.gjt.mm.mysql.*;public class DBConnect {
java.sql.Connection cnn = null;
java.sql.Statement st = null;
java.sql.ResultSet rs = null;
String mysqldriver = "org.gjt.mm.mysql.Driver"; String sql = "select * from wd";
String result = "";
public DBConnect(){
System.out.println("Initial Database Driver");
try{
Class.forName("org.gjt.mm.mysql.Driver");
}catch(ClassNotFoundException e){System.out.println(e.toString());}
try{
System.out.println("Start Connection...");
cnn = DriverManager.getConnection("jdbc:mysql://192.168.1.24:3306/test","root","asd");//<=====Here it comes
System.out.println("Creating Statement...");
st = cnn.createStatement();
System.out.println("Getting Result...");
rs = st.executeQuery(sql);
result = rs.getString(1) + " " + rs.getString(2);
st.executeUpdate(sql2);
st.executeUpdate("use ss");
}catch(SQLException e){System.out.println(e.toString());}
}
public String toString()
{
return result;
}
public static void main(String arg[])
{
DBConnect mycon = new DBConnect();
System.out.println("Starting...");
System.out.println(mycon.toString());
}
}
root是有了所有的权限,密码也是对的。可是联接的时候,总提示access denied for user: root@***(我机子的名称) (Using password: YES)
| Host | User | Password
+------------------+------------------+--------------------
| ***(我机子的名称)| root | ***(password('asd'))
+------------------+------------------+--------------------
先用
mysqladmin -u root -p "newpassword_for_root"
这样先这个密码为root