Results 1 to 4 of 4
  1. #1

    phpMyAdmin Not working

    phpMyAdmin - Error

    #2002 - The server is not responding (or the local MySQL server's socket is not correctly configured)
    My.cnf

    [mysqld]
    set-variable = max_connections=600
    set-variable = interactive_timeout=10
    set-variable = wait_timeout=9
    set-variable = connect_timeout=5
    set-variable = thread_cache_size=8
    set-variable = key_buffer=32M
    set-variable = max_allowed_packet=5899M
    set-variable = table_cache=2056
    set-variable = sort_buffer=8M
    set-variable = record_buffer=8M
    set-variable = thread_cache=16
    set-variable = long_query_time=5
    #set-variable = log-queries-not-using-indexes
    #set-variable = log-slow-queries=/var/log/slow.log
    set-variable = low_priority_updates=1
    set-variable = tmp_table_size=64M
    set-variable = max_heap_table_size=64M
    #set-variable = join_buffer_size = 1M
    max_user_connections=40
    #set-variable = thread_concurrency=4
    set-variable = myisam_sort_buffer_size=32M
    set-variable = query_cache_limit=8M
    set-variable = query_cache_size=16M
    set-variable = query_cache_type=1
    skip-locking
    #skip-innodb
    tmpdir = /tmp/
    max_tmp_tables=256

    old-passwords = 1

    [safe_mysqld]
    err-log=/var/log/mysqld.log
    open_files_limit=8192

    [mysqldump]
    quick
    set-variable = max_allowed_packet=5989M

    [mysql]
    no-auto-rehash
    # Remove the next comment character if you are not familiar with SQL
    #safe-updates

    [isamchk]
    set-variable = key_buffer=8M
    set-variable = sort_buffer=8M
    set-variable = read_buffer=8M
    set-variable = write_buffer=8M

    [myisamchk]
    set-variable = key_buffer=8M
    set-variable = sort_buffer=8M
    set-variable = read_buffer=8M
    set-variable = write_buffer=8M





    Please help me how to fix it

  2. #2
    Join Date
    Aug 2007
    Posts
    410
    http://sourceforge.net/project/downl...or=superb-east

    ^^ install and download

    Install as usual and in the configuration config.inc.php you need to set the variable $cfg['Servers'][$i]['socket'] to /tmp/mysql.sock.
    google &^^&

  3. #3
    Join Date
    Oct 2004
    Location
    Kerala, India
    Posts
    4,750
    Have you made sure the mysql server is up and it is listening on the proper socket?
    David | www.cliffsupport.com
    Affordable Server Management Solutions sales AT cliffsupport DOT com
    CliffWebManager | Access WHM from iPhone and Android

  4. #4
    Is this a cPanel server? If so, is the PHP interpreter used by cpsrvd configured to connect to the appropriate socket?

    I've seen some cases where it's required that you explicitly configure this path for the cpsrvd PHP interpreter. You can determine the path to your mysql socket by executing:

    Code:
     mysql -e 'show variables' | grep socket | awk '{ print $NF }'
    You can determine which socket the cpsrvd PHP interpreter is configured to connect to by executing:

    Code:
     grep mysql.default_socket /usr/local/cpanel/3rdparty/etc/php.ini

Posting Permissions

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