Thread: I get an error trying to connect to database:java.sql.SQLException: Access denied for

Greetings!
I get the following error while compiling my java code:
java.sql.SQLException: Access denied for user 'root '@'localhost' (using password: YES)
I have made some research and noticed that this is a common mistake. Unfortunately i didn`t found a solution yet how simply to resolve this matter. I will appreciate any help!

I use a .properties file with the information about the database.
Here is my class:

public static void CreateTable(Connection conn, String url, String driver, String dbName, String userName, String password) {
			try {
				Class.forName(driver).newInstance();
				conn=DriverManager.getConnection(url+dbName, userName, password);
				try {
					Statement st=conn.createStatement();
					String table = "CREATE TABLE Server(name varchar(255), IP varchar(20), OS varchar(255), RAM integer";
			        st.executeUpdate(table);
			        System.out.println("Table successfully created");
				}
				catch(SQLException e){
					System.out.println("Table already exists!");
				}
				conn.close();
			}
			catch(Exception e){
				e.printStackTrace();
			}			
		}

I have made a change
The method CreateTable drops out.
I create the table manually.
Then when i am executinmg this, the samo error appears:

public static void AddInfoDB(Connection conn, String driver, String url, String dbName, String userName, String password, String entered_name, String entered_IP, String entered_OS, int entered_RAM){
			try {
				Class.forName(driver);
				conn = DriverManager.getConnection(url+dbName,userName,password);
				try {
					Statement st = conn.createStatement();
			        int val = st.executeUpdate("INSERT INTO "+dbName+" VALUES("+entered_name+","+entered_IP+","+entered_OS+","+entered_RAM+")");
			        System.out.println("Information added");
				}
				catch(SQLException e){
					System.out.println("SQL statement is not executed!");
				}	
				conn.close();
			}
			catch(Exception e){
				e.printStackTrace();
			}
		}

And the error:

java.sql.SQLException: Access denied for user 'root '@'localhost' (using password: YES)
at com.mysql.jdbc.SQLError.createSQLException(SQLErro r.java:1075)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.ja va:3566)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.ja va:3498)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.ja va:919)
at com.mysql.jdbc.MysqlIO.secureAuth411(MysqlIO.java: 4004)
at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:12 84)
at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(Co nnectionImpl.java:2312)
at com.mysql.jdbc.ConnectionImpl.createNewIO(Connecti onImpl.java:2122)
at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImp l.java:774)
at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connect ion.java:49)
at sun.reflect.NativeConstructorAccessorImpl.newInsta nce0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInsta nce(Unknown Source)
at sun.reflect.DelegatingConstructorAccessorImpl.newI nstance(Unknown Source)
at java.lang.reflect.Constructor.newInstance(Unknown Source)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:40 9)
at com.mysql.jdbc.ConnectionImpl.getInstance(Connecti onImpl.java:375)
at com.mysql.jdbc.NonRegisteringDriver.connect(NonReg isteringDriver.java:289)
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at MainMethods.AddInfoDB(MainMethods.java:31)
at MainProgram.InsertInformation(MainProgram.java:161 )
at MainProgram.MainActions(MainProgram.java:35)
at Server.main(Server.java:84)

the url, driver, dbName, userName, and password are stored in a properties file, i load the values with no problem, while debugging i checked the values and they are just as they are supposed to be