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.

problem with conect to database from ANY IP

Discussion in 'General Discussion' started by lolekserwer, Dec 20, 2006.

  1. lolekserwer

    lolekserwer Registered

    Joined:
    Dec 15, 2006
    Messages:
    1
    Likes Received:
    0
    Trophy Points:
    1
    hi!
    I build some application which use dbExpress component to connecting with database.

    and i've got a problem:

    how from WHM/Cpanel/ssh establish Acces Hosts to any IP, because i want to that any of users (from any IP) can connect to DataBase. It's very important for me!

    Now when I try to connectI can see that error

    Acces denied fo user 'username'@'%' to database 'dbname'

    please help me!:)
     
  2. ThinIce

    ThinIce Well-Known Member

    Joined:
    Apr 27, 2006
    Messages:
    346
    Likes Received:
    7
    Trophy Points:
    18
    Location:
    Disillusioned in England
    cPanel Access Level:
    Root Administrator
    I believe you just use the wildcard % in the access hosts field

    You'll still need to connect with a user with the right permissions etc
     
  3. plexihosting

    plexihosting Member

    Joined:
    Dec 16, 2006
    Messages:
    13
    Likes Received:
    0
    Trophy Points:
    1
    That should really be a last resort as it is a huge security hole. You should always grant as granular privileges as possible. This would even include not granting all privileges to users who don't need it. Adding % to access hosts is just asking for trouble in my opinion.
     
Loading...

Share This Page