Phpmyadmin The server is not responding (or the local MySQL server’s socket is not correctly configured) Mac Linux

September 14, 2011 | By Regaz | Filed in: Uncategorized.

Phpmyadmin Access Issue

This short guide try to Troubleshooting Phpmyadmin Access for Unix-like Platforms

Relax, Take it Easy and Follow Step by Step the Commands and the Instructions…

  1. Open a Terminal Window
    (Press “Enter” to Execute Commands)
  2.  

  3. You Need to be Sure than MySQL is Up and Running:

    ps aux | grep mysqld | grep /

    and check if it give you an Output

    OR Instead

    Check if You are Able to Login from Terminal:

    mysql -uMyUser -p

    You Need to Insert the Right MySQL User Password…
    Example:

    mysql -uroot -p
  4.  

  5. Check if the mysql.sock is in /tmp:

    ls /tmp | grep mysql.sock

    look if you got an Output Containing a Reference to mysql.sock.

  6. Else find where mysql.sock is located:

       a) By the Locate command

    locate mysql.sock

      
    (Your locate Database should be Up to Date…)

    How-to Quick-Start with the locate Command:

    locate Command Quick-Start

       b) By mysqladmin

    mysqladmin -uroot -p variables | grep mysql.sock

    Next select and copy the path to mysql.sock and create a symlink: (You can skip this step and insert directly YourPathTo-mysql.sock on the config.inc.php)

    sudo ln -s mysql.sock /tmp/mysql.sock

    Example: sudo ln -s /var/mysql/mysql.sock /tmp/mysql.sock 3) Modify config.inc.php in Phpmyadmin directory Change or Insert the following entries:

    $cfg['Servers'][$i]['auth_type'] = 'config';
    $cfg['Servers'][$i]['connect_type'] = 'socket';
    $cfg['Servers'][$i]['socket'] = '/tmp/mysql.sock';
    $cfg['Servers'][$i]['user'] = 'yourMySQLUser';
    $cfg['Servers'][$i]['password'] = 'yourMySQLPass';

  7. Latest Restart MySQL and Apache

Tags: , ,