#2002-server is not responding (or local socket to MySQL server is not configured correctly)
You will see I have a database in phpmyadmin
and when I want to make a query to a table, it does not leave me, I can only visualize it but I can not make queries, when I try to make my own query, in SQL it appears to me:
2002-the server is not responding (or the local socket to the MySQL server is not configured correctly).
But only that, the other tables I have in that database do I have access to them and I can do query.
PD. I'm in windows
and I don't use XAMPP
5 answers
This error is because your phpMyAdmin configuration has the wrong path to mysql.sock
. You find this in the file config.inc.php
$cfg['Servers'][$i]['socket'] = '/var/lib/mysql/mysql.sock';
What I find strange is that if it works for you for other tables. I hope this helps you.
I solved the problem in config.inc.php,
by setting the current default connection port to the ip. which had previously changed to use another program on local at the same time
$cfg['Servers'][$i]['host'] = '127.0.0.1:3307'
$cfg['Servers'][$i]['host'] = '127.0.0.1:3306'
The last one is the one that worked for me
In my case it was because of the firewall.
- I have added a rule in
"Inbound Rules"
with the port using MySql .
Already works perfectly.
Had the same problem and I solved it by indicating the default port for both MySQL and MariaDB as is as indicated by"FRANCISCO J. BLANCO"