The Community Forums

Interact with an entire community of cPanel & WHM users!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Delphi & MySQL

Discussion in 'General Discussion' started by BeNE.WS, Apr 23, 2005.

  1. BeNE.WS

    BeNE.WS Well-Known Member

    Joined:
    May 14, 2003
    Messages:
    49
    Likes Received:
    0
    Trophy Points:
    6
    Location:
    Belgium
    Hi,

    We have a customer who wants to make a Delphi application.

    From this application he wants to connect to a MySQL database on our server.

    What do I have to do to enable this on our server.

    Thanks,

    Steven
     
  2. xbill

    xbill Member

    Joined:
    May 4, 2005
    Messages:
    5
    Likes Received:
    0
    Trophy Points:
    1
    You have to grant access from any host to the user that connects to MySQL.
     
  3. BeNE.WS

    BeNE.WS Well-Known Member

    Joined:
    May 14, 2003
    Messages:
    49
    Likes Received:
    0
    Trophy Points:
    6
    Location:
    Belgium
    And ... How do I do that ??

    Thanks,

    Steven
     
  4. Kaveyhosting

    Kaveyhosting Well-Known Member

    Joined:
    Apr 20, 2005
    Messages:
    53
    Likes Received:
    0
    Trophy Points:
    6
    Go to PHPmyadmin as root
    click on priveleges
    click on the first letter of the user you want to grant access
    click the edit symbol to the right of the users name
    find where it says host and make sure the box on the left says any host
    above go make sure the radio button is set to delete old user and reload priveleges
    click go
    tada... you have fixed it
     
  5. Wallaby

    Wallaby Well-Known Member

    Joined:
    Aug 15, 2001
    Messages:
    131
    Likes Received:
    1
    Trophy Points:
    18
    The other thing to check is that his Delphi application will talk to the version of MySQL that you have on your (presumably Linux) server. Depending on the data access technology being used, Delphi is quite picky about MySQL versions. Usually he'd be better off using the MyODBC driver -- more likely to work with more versions.

    Opening your MySQL server to external connections is a security risk. If it were me I'd say (and have said) "sorry, no can do".
     
  6. pshepperd

    pshepperd Well-Known Member

    Joined:
    Feb 12, 2005
    Messages:
    147
    Likes Received:
    0
    Trophy Points:
    16
    Yes this is a VERY big security risk, you have to think very seriously about that because you are basically giving hax0rs an "in" to mysql, if someoen finds an exploit in your version they could gain everyones dbases,and whatever is in them.

    I would advise saying "NO" or make him have a static ip before you say yes, and only allow access to the mysql port from his ip (in your firewall), also you could make mysql listen on a separate port, if hes the only one connecting to it externally.
     
Loading...

Share This Page