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

September 14th, 2011 by Regaz

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: , ,