Results 1 to 2 of 2
  1. #1
    mransome is offline Member
    Join Date
    Aug 2007
    Posts
    2
    Rep Power
    0

    Question DriverManger.getConnection

    I am trying to connect to a MySQL DB on a linux server from a Java App on a win32 pc. I suspect I am not writing the url properly.

    here is the code:

    Connection con = DriverManager.getConnection("jdbc:mysql://paptais07:3306/test" , "root", "");

    here is the error:

    java.sql.SQLException: Access denied for user 'root'@'pc5033.petrotrin.com' (using password: NO)

    pc5033 is my pc and petrotrin is the domain it is in.

    any help will be much appreciated.

  2. #2
    shanePreater is offline Member
    Join Date
    Jul 2007
    Location
    England, Bath
    Posts
    47
    Rep Power
    0

    Default

    Your problem is the user credentials that your passing.
    Have you setup the root user without a password and set the host to any (*)?
    Normally with a default install of MySQL you specify a root password and by default only local connections can use the root account.
    Check out The main MySQL section
    Also this guide on devshed might help.

    That should get you moving again.
    Shane.

Posting Permissions

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