Mysql configuration for an especific site

Discussion in 'General' started by calbasi, Dec 17, 2018.

Tags:
  1. calbasi

    calbasi New Member

    Hi,
    I wonder if it's possible set mysql config options (my.cnf) just for one of my sites.
    Could I use ~/.my.cnf ?
    Then, which is the user who run mysql on ISPConfig? client1, client2, etc?
    I think there is no user/home folder, is there?
     
  2. Jesse Norell

    Jesse Norell Well-Known Member

    No, not for the website.
    It would usually be the "web" users, web1, web2, etc. (assuming you have suexec enabled, which is almost always the case).
    None that the web server would use.

    The mysql client for a website is most frequently the php interpreter in ispconfig setups, and php normally runs as the web# user. There are custom php directives you can set for a website, see the config options for the specific mysql driver your application uses (eg. mysqli .. http://php.net/manual/en/set.mysqlinfo.php).

    If you happen to run a non-php site, you would similarly have to identify what interpreter/module/etc. handles the website, and look up how to configure it.
     
    till likes this.

Share This Page