How to configure MySQL when using Virtual Hosting (ISPConfig)

Discussion in 'General' started by Nap, Oct 19, 2006.

  1. Nap

    Nap Member

    I'm progressing though the setup of my LAMP server (with ISPConfig) and need some help with setting up MySQL so that resellers/clients can only see their respective databases (including from phpMyAdmin).

    I've tried doing this through phpMyAdmin, but either I didn't do it right or it's not done from there.

    I browsed through all the HowTos and Mini-HowTos but couldn't find anything on this topic.

    Does anyone have a link to a document I can read that will guide me along?

    Thanks,
    Nap
     
  2. Nap

    Nap Member

    I've just noticed that when I log into ISPConfig as a client, the phpMyAdmin link in the tools points to the IP of the server, not to the domain name of the client's site;
    ie: http://192.168.0.5:81/phpmyadmin/index.php

    When I manually type the URL: http://www.abms.net.int:81/phpmyadmin into my browser, I end up at http://webdev.abmsdomain.local:81/phpmyadmin/index.php

    Where 'webdev.abmsdomain.local' = 192.168.0.5.

    (Maybe this thread should be in the other forum, if so, I'm sorry.)

    Cheers,
    Nap
     
  3. falko

    falko Super Moderator Howtoforge Staff

    That's the default. Users can see only their own databases (and the test database unless you deleted it) if you created the databases with ISPConfig.
     
  4. Nap

    Nap Member

    Falko,

    Got it.
    Thanks.

    Cheers,
    Nap
     

Share This Page