无法从其他pc机的phpmyadmin（wamp）的mysql数据库中检索enteries

Question

/*

null

/*****@作者用户*/public class Wamp{

/**
 * @param args the command line arguments
 */

    // TODO code application logic here
    public static void main(String args[]) throws InstantiationException, IllegalAccessException
{
    try{
        Class.forName("com.mysql.jdbc.Driver").newInstance();
             Connection con = DriverManager.getConnection("jdbc:mysql://192.168.1.2:3306/test","root",""); 
                Statement stmt=con.createStatement();
              // stmt.executeUpdate("Insert into student values(1,'abc','nagpur')");
                ResultSet rs= stmt.executeQuery("Select names from sample where id=15");
                rs.next();
               String name= rs.getString("names");               
                System.out.println(name);
                System.out.println("DOne..");
               //INSERT INTO `student`(`id`, `name`, `address`) VALUES (1,'amol','nagpur');
            con.close();

          }
catch(ClassNotFoundException | SQLException e){
    System.out.println("error"+e);
}

}

}

以下是错误消息：

errorjava.sql.SQLException: null, message from server: "Host 'user-PC.Home' is not allowed to connect to this MySQL server

Answer 1

这是因为你没有给你的其他电脑正确的权限来连接MySQL数据库，如果你在谷歌上搜索错误，你会找到答案：

首先ping user-PC以获得他的IP地址：

Ping user-PC

然后登录到MySQL数据库并给出

use mysql
GRANT ALL ON *.* to root@'user-PC' IDENTIFIED BY 'your-root-password';
FLUSH PRIVILEGES;