SitePoint Sponsor

User Tag List

Results 1 to 2 of 2
  1. #1
    SitePoint Member
    Join Date
    Mar 2001
    Location
    Ottawa, Canada
    Posts
    18
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    mysql_real_connect, table alterations needed?

    I have a client program that should connect to a mysql database remotely, but it is not connecting, I have a feeling it is the premissions in the database.

    What do I have to change to the database to allow the new client to access the database?

    thanks,
    brennen

  2. #2
    epsilon transition cupid's Avatar
    Join Date
    Aug 2001
    Location
    Kent, Ohio
    Posts
    367
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Have you added a username and password for this client?
    Also, knowing that you're connecting remotely, is the 'host' field in the 'user' table configured to match the remote client's host?

    On a side note, if you have the '%' wildcard in 'host' for that user, you can connect regardless of what your hostname.. but that can be insecure.


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
  •