$schemamarkup = get_post_meta(get_the_ID(), 'schemamarkup', true); if(!empty($schemamarkup)) { echo $schemamarkup; }

Phpmyadmin the Server Is Not Responding on Linux/macOS Troubleshooting

December 6, 2023 | By the+gnu+linux+evangelist.

Linux/Unix Phpmyadmin Access Issue

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

This Issue is manifested also as: “The Local MySQL Server’s Socket Is Not Correctly Configured”

  1. How to Quick-Start with Command Line on Linux/Unix:

    Here Bash Shell QuickStart Guide
    Link to Step-by-Step Guide on Getting Started with Command Line in Linux/Unix Systems
  2. You Need to be Sure than MySQL is Up and Running:

    Copy
    ps aux | grep mysqld | grep /
    and check if it give you an Output

    OR Instead.

    Check if you are Able to Login from Terminal:
    Copy
    mysql -uMyUser -p
    You Need to Insert the Right MySQL User Password…
    Example:
    Copy
    mysql -uroot -p
  3. Check if the mysql.sock is in /tmp:

    Copy
    ls /tmp | grep mysql.sock
    look if you got an Output Containing a Reference to mysql.sock.
  4. Else find where mysql.sock is located:

       a) By the Locate command
    Copy
    locate mysql.sock
       (Your locate Database should be Up to Date…)

    How to Quick Start with the locate Command

    Here locate Command Quick Start
    How to Update the locate Commando to find/search for files/icons/directories on linux
       b) By mysqladmin
    Copy
    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)
    Copy
    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:
    Copy
    $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';
  5. Latest Restart MySQL and Apache