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”
-
How to Quick-Start with Command Line on Linux/Unix:
Here Bash Shell QuickStart GuideLink to Step-by-Step Guide on Getting Started with Command Line in Linux/Unix Systems You Need to be Sure than MySQL is Up and Running:
and check if it give you an OutputCopyps aux | grep mysqld | grep /
OR Instead.
Check if you are Able to Login from Terminal:
You Need to Insert the Right MySQL User Password…Copymysql -uMyUser -p
Example:
Copymysql -uroot -p
Check if the mysql.sock is in /tmp:
look if you got an Output Containing a Reference to mysql.sock.Copyls /tmp | grep mysql.sock
Else find where mysql.sock is located:
a) By the Locate command(Your locate Database should be Up to Date…)Copylocate mysql.sock
How to Quick Start with the locate Command
Here locate Command Quick StartHow to Update the locate Commando to find/search for files/icons/directories on linuxNext 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)Copymysqladmin -uroot -p variables | grep 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:Copysudo ln -s
mysql.sock /tmp/mysql.sock 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';
- Latest Restart MySQL and Apache