Hello!

I'm a little confused..I have a Mysql-server and running a JSP-solution.
It works perfectly when it runs locally but when I export my JSP+Msql application to my webhotel nothing is working, I get this error.

-------------------ERROR------------------------------
java.sql.SQLException: Invalid authorization specification, message from server: "Access denied for user: 'bla1@localhost' (Using password: YES)
---------------------------------------------------------

My mysql setup for the moment is:
Mysqlserver:
username: root
passw:"" (blank)

My database
username: bla1
passw: bla2

When I connect to my database I use this information:

String fileURL = "jdbc:mysql://myurltowebhost/division?user=" + username + "&password=" + passw;¨

Connection con2 = DriverManager.getConnection(fileURL, "", "");

In " DriverManager.getConnection(fileURL, "", "")" there should be sent password and username "(fileURL, "usernameX", "passwordX")" ... which one should be send... database?mysqlserver?

Thanks in advance // D_S

You need to use the log in name that is associated to the specific database if you are only limiting that one user to that one database.

You should also have a password for root.

Right now the error message below is saying you are using the wrong password for that user.