Does the mysql support external connection?

Discussion in 'PHP' started by alanX, May 17, 2006.

0
  1. #1
    Does the mysql(local) support external connection?(connect from other computer)
     
    alanX, May 17, 2006 IP
  2. Colbyt

    Colbyt Notable Member

    Messages:
    3,224
    Likes Received:
    185
    Best Answers:
    0
    Trophy Points:
    210
    #2
    If your host allows it, mysql does as long as the requesting computer has the right usename/password and connection string.
     
    Colbyt, May 18, 2006 IP
  3. TwistMyArm

    TwistMyArm Peon

    Messages:
    931
    Likes Received:
    44
    Best Answers:
    0
    Trophy Points:
    0
    #3
    I'd add to that by also saying 'so long as the MySQL server is accepting connections from non-local hosts', too...
     
    TwistMyArm, May 18, 2006 IP
  4. jimrthy

    jimrthy Guest

    Messages:
    283
    Likes Received:
    13
    Best Answers:
    0
    Trophy Points:
    0
    #4
    I don't remember how fine-grained it gets, but you can control which users can connect from which machines. So that's something else to check
     
    jimrthy, May 18, 2006 IP
  5. MaxPowers

    MaxPowers Well-Known Member

    Messages:
    264
    Likes Received:
    5
    Best Answers:
    1
    Trophy Points:
    120
    #5
    This can be setup through CPanel on the MySQL screen before you go to phpMyAdmin. Pick an IP or a hostname to allow near the bottom of the page.
     
    MaxPowers, May 18, 2006 IP