1. Please take a little time for this simple survey! Thank you for participating!
    Dismiss Notice

mysql config file

Discussion in 'Plesk for Linux - 8.x and Older' started by MaRiOs, Oct 13, 2005.

  1. MaRiOs

    MaRiOs Guest

    0
     
    Any one knows where the config file of mysql is located?
     
  2. Whistler

    Whistler Guest

    0
     
    locate is your friend:
    locate my.cnf

    or have a look at the MySQL variables it might also tell you where the my.cnf is located.
     
  3. MaRiOs

    MaRiOs Guest

    0
     
    I did that before posting but the info inside that file looked to me so small..that I was curious..

    Someone asked me what is the number for the CurrectConnections in mysql and I was looking for it.I couldnt find this anywhere so I asume now that its unlimited.
     
  4. Whistler

    Whistler Guest

    0
     
    CurrectConnections???

    But look in a phpMyAdmin - the server Variables page will show you what settings is currently being used. Or you can always do it in the mysql console: SHOW VARIABLES;
     
  5. MaRiOs

    MaRiOs Guest

    0
     
    Current connection..i dont know..something like that :/
     
  6. Whistler

    Whistler Guest

    0
     
    max connections?
     
  7. MaRiOs

    MaRiOs Guest

    0
     
    he askes how many users/connection it can take in the same time....
     
  8. Whistler

    Whistler Guest

    0
     
    You need to have a look at

    max connections and
    max user connections

    I think.
     
  9. jamesyeeoc

    jamesyeeoc Guest

    0
     
    Marios,

    The /etc/my.cnf which is installed with Plesk is rather small, they leave all the other possible options to be defaulted by mySQL and pretty much only specify the few items which they want to make sure are set a certain way.

    Full mySQL docs can be found at www.mysql.org, or if you are running 4.1x
    http://dev.mysql.com/doc/refman/4.1/en/index.html
     
Loading...