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.

Globally block connections to mysql from external sites

Discussion in 'General Discussion' started by redlorry919, Apr 19, 2005.

  1. redlorry919

    redlorry919 Well-Known Member

    Joined:
    Feb 14, 2004
    Messages:
    65
    Likes Received:
    0
    Trophy Points:
    6
    Hello,

    Does anyone know how you can globally block users connecting to their mysql databases from another site. (i.e. just allow localhost). I have an issue with one of my users that seems to be generating a huge database (over 500 tables) externally and therefore using up all the resources in mysql and causing a server crash. For some reason, his stats are also not working, so I can't monitor where these are coming from?

    I'll prob end up suspending them as there seems to be other issues, however I'd like to do it for all other accounts.

    I know this can be done via an individual cpanel area but I want to restrict the whole server.

    Any ideas?

    Thanks,
    redlorry919.
     
  2. sawbuck

    sawbuck Well-Known Member

    Joined:
    Jan 18, 2004
    Messages:
    1,367
    Likes Received:
    5
    Trophy Points:
    38
    cPanel Access Level:
    Root Administrator
    Block port 3306. If you want to allow users to connect to localhost using SSH tunneling just be aware that a recent cPanel update has added the following line - AllowTcpForwarding no - to the sshd_config file which will need to be commented out to allow tunneling.
    HTH
     
Loading...

Share This Page