Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2009
    Posts
    14

    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...

  2. #2
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    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 google
    I'd rather be riding on the Tiger 800 or the Norton

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •