Error configuring phpmyadmin

Question

After installing the configuration began, however I kept getting this message saying:

 An error occurred while installing the database:                                
  │                                                                                 
  │ ERROR 2002 (HY000): Can't connect to local MySQL server through socket          
  │ '/var/run/mysqld/mysqld.sock' (2)         

I am new to this not sure what is blocking the mysql socket

Answer 1

Sounds like a typical permission problem, you need to ensure that your permissions can correctly read and write the database sock file.

Source

If your file my.cnf (usually in the /etc/mysql/ folder) is correctly configured with:

socket=/var/lib/mysql/mysql.sock 

You can check if mysql is running with the following command:

mysqladmin -u root -p status 

Try changing your permission to mysql folder. If you are working locally, you can try:

sudo chmod -R 755 /var/lib/mysql/

If the above doesn't fix the problem then its likely something else, Visit Can't connect to local MySQL server through socket '/var/mysql/mysql.sock' (38) on Stack Overflow for more answers.

Answer 2

That's an error in configuration. You need to put localhost or your IP in it.

Follow this steps:

1. Open /etc/mysql/my.cnf.
2. Find bind-address, and change its value to the database server host machine's IP address. localhost or 127.0.0.1
3. Save and close the file.
4. Restart apache