Results 1 to 9 of 9
  1. #1
    Join Date
    Mar 2009
    Posts
    3,700

    how can i know my server's my.cnf ?

    Hi,

    i order a shared hosting account,

    how can i know what the my.cnf setting on the server ?

    any script can check it ?


    thanx

  2. #2
    Join Date
    Jun 2003
    Location
    California
    Posts
    2,786
    Create a plain text file with this in it:

    Code:
    <?php
    phpinfo();
    ?>
    Save the file as "info.php". Upload it to your web directory (public_html or whatever) and visit it in your browser: http://yourdomain.tld/info.php

    If you're looking for the location of your my.cnf file, it will be listed in the top portion of the display. You probably will not be able to edit it, although on some servers you can have a local "php.ini" file that over-rides it. Ask your host about this.

  3. #3
    Join Date
    Mar 2009
    Posts
    3,700
    it will list php info,can it list mysql setting ? thanx

  4. #4
    Join Date
    Apr 2004
    Location
    Florida
    Posts
    291
    That will not show the my.cnf information it will show you some php mysql information.

    If you have shell access you should be able to do
    cat /etc/my.cnf

  5. #5
    Join Date
    Oct 2002
    Location
    EU - east side
    Posts
    21,920
    phpmyadmin is provided in your control panel at most hosts. You can use it to see the values of Mysql settings (variables section).

  6. #6
    Join Date
    Jun 2003
    Location
    California
    Posts
    2,786
    Quote Originally Posted by ttgt View Post
    it will list php info,can it list mysql setting ? thanx
    Without shell access, its very hard to see the settings for MySql. The phpinfo script will show you many of the variables if you scroll down to the "mysql" section.

    What specifically are you looking for?

  7. #7
    Join Date
    Mar 2009
    Posts
    3,700
    Quote Originally Posted by ldcdc View Post
    phpmyadmin is provided in your control panel at most hosts. You can use it to see the values of Mysql settings (variables section).
    can you tell me more detail ?thanx

  8. #8
    find phpmyadmin in your hosting account. you can find it under database settings.

    once you have opened phpmyadmin click the Variables tab to see the different settings set for your mysql server.

    if you want to modify it you need to have a shell access to your hosting account, most providers require you to request for a shell access first.

  9. #9
    Join Date
    Mar 2003
    Location
    /root
    Posts
    23,991
    Moved > Hosting Security and Technology.

    Specially 4 U
    Reseller Hosting: Boost Your Websites | Fully Managed KVM VPS: 3.20 - 5.00 Ghz, Pure Dedicated Power
    JoneSolutions.Com is on the net 24/7 providing stable and reliable web hosting solutions, server management and services since 2001
    Debian|Ubuntu|cPanel|DirectAdmin|Enhance|Webuzo|Acronis|Estela|BitNinja|Nginx

Similar Threads

  1. Optimize my.cnf for my server
    By chasebug in forum Dedicated Server
    Replies: 1
    Last Post: 03-07-2011, 09:06 AM
  2. What is the best configuration my.cnf for my server, 5660 ?
    By ALMGHARI in forum Hosting Security and Technology
    Replies: 13
    Last Post: 05-25-2010, 05:51 AM
  3. need best config for my.cnf for that server
    By ezak in forum Dedicated Server
    Replies: 5
    Last Post: 07-06-2009, 02:45 PM
  4. my.cnf for a 12 Gb server ?
    By SecondSight in forum Hosting Security and Technology
    Replies: 3
    Last Post: 11-12-2008, 04:00 PM
  5. New cPanel server - /etc/my.cnf
    By hbhb in forum Hosting Security and Technology
    Replies: 6
    Last Post: 07-12-2008, 01:17 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •