Thread: cannot establish a connection
02-06-10, 01:17 #1Registered User
- Join Date
- Nov 2009
Unanswered: cannot establish a connection
I cannot establish a connection using com.mysql.jdbc.driver
I'm using MySql server 5.0 and mysql-connector-java-5.1.7 driver for the connection. But whenever I'm trying to establish connection to the server using the above driver through NetBeans IDE 5.5.1 I'm getting the following message
"Unable to add connection,cannot establish a connection to jdbc:mysql://localhost:3306/mydatabase using com.mysql.jdbc.Driver(Access denied for user '@localhost'(using password:NO))"
Plz. provide me the solution...
02-06-10, 02:49 #2Jaded Developer
Provided Answers: 59
- Join Date
- Nov 2004
- out on a limb
so can you connect to MySQL using another application, such as MSQL Admin or MySQL Query Browser (both part of the MySQL GUI Tools available from the MySQL site)
of can you connect to MySQL from another application say PHPMyAdmin or one of the other tools such as HeidiSQL?
I suspect you have a permissions problems, either the userid you are connecting with has no permissions or the permissions are wrongly set. although you can GRANT the permissions using the MyQL command line, persoanlly I find it a lot easier to use MySQLAdmin to do that. its also clearer to see what permissions have been GRANTED and to whom.
if you do use the command line to set permissions then make certain you FLUSH PRIVILEGES after making any changes
as usual details of permissions can be found in da manuel or on googleI'd rather be riding on the Tiger 800 or the Norton