Mysql Help !

Discussion in 'Programming' started by MeetHere, Jan 30, 2007.

  1. #1
    Can I know how to call a mysql database from a different web host?

    I mean other than localhost ?
     
    MeetHere, Jan 30, 2007 IP
  2. oziman

    oziman Active Member

    Messages:
    199
    Likes Received:
    6
    Best Answers:
    0
    Trophy Points:
    58
    #2
    Assuming the mysql database is enabled to accept users from remote hosts, yes.
     
    oziman, Jan 30, 2007 IP
  3. MeetHere

    MeetHere Prominent Member

    Messages:
    15,399
    Likes Received:
    994
    Best Answers:
    0
    Trophy Points:
    330
    #3
    But how to do that?
    Whether I have to add my domain name in Database server field.
    This wont help :(
     
    MeetHere, Jan 30, 2007 IP
  4. linkstraffic

    linkstraffic Well-Known Member

    Messages:
    388
    Likes Received:
    10
    Best Answers:
    0
    Trophy Points:
    133
    #4
    You should authorize access from the mysql server to your remote server; for instance:
    > grant all privileges on yourbase.* to 'user'@'remoteserver' identified by 'somepass' with grant option
    Code (markup):
     
    linkstraffic, Jan 30, 2007 IP
  5. MeetHere

    MeetHere Prominent Member

    Messages:
    15,399
    Likes Received:
    994
    Best Answers:
    0
    Trophy Points:
    330
    #5
    I asked my server, they told they donot provide remote mysql support :(
     
    MeetHere, Jan 30, 2007 IP