Access denied for user ‘root’@’localhost’

by

Start mysql client in the console and execute this query: select Host, User from mysql.user;. You MUST have a row like this:

+----------------+------------------+  
| Host           | User             |  
+----------------+------------------+  
| localhost      | root             |
+----------------+------------------+

a row with “localhost” in Host and “root” in User. If you don’t have it that’s the cause of your problem (it doesn’t matter if you have other rows with “root” in User)

If you don’t have such row, add a new user with this:

CREATE USER 'appUser'@'localhost' IDENTIFIED BY 'appPassword';

Change ‘appUser’ by ‘root’ if you want, but I strongly suggest to use another user. Then add permissions to your new user by executing this in the mysql client:

GRANT ALL PRIVILEGES ON employees.* TO 'appUser'@'localhost';

(again, change ‘appUser’ by ‘root’ if you want)

More Related Contents:

  1. SQL syntax error in "insert into 'keys'(a,b,c,d,e) values(?,?,?,?,?)" [closed]
  2. Hours and seconds are lost when storing a date in the database [closed]
  3. Multiple queries executed in java in single statement
  4. Java: Insert multiple rows into MySQL with PreparedStatement
  5. ClassCastException: java.math.BigInteger cannot be cast to java.lang.Long on connect to MySQL
  6. Handling MySQL datetimes and timestamps in Java
  7. Closing JDBC Connections in Pool
  8. No suitable driver found for ‘jdbc:mysql://localhost:3306/mysql [duplicate]
  9. com.mysql.jdbc.exceptions.jdbc4.CommunicationsException:Communications link failure [duplicate]
  10. “Loading class com.mysql.jdbc.Driver … is deprecated” message
  11. Returning a ResultSet
  12. How to change MySQL timezone in a database connection using Java?
  13. How to configure Tomcat to connect with MySQL
  14. Retrieve an Image stored as BLOB on a MYSQL DB
  15. Can I execute multiple queries separated by semicolon with MySQL Connector/J? [duplicate]
  16. runtime error: java.lang.ClassNotFoundException: com.mysql.jdbc.Driver
  17. mysql prepared statement error: MySQLSyntaxErrorException
  18. ‘0000-00-00 00:00:00’ can not be represented as java.sql.Timestamp error
  19. SQL Error: 0, SQLState: 08S01 Communications link failure [duplicate]
  20. MySQL connector error “The server time zone value Central European Time” [duplicate]
  21. How to correctly write UTF-8 strings into MySQL through JDBC interface
  22. Glassfish Admin Console throws java.lang.IllegalStateException when creating JDBC Pool
  23. java.sql.SQLException: Before start of result set [duplicate]
  24. How to use prepared statement for select query in Java?
  25. Stumped SQL Exception for JDBC
  26. A datetime equivalent in java.sql ? (is there a java.sql.datetime ?)
  27. Performance of MySQL Insert statements in Java: Batch mode prepared statements vs single insert with multiple values
  28. A persistent connection with JDBC to MySQL
  29. JDBC MySQL connection using Unix Socket
  30. JDBC connection error : unrecognized timezone [duplicate]

Leave a Comment