Xampp MySQL and PhpMyamin error ubuntu 14.04












0















Just installed latest xampp package on my localhost and on my terminal everything looks fine as shown below:



root@SKYBUNTU:/home/maze# /opt/lampp/lampp start
Starting XAMPP for Linux 5.6.3-0...
XAMPP: Starting Apache...ok.
XAMPP: Starting MySQL...ok.
XAMPP: Starting ProFTPD...ok.


But when I tried to open phpmyadmin I get the following error



Error

MySQL said: Documentation
#2002 - No such file or directory
The server is not responding (or the local server's socket is not correctly configured).
Connection for controluser as defined in your configuration failed.


I also looked at my status from the the xampp page on localhost and it shows that my MySQL database is deactivated.



Component   
Status
Hint
MySQL database DEACTIVATED
PHP ACTIVATED
Perl ACTIVATED
Common Gateway Interface (CGI) ACTIVATED
Server Side Includes (SSI) ACTIVATED
PHP extension »OPcache« DEACTIVATED see FAQ
PHP extension »OCI8/Oracle« DEACTIVATED see FAQ


Can someone please tell/show how to fix this on Ubuntu 14.04 LTS. I desperately need this to be working. Many thanks.










share|improve this question





























    0















    Just installed latest xampp package on my localhost and on my terminal everything looks fine as shown below:



    root@SKYBUNTU:/home/maze# /opt/lampp/lampp start
    Starting XAMPP for Linux 5.6.3-0...
    XAMPP: Starting Apache...ok.
    XAMPP: Starting MySQL...ok.
    XAMPP: Starting ProFTPD...ok.


    But when I tried to open phpmyadmin I get the following error



    Error

    MySQL said: Documentation
    #2002 - No such file or directory
    The server is not responding (or the local server's socket is not correctly configured).
    Connection for controluser as defined in your configuration failed.


    I also looked at my status from the the xampp page on localhost and it shows that my MySQL database is deactivated.



    Component   
    Status
    Hint
    MySQL database DEACTIVATED
    PHP ACTIVATED
    Perl ACTIVATED
    Common Gateway Interface (CGI) ACTIVATED
    Server Side Includes (SSI) ACTIVATED
    PHP extension »OPcache« DEACTIVATED see FAQ
    PHP extension »OCI8/Oracle« DEACTIVATED see FAQ


    Can someone please tell/show how to fix this on Ubuntu 14.04 LTS. I desperately need this to be working. Many thanks.










    share|improve this question



























      0












      0








      0








      Just installed latest xampp package on my localhost and on my terminal everything looks fine as shown below:



      root@SKYBUNTU:/home/maze# /opt/lampp/lampp start
      Starting XAMPP for Linux 5.6.3-0...
      XAMPP: Starting Apache...ok.
      XAMPP: Starting MySQL...ok.
      XAMPP: Starting ProFTPD...ok.


      But when I tried to open phpmyadmin I get the following error



      Error

      MySQL said: Documentation
      #2002 - No such file or directory
      The server is not responding (or the local server's socket is not correctly configured).
      Connection for controluser as defined in your configuration failed.


      I also looked at my status from the the xampp page on localhost and it shows that my MySQL database is deactivated.



      Component   
      Status
      Hint
      MySQL database DEACTIVATED
      PHP ACTIVATED
      Perl ACTIVATED
      Common Gateway Interface (CGI) ACTIVATED
      Server Side Includes (SSI) ACTIVATED
      PHP extension »OPcache« DEACTIVATED see FAQ
      PHP extension »OCI8/Oracle« DEACTIVATED see FAQ


      Can someone please tell/show how to fix this on Ubuntu 14.04 LTS. I desperately need this to be working. Many thanks.










      share|improve this question
















      Just installed latest xampp package on my localhost and on my terminal everything looks fine as shown below:



      root@SKYBUNTU:/home/maze# /opt/lampp/lampp start
      Starting XAMPP for Linux 5.6.3-0...
      XAMPP: Starting Apache...ok.
      XAMPP: Starting MySQL...ok.
      XAMPP: Starting ProFTPD...ok.


      But when I tried to open phpmyadmin I get the following error



      Error

      MySQL said: Documentation
      #2002 - No such file or directory
      The server is not responding (or the local server's socket is not correctly configured).
      Connection for controluser as defined in your configuration failed.


      I also looked at my status from the the xampp page on localhost and it shows that my MySQL database is deactivated.



      Component   
      Status
      Hint
      MySQL database DEACTIVATED
      PHP ACTIVATED
      Perl ACTIVATED
      Common Gateway Interface (CGI) ACTIVATED
      Server Side Includes (SSI) ACTIVATED
      PHP extension »OPcache« DEACTIVATED see FAQ
      PHP extension »OCI8/Oracle« DEACTIVATED see FAQ


      Can someone please tell/show how to fix this on Ubuntu 14.04 LTS. I desperately need this to be working. Many thanks.







      mysql xampp phpmyadmin






      share|improve this question















      share|improve this question













      share|improve this question




      share|improve this question








      edited 2 days ago









      Olorin

      2,121720




      2,121720










      asked Jan 26 '15 at 6:35









      moise andremoise andre

      112




      112






















          1 Answer
          1






          active

          oldest

          votes


















          0














          They may are two problem:
          1. MySql is off
          2. your settings for your socket are wrong.



          For 1. just restart the MySql server.
          For 2. grep -w mysql.default_socket /opt/lampp/etc/php.ini shows your socket.
          Try to set it to blank and run the server again.






          share|improve this answer
























          • Thank you Denni for your answer. I tried the second option as the first option did not work, and I got thisfrom my terminal: mysql.default_socket= How do I blank it? I am a newbie. I tried to open up php.ini from the php folder but not sure if that is the one to edit. thanks.

            – moise andre
            Jan 26 '15 at 10:45













          • Correction: php.ini from /opt/lampp/etc/php.ini. I cannot save the file and getting access denied. Thanks you.

            – moise andre
            Jan 26 '15 at 11:50













          • Hi again, I managed to edit the php.ini file using gksudo gedit /opt/lampp/etc/php.ini and blanked :mysql.default_socket with a semi colon and saved it, but still getting the same old error. ubuntu is getting very frustrating for me at the moment. thinking of going back to windows again which is at least a straight forward installation. thanks.

            – moise andre
            Jan 26 '15 at 13:00













          Your Answer








          StackExchange.ready(function() {
          var channelOptions = {
          tags: "".split(" "),
          id: "89"
          };
          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',
          autoActivateHeartbeat: false,
          convertImagesToLinks: true,
          noModals: true,
          showLowRepImageUploadWarning: true,
          reputationToPostImages: 10,
          bindNavPrevention: true,
          postfix: "",
          imageUploader: {
          brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
          contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
          allowUrls: true
          },
          onDemand: true,
          discardSelector: ".discard-answer"
          ,immediatelyShowMarkdownHelp:true
          });


          }
          });














          draft saved

          draft discarded


















          StackExchange.ready(
          function () {
          StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2faskubuntu.com%2fquestions%2f577913%2fxampp-mysql-and-phpmyamin-error-ubuntu-14-04%23new-answer', 'question_page');
          }
          );

          Post as a guest















          Required, but never shown

























          1 Answer
          1






          active

          oldest

          votes








          1 Answer
          1






          active

          oldest

          votes









          active

          oldest

          votes






          active

          oldest

          votes









          0














          They may are two problem:
          1. MySql is off
          2. your settings for your socket are wrong.



          For 1. just restart the MySql server.
          For 2. grep -w mysql.default_socket /opt/lampp/etc/php.ini shows your socket.
          Try to set it to blank and run the server again.






          share|improve this answer
























          • Thank you Denni for your answer. I tried the second option as the first option did not work, and I got thisfrom my terminal: mysql.default_socket= How do I blank it? I am a newbie. I tried to open up php.ini from the php folder but not sure if that is the one to edit. thanks.

            – moise andre
            Jan 26 '15 at 10:45













          • Correction: php.ini from /opt/lampp/etc/php.ini. I cannot save the file and getting access denied. Thanks you.

            – moise andre
            Jan 26 '15 at 11:50













          • Hi again, I managed to edit the php.ini file using gksudo gedit /opt/lampp/etc/php.ini and blanked :mysql.default_socket with a semi colon and saved it, but still getting the same old error. ubuntu is getting very frustrating for me at the moment. thinking of going back to windows again which is at least a straight forward installation. thanks.

            – moise andre
            Jan 26 '15 at 13:00


















          0














          They may are two problem:
          1. MySql is off
          2. your settings for your socket are wrong.



          For 1. just restart the MySql server.
          For 2. grep -w mysql.default_socket /opt/lampp/etc/php.ini shows your socket.
          Try to set it to blank and run the server again.






          share|improve this answer
























          • Thank you Denni for your answer. I tried the second option as the first option did not work, and I got thisfrom my terminal: mysql.default_socket= How do I blank it? I am a newbie. I tried to open up php.ini from the php folder but not sure if that is the one to edit. thanks.

            – moise andre
            Jan 26 '15 at 10:45













          • Correction: php.ini from /opt/lampp/etc/php.ini. I cannot save the file and getting access denied. Thanks you.

            – moise andre
            Jan 26 '15 at 11:50













          • Hi again, I managed to edit the php.ini file using gksudo gedit /opt/lampp/etc/php.ini and blanked :mysql.default_socket with a semi colon and saved it, but still getting the same old error. ubuntu is getting very frustrating for me at the moment. thinking of going back to windows again which is at least a straight forward installation. thanks.

            – moise andre
            Jan 26 '15 at 13:00
















          0












          0








          0







          They may are two problem:
          1. MySql is off
          2. your settings for your socket are wrong.



          For 1. just restart the MySql server.
          For 2. grep -w mysql.default_socket /opt/lampp/etc/php.ini shows your socket.
          Try to set it to blank and run the server again.






          share|improve this answer













          They may are two problem:
          1. MySql is off
          2. your settings for your socket are wrong.



          For 1. just restart the MySql server.
          For 2. grep -w mysql.default_socket /opt/lampp/etc/php.ini shows your socket.
          Try to set it to blank and run the server again.







          share|improve this answer












          share|improve this answer



          share|improve this answer










          answered Jan 26 '15 at 8:28









          DenniJensenDenniJensen

          17115




          17115













          • Thank you Denni for your answer. I tried the second option as the first option did not work, and I got thisfrom my terminal: mysql.default_socket= How do I blank it? I am a newbie. I tried to open up php.ini from the php folder but not sure if that is the one to edit. thanks.

            – moise andre
            Jan 26 '15 at 10:45













          • Correction: php.ini from /opt/lampp/etc/php.ini. I cannot save the file and getting access denied. Thanks you.

            – moise andre
            Jan 26 '15 at 11:50













          • Hi again, I managed to edit the php.ini file using gksudo gedit /opt/lampp/etc/php.ini and blanked :mysql.default_socket with a semi colon and saved it, but still getting the same old error. ubuntu is getting very frustrating for me at the moment. thinking of going back to windows again which is at least a straight forward installation. thanks.

            – moise andre
            Jan 26 '15 at 13:00





















          • Thank you Denni for your answer. I tried the second option as the first option did not work, and I got thisfrom my terminal: mysql.default_socket= How do I blank it? I am a newbie. I tried to open up php.ini from the php folder but not sure if that is the one to edit. thanks.

            – moise andre
            Jan 26 '15 at 10:45













          • Correction: php.ini from /opt/lampp/etc/php.ini. I cannot save the file and getting access denied. Thanks you.

            – moise andre
            Jan 26 '15 at 11:50













          • Hi again, I managed to edit the php.ini file using gksudo gedit /opt/lampp/etc/php.ini and blanked :mysql.default_socket with a semi colon and saved it, but still getting the same old error. ubuntu is getting very frustrating for me at the moment. thinking of going back to windows again which is at least a straight forward installation. thanks.

            – moise andre
            Jan 26 '15 at 13:00



















          Thank you Denni for your answer. I tried the second option as the first option did not work, and I got thisfrom my terminal: mysql.default_socket= How do I blank it? I am a newbie. I tried to open up php.ini from the php folder but not sure if that is the one to edit. thanks.

          – moise andre
          Jan 26 '15 at 10:45







          Thank you Denni for your answer. I tried the second option as the first option did not work, and I got thisfrom my terminal: mysql.default_socket= How do I blank it? I am a newbie. I tried to open up php.ini from the php folder but not sure if that is the one to edit. thanks.

          – moise andre
          Jan 26 '15 at 10:45















          Correction: php.ini from /opt/lampp/etc/php.ini. I cannot save the file and getting access denied. Thanks you.

          – moise andre
          Jan 26 '15 at 11:50







          Correction: php.ini from /opt/lampp/etc/php.ini. I cannot save the file and getting access denied. Thanks you.

          – moise andre
          Jan 26 '15 at 11:50















          Hi again, I managed to edit the php.ini file using gksudo gedit /opt/lampp/etc/php.ini and blanked :mysql.default_socket with a semi colon and saved it, but still getting the same old error. ubuntu is getting very frustrating for me at the moment. thinking of going back to windows again which is at least a straight forward installation. thanks.

          – moise andre
          Jan 26 '15 at 13:00







          Hi again, I managed to edit the php.ini file using gksudo gedit /opt/lampp/etc/php.ini and blanked :mysql.default_socket with a semi colon and saved it, but still getting the same old error. ubuntu is getting very frustrating for me at the moment. thinking of going back to windows again which is at least a straight forward installation. thanks.

          – moise andre
          Jan 26 '15 at 13:00




















          draft saved

          draft discarded




















































          Thanks for contributing an answer to Ask Ubuntu!


          • Please be sure to answer the question. Provide details and share your research!

          But avoid



          • Asking for help, clarification, or responding to other answers.

          • Making statements based on opinion; back them up with references or personal experience.


          To learn more, see our tips on writing great answers.




          draft saved


          draft discarded














          StackExchange.ready(
          function () {
          StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2faskubuntu.com%2fquestions%2f577913%2fxampp-mysql-and-phpmyamin-error-ubuntu-14-04%23new-answer', 'question_page');
          }
          );

          Post as a guest















          Required, but never shown





















































          Required, but never shown














          Required, but never shown












          Required, but never shown







          Required, but never shown

































          Required, but never shown














          Required, but never shown












          Required, but never shown







          Required, but never shown







          Popular posts from this blog

          Category:香港粉麵

          List *all* the tuples!

          Channel [V]