2002 - Network is unreachable - The server is not responding (or the local server's socket is not correctly configured)
Clash Royale CLAN TAG#URR8PPP
up vote
0
down vote
favorite
I can't login to PHPMyAdmin getting error as #2002 - Network is unreachabl, I installed PHPMyAdmin from source.
Configuration I tried in config.inc.php to fix the issue.
$cfg['Servers'][$i]['host'] = '127.0 0.1';
$cfg['Servers'][$i]['connect_type'] = 'tcp';
Another fix I Tried is to set mysql.default_socket to /var/lib/mysql/mysql.sock
but I didn't find one In my php.ini file I find pro_mysql.default_socke and not mysql.default_socket, Do I need to add the mysql.sock path to pro_mysql.default_socke
linux mysql socket phpmyadmin
add a comment |Â
up vote
0
down vote
favorite
I can't login to PHPMyAdmin getting error as #2002 - Network is unreachabl, I installed PHPMyAdmin from source.
Configuration I tried in config.inc.php to fix the issue.
$cfg['Servers'][$i]['host'] = '127.0 0.1';
$cfg['Servers'][$i]['connect_type'] = 'tcp';
Another fix I Tried is to set mysql.default_socket to /var/lib/mysql/mysql.sock
but I didn't find one In my php.ini file I find pro_mysql.default_socke and not mysql.default_socket, Do I need to add the mysql.sock path to pro_mysql.default_socke
linux mysql socket phpmyadmin
add a comment |Â
up vote
0
down vote
favorite
up vote
0
down vote
favorite
I can't login to PHPMyAdmin getting error as #2002 - Network is unreachabl, I installed PHPMyAdmin from source.
Configuration I tried in config.inc.php to fix the issue.
$cfg['Servers'][$i]['host'] = '127.0 0.1';
$cfg['Servers'][$i]['connect_type'] = 'tcp';
Another fix I Tried is to set mysql.default_socket to /var/lib/mysql/mysql.sock
but I didn't find one In my php.ini file I find pro_mysql.default_socke and not mysql.default_socket, Do I need to add the mysql.sock path to pro_mysql.default_socke
linux mysql socket phpmyadmin
I can't login to PHPMyAdmin getting error as #2002 - Network is unreachabl, I installed PHPMyAdmin from source.
Configuration I tried in config.inc.php to fix the issue.
$cfg['Servers'][$i]['host'] = '127.0 0.1';
$cfg['Servers'][$i]['connect_type'] = 'tcp';
Another fix I Tried is to set mysql.default_socket to /var/lib/mysql/mysql.sock
but I didn't find one In my php.ini file I find pro_mysql.default_socke and not mysql.default_socket, Do I need to add the mysql.sock path to pro_mysql.default_socke
linux mysql socket phpmyadmin
asked Oct 30 '17 at 5:07
fernandus
64
64
add a comment |Â
add a comment |Â
1 Answer
1
active
oldest
votes
up vote
0
down vote
You're asking phpMyAdmin to connect by TCP but your database is listening to an UNIX socket. Remove the connect_type
line and set host
to localhost
:
$cfg['Servers'][$i]['host'] = 'localhost';
Its not working getting the same error, I had the default setting as localhost to fix this issue I tried with 127.0 0.1
â fernandus
Oct 30 '17 at 7:46
Use127.0.0.1
for TCP connections. Uselocalhost
for UNIX domain sockets. Make sure your web server doesn't run chrooted to use UNIX domain sockets. Don't mess with the default socket values inmy.cnf
andphp.ini
if you don't know what you're doing.
â Satà  Katsura
Oct 30 '17 at 8:10
I haven't done any configuration with chrooted to use UNIX domain sockets. If so How can I check. I really don't know what it means :(
â fernandus
Nov 1 '17 at 11:05
add a comment |Â
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
up vote
0
down vote
You're asking phpMyAdmin to connect by TCP but your database is listening to an UNIX socket. Remove the connect_type
line and set host
to localhost
:
$cfg['Servers'][$i]['host'] = 'localhost';
Its not working getting the same error, I had the default setting as localhost to fix this issue I tried with 127.0 0.1
â fernandus
Oct 30 '17 at 7:46
Use127.0.0.1
for TCP connections. Uselocalhost
for UNIX domain sockets. Make sure your web server doesn't run chrooted to use UNIX domain sockets. Don't mess with the default socket values inmy.cnf
andphp.ini
if you don't know what you're doing.
â Satà  Katsura
Oct 30 '17 at 8:10
I haven't done any configuration with chrooted to use UNIX domain sockets. If so How can I check. I really don't know what it means :(
â fernandus
Nov 1 '17 at 11:05
add a comment |Â
up vote
0
down vote
You're asking phpMyAdmin to connect by TCP but your database is listening to an UNIX socket. Remove the connect_type
line and set host
to localhost
:
$cfg['Servers'][$i]['host'] = 'localhost';
Its not working getting the same error, I had the default setting as localhost to fix this issue I tried with 127.0 0.1
â fernandus
Oct 30 '17 at 7:46
Use127.0.0.1
for TCP connections. Uselocalhost
for UNIX domain sockets. Make sure your web server doesn't run chrooted to use UNIX domain sockets. Don't mess with the default socket values inmy.cnf
andphp.ini
if you don't know what you're doing.
â Satà  Katsura
Oct 30 '17 at 8:10
I haven't done any configuration with chrooted to use UNIX domain sockets. If so How can I check. I really don't know what it means :(
â fernandus
Nov 1 '17 at 11:05
add a comment |Â
up vote
0
down vote
up vote
0
down vote
You're asking phpMyAdmin to connect by TCP but your database is listening to an UNIX socket. Remove the connect_type
line and set host
to localhost
:
$cfg['Servers'][$i]['host'] = 'localhost';
You're asking phpMyAdmin to connect by TCP but your database is listening to an UNIX socket. Remove the connect_type
line and set host
to localhost
:
$cfg['Servers'][$i]['host'] = 'localhost';
answered Oct 30 '17 at 6:52
Satà  Katsura
10.7k11533
10.7k11533
Its not working getting the same error, I had the default setting as localhost to fix this issue I tried with 127.0 0.1
â fernandus
Oct 30 '17 at 7:46
Use127.0.0.1
for TCP connections. Uselocalhost
for UNIX domain sockets. Make sure your web server doesn't run chrooted to use UNIX domain sockets. Don't mess with the default socket values inmy.cnf
andphp.ini
if you don't know what you're doing.
â Satà  Katsura
Oct 30 '17 at 8:10
I haven't done any configuration with chrooted to use UNIX domain sockets. If so How can I check. I really don't know what it means :(
â fernandus
Nov 1 '17 at 11:05
add a comment |Â
Its not working getting the same error, I had the default setting as localhost to fix this issue I tried with 127.0 0.1
â fernandus
Oct 30 '17 at 7:46
Use127.0.0.1
for TCP connections. Uselocalhost
for UNIX domain sockets. Make sure your web server doesn't run chrooted to use UNIX domain sockets. Don't mess with the default socket values inmy.cnf
andphp.ini
if you don't know what you're doing.
â Satà  Katsura
Oct 30 '17 at 8:10
I haven't done any configuration with chrooted to use UNIX domain sockets. If so How can I check. I really don't know what it means :(
â fernandus
Nov 1 '17 at 11:05
Its not working getting the same error, I had the default setting as localhost to fix this issue I tried with 127.0 0.1
â fernandus
Oct 30 '17 at 7:46
Its not working getting the same error, I had the default setting as localhost to fix this issue I tried with 127.0 0.1
â fernandus
Oct 30 '17 at 7:46
Use
127.0.0.1
for TCP connections. Use localhost
for UNIX domain sockets. Make sure your web server doesn't run chrooted to use UNIX domain sockets. Don't mess with the default socket values in my.cnf
and php.ini
if you don't know what you're doing.â Satà  Katsura
Oct 30 '17 at 8:10
Use
127.0.0.1
for TCP connections. Use localhost
for UNIX domain sockets. Make sure your web server doesn't run chrooted to use UNIX domain sockets. Don't mess with the default socket values in my.cnf
and php.ini
if you don't know what you're doing.â Satà  Katsura
Oct 30 '17 at 8:10
I haven't done any configuration with chrooted to use UNIX domain sockets. If so How can I check. I really don't know what it means :(
â fernandus
Nov 1 '17 at 11:05
I haven't done any configuration with chrooted to use UNIX domain sockets. If so How can I check. I really don't know what it means :(
â fernandus
Nov 1 '17 at 11:05
add a comment |Â
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2funix.stackexchange.com%2fquestions%2f401344%2f2002-network-is-unreachable-the-server-is-not-responding-or-the-local-serve%23new-answer', 'question_page');
);
Post as a guest
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password