2002 - Network is unreachable - The server is not responding (or the local server's socket is not correctly configured)

The name of the pictureThe name of the pictureThe name of the pictureClash 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



enter image description here







share|improve this question
























    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



    enter image description here







    share|improve this question






















      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



      enter image description here







      share|improve this question












      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



      enter image description here









      share|improve this question











      share|improve this question




      share|improve this question










      asked Oct 30 '17 at 5:07









      fernandus

      64




      64




















          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';





          share|improve this answer




















          • 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











          • 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











          Your Answer







          StackExchange.ready(function()
          var channelOptions =
          tags: "".split(" "),
          id: "106"
          ;
          initTagRenderer("".split(" "), "".split(" "), channelOptions);

          StackExchange.using("externalEditor", function()
          // Have to fire editor after snippets, if snippets enabled
          if (StackExchange.settings.snippets.snippetsEnabled)
          StackExchange.using("snippets", function()
          createEditor();
          );

          else
          createEditor();

          );

          function createEditor()
          StackExchange.prepareEditor(
          heartbeatType: 'answer',
          convertImagesToLinks: false,
          noModals: false,
          showLowRepImageUploadWarning: true,
          reputationToPostImages: null,
          bindNavPrevention: true,
          postfix: "",
          onDemand: true,
          discardSelector: ".discard-answer"
          ,immediatelyShowMarkdownHelp:true
          );



          );













           

          draft saved


          draft discarded


















          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






























          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';





          share|improve this answer




















          • 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











          • 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















          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';





          share|improve this answer




















          • 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











          • 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













          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';





          share|improve this answer












          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';






          share|improve this answer












          share|improve this answer



          share|improve this answer










          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










          • 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

















          • 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











          • 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


















           

          draft saved


          draft discarded















































           


          draft saved


          draft discarded














          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













































































          Popular posts from this blog

          How to check contact read email or not when send email to Individual?

          Displaying single band from multi-band raster using QGIS

          How many registers does an x86_64 CPU actually have?