All geek questions in one place

# 2002 - The server is not responding (or the local MySQL server is not configured correctly)

I can not access PHPMyAdmin. when I want to get there, I got this error:

# 2002 - The server is not responding (or the local MySQL server is not configured correctly)

I was looking for this error, but it is not clear.

I am trying to figure out which port is open with this code:

pgrep mysql

two ports are open when mysql is running.

I want to access PHPMyAdmin in my localhost. I am using Ubuntu OS

+4
source share
4 answers

Ubuntu mysqldoes not listen on TCP / IP connections by default . It just uses a local socket.

The current local socket is configured in /etc/mysql/my.cnf. If you open this file, you should find something similar to:

[client]
port            = 3306
socket          = /var/run/mysqld/mysqld.sock

PHPMyAdmin (config.inc.php) . , PHPMyAdmin , , , . (, , my.cnf):

$cfg['Servers'][$i]['socket'] = '/var/run/mysqld/mysqld.sock';
+5

mysql .

** wamp **

  • {System name}.err mysql.
  • , .
  • ( ).
  • mysql
0

go to C: \ Windows \ System32 \ drivers \ etc
change the host
add 127.0.0.1 localhost
and restart the server relay check and

0
source

This means that the mysql server is not running. It is very simple, if you use wamp, left-click the wampserver icon, then mysql, then the service, then install the service after restarting Wamp and the problem will be solved.

-2
source

Source: https://habr.com/ru/post/1542148/

More articles:


All Articles