Closed Thread
Results 1 to 3 of 3

Thread: Mysql remote connection

  1. #1
    Crane's Avatar
    Crane is offline Programming Expert
    Join Date
    Nov 2005
    Posts
    398
    Rep Power
    25

    Mysql remote connection

    While connecting to a mysql connection on another server I get an access denied error. I've made sure that the user can actually login from the localhost and can access the tables. Why would I get this error?

  2. CODECALL Circuit advertisement
    Join Date
    Always
    Posts
    Many

     
  3. #2
    Crane's Avatar
    Crane is offline Programming Expert
    Join Date
    Nov 2005
    Posts
    398
    Rep Power
    25
    Figured this out - (this is actually the project that went sour in C# forum)

    I had to grant access to the user from my IP address.

  4. #3
    Crane's Avatar
    Crane is offline Programming Expert
    Join Date
    Nov 2005
    Posts
    398
    Rep Power
    25
    This is how:

    GRANT ALL PRIVILEGES ON *.* TO USERNAME@IP IDENTIFIED BY "PASSWORD";
    FLUSH PRIVILEGES;
    exit;

Closed Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. OJDBC - Remote host closed connection during handshake
    By gregwarner in forum Database & Database Programming
    Replies: 2
    Last Post: 06-27-2011, 06:18 AM
  2. MySQL Connection
    By Bioshox in forum PHP Development
    Replies: 6
    Last Post: 04-20-2010, 02:17 PM
  3. mysql connection example
    By genux in forum C Tutorials
    Replies: 2
    Last Post: 04-14-2010, 05:35 PM
  4. MySql Connection Help
    By so1i in forum Visual Basic Programming
    Replies: 7
    Last Post: 10-27-2009, 06:10 AM
  5. MySql connection as IM protocol?
    By ArekBulski in forum Database & Database Programming
    Replies: 7
    Last Post: 09-06-2009, 07:14 PM

Tags for this Thread

Bookmarks

Posting Permissions

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