使用jsp和mysql的ajax：java.sql.SQLException：拒绝用户'root'@'localhost'（使用password：YES）(ajax with jsp and mysql : java.sql.SQLException: Access denied for user 'root'@'localhost' (using password: YES)) Class.forName("com.mysql.jdbc.Driver"); con = DriverManager.getConnection("jdbc:mysql://localhost:3306/dbname", "root", "root"); st = con.createStatement(); rs = st.executeQuery("SELECT `lastname` FROM `names` WHERE `firstname`='"+first+"' && company like '"+comp+"%'");

其中一个答案说在控制台上运行此命令：

授予所有特权。 TO'root'@'localhost'IDENTIFIED BY'root'WITH GRANT OPTION;

任何人都可以告诉我如何运行基本步骤

我使用xampp服务器和mysql-connector-XXX.jar进行eclipse

Class.forName("com.mysql.jdbc.Driver"); con = DriverManager.getConnection("jdbc:mysql://localhost:3306/dbname", "root", "root"); st = con.createStatement(); rs = st.executeQuery("SELECT `lastname` FROM `names` WHERE `firstname`='"+first+"' && company like '"+comp+"%'");

one of the answers said to run this command on console :

GRANT ALL PRIVILEGES ON . TO 'root'@'localhost' IDENTIFIED BY 'root' WITH GRANT OPTION;

can anyone please tell me how to run it with basic steps

I am using eclipse with xampp server and mysql-connector-XXX.jar

最满意答案

为了在Mac OSX控制台或Windows CMD上运行该命令，首先必须输入：“mysql”才能进入“数据库控制台”，可以这么说。 然后，一旦登录到Mysql，就可以在问题中复制粘贴的粗体线。

In order to run that command on your Mac OSX console or Windows CMD, you first must type in: "mysql" to enter the "console of your database", so to speak. Then you can copy paste that bolded line in your question once you're logged into Mysql.

使用jsp和mysql的ajax：java.sql.SQLException：拒绝用户'root'@'localhost'（使用password：YES）(ajax with jsp and mysql : java.sql.SQLException: Access denied for user 'root'@'localhost' (using password: YES)) Class.forName("com.mysql.jdbc.Driver"); con = DriverManager.getConnection("jdbc:mysql://localhost:3306/dbname", "root", "root"); st = con.createStatement(); rs = st.executeQuery("SELECT `lastname` FROM `names` WHERE `firstname`='"+first+"' && company like '"+comp+"%'");

其中一个答案说在控制台上运行此命令：

授予所有特权。 TO'root'@'localhost'IDENTIFIED BY'root'WITH GRANT OPTION;

任何人都可以告诉我如何运行基本步骤

我使用xampp服务器和mysql-connector-XXX.jar进行eclipse

Class.forName("com.mysql.jdbc.Driver"); con = DriverManager.getConnection("jdbc:mysql://localhost:3306/dbname", "root", "root"); st = con.createStatement(); rs = st.executeQuery("SELECT `lastname` FROM `names` WHERE `firstname`='"+first+"' && company like '"+comp+"%'");

one of the answers said to run this command on console :

GRANT ALL PRIVILEGES ON . TO 'root'@'localhost' IDENTIFIED BY 'root' WITH GRANT OPTION;

can anyone please tell me how to run it with basic steps

I am using eclipse with xampp server and mysql-connector-XXX.jar

最满意答案

为了在Mac OSX控制台或Windows CMD上运行该命令，首先必须输入：“mysql”才能进入“数据库控制台”，可以这么说。 然后，一旦登录到Mysql，就可以在问题中复制粘贴的粗体线。

In order to run that command on your Mac OSX console or Windows CMD, you first must type in: "mysql" to enter the "console of your database", so to speak. Then you can copy paste that bolded line in your question once you're logged into Mysql.