Clarification about accessing database from other workstation

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • sukatoa
    Contributor
    • Nov 2007
    • 539

    Clarification about accessing database from other workstation

    I doubt if this is the right section to post...

    But, for a clarification

    I always use "jdbc:mysql ://localhost:3306/dbname" to access the mysql database server given also the username and the password

    But, i would like to access that db server from another workstation,
    I replace "localhost" to an ip address and added a grant privileges before accessing.... and i cant...

    I can't trace what's lacking with the setup...
    OS: Ubuntu

    I need help, could somebody here?
  • Atli
    Recognized Expert Expert
    • Nov 2006
    • 5062

    #2
    Hey.

    MySQL servers on Ubuntu are, by default, set to ignore all connections other than those from localhost.

    To fix this you need to alter the bind-address directive in the my.cnf file.
    See Ubuntu Server Guide > Databases > MySQL

    Comment

    • sukatoa
      Contributor
      • Nov 2007
      • 539

      #3
      Hey.

      MySQL servers on Ubuntu are, by default, set to ignore all connections other than those from localhost.

      To fix this you need to alter the bind-address directive in the my.cnf file.
      See Ubuntu Server Guide > Databases > MySQL
      Thank you for your reply Atli, i guess that is what i am looking for :)

      Comment

      Working...