With Adminer.php I get a Access denied for user 'root'@'localhost' error. Ubuntu 18.04

The name of the pictureThe name of the pictureThe name of the pictureClash Royale CLAN TAG#URR8PPP








up vote
0
down vote

favorite












Access denied for user 'root'@'localhost'



I am getting this error with adminer.php and phpmyadmin won't work either. I am able to run SQL commands in terminal after typing 'sudo mysql'. I have a user table with root as a username but there is no password field.



If anyone can help me to get this to work it would be great.




mysql




share|improve this question
























    up vote
    0
    down vote

    favorite












    Access denied for user 'root'@'localhost'



    I am getting this error with adminer.php and phpmyadmin won't work either. I am able to run SQL commands in terminal after typing 'sudo mysql'. I have a user table with root as a username but there is no password field.



    If anyone can help me to get this to work it would be great.




    mysql




    share|improve this question






















      up vote
      0
      down vote

      favorite









      up vote
      0
      down vote

      favorite











      Access denied for user 'root'@'localhost'



      I am getting this error with adminer.php and phpmyadmin won't work either. I am able to run SQL commands in terminal after typing 'sudo mysql'. I have a user table with root as a username but there is no password field.



      If anyone can help me to get this to work it would be great.




      mysql




      share|improve this question












      Access denied for user 'root'@'localhost'



      I am getting this error with adminer.php and phpmyadmin won't work either. I am able to run SQL commands in terminal after typing 'sudo mysql'. I have a user table with root as a username but there is no password field.



      If anyone can help me to get this to work it would be great.





      mysql





      share|improve this question











      share|improve this question




      share|improve this question










      asked Apr 30 at 6:01









      Olympus

      1




      1




















          1 Answer
          1






          active

          oldest

          votes

















          up vote
          0
          down vote













          This solved my problem - can't login as mysql user root from normal user account in ubuntu 16.04



          I'm using Ubuntu 18.04 and so these instructions work for me.






          share|improve this answer




















            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',
            convertImagesToLinks: true,
            noModals: false,
            showLowRepImageUploadWarning: true,
            reputationToPostImages: 10,
            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%2faskubuntu.com%2fquestions%2f1029961%2fwith-adminer-php-i-get-a-access-denied-for-user-rootlocalhost-error-ubuntu%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













            This solved my problem - can't login as mysql user root from normal user account in ubuntu 16.04



            I'm using Ubuntu 18.04 and so these instructions work for me.






            share|improve this answer
























              up vote
              0
              down vote













              This solved my problem - can't login as mysql user root from normal user account in ubuntu 16.04



              I'm using Ubuntu 18.04 and so these instructions work for me.






              share|improve this answer






















                up vote
                0
                down vote










                up vote
                0
                down vote









                This solved my problem - can't login as mysql user root from normal user account in ubuntu 16.04



                I'm using Ubuntu 18.04 and so these instructions work for me.






                share|improve this answer












                This solved my problem - can't login as mysql user root from normal user account in ubuntu 16.04



                I'm using Ubuntu 18.04 and so these instructions work for me.







                share|improve this answer












                share|improve this answer



                share|improve this answer










                answered Apr 30 at 6:52









                Olympus

                1




                1



























                     

                    draft saved


                    draft discarded















































                     


                    draft saved


                    draft discarded














                    StackExchange.ready(
                    function ()
                    StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2faskubuntu.com%2fquestions%2f1029961%2fwith-adminer-php-i-get-a-access-denied-for-user-rootlocalhost-error-ubuntu%23new-answer', 'question_page');

                    );

                    Post as a guest
































































                    -

                    Popular posts from this blog

                    How do so many people here on Academia.SE, and in general, afford lavish higher education programs?

                    Image
                    Clash Royale CLAN TAG #URR8PPP up vote 45 down vote favorite 7 I graduated last year with a BS in Computer Science. I do not come from a particularly wealthy family, (very low middle class), and was only able to afford my education via school loans/scholarships and working low-wage jobs, with no support from my family or anyone else. I realize some scholarship/loan programs extend into grad school. But I don't think those cover all costs. Now I'm lucky enough to have a decent-paying salary in industry, along with benefits and living on my own, and I'm thinking one day (sooner rather than later) I'd like to try my hand at research or continue my degree, but these things cost money, in addition to my regular living expenses. I read posts here often about academic people being in positions of choosing between these crazy research grad programs, some in Japan, or Ireland (while they currently live in the U.S./U.K.) then moving around between countries/universit...
                    Read more

                    Unable to upgrade pip

                    Image
                    Clash Royale CLAN TAG #URR8PPP up vote 15 down vote favorite 3 I am new to Linux and Ubuntu. I was trying to upgrade pip but ran into this... $ sudo pip install --upgrade pip Cannot fetch index base URL https://pypi.python.org/simple/ Downloading/unpacking pip from https://pypi.python.org/packages/py2.py3/p/pip/pip-7.1.0-py2.py3-none-any.whl#md5=b108384a762825ec20345bb9b5b7209f Downloading pip-7.1.0-py2.py3-none-any.whl (1.1MB): 1.1MB downloaded Installing collected packages: pip Found existing installation: pip 1.5.4 Not uninstalling pip at /usr/lib/python2.7/dist-packages, owned by OS Successfully installed pip Cleaning up... Any idea why? upgrade python share | improve this question edited Aug 29 '17 at 23:52 Zanna 48k 13 119 228 asked Jul 5 '15 at 23:13 Spencer Lee 78 1 1 4 2 try apt i.e. sudo apt-get install python-pip to upgrade pip – heemayl Jul 5 '15 at 23:15 hmmm... s...
                    Read more

                    Cutting all the characters after the last /

                    Image
                    Clash Royale CLAN TAG #URR8PPP up vote 8 down vote favorite 1 How do I cut all characters after the last '/'? This text xxxx/x/xx/xx/xxxx/x/yyyyy xxx/xxxx/xxxxx/yyy should return xxxx/x/xx/xx/xxxx/x xxx/xxxx/xxxxx command-line text-processing share | improve this question edited Feb 28 at 3:57 muru 130k 19 274 467 asked Feb 27 at 15:27 Josef Klimuk 542 1 12 4 Are you trying to omit or isolate the characters after the last / ? – dsstorefile1 Feb 27 at 15:34 Good question, I just realised that we didn't understand the question the same way – Félicien Feb 27 at 15:35 3 The commands basename and dirname do this already. – Michael Hampton Feb 28 at 0:49 I don't think edit #5 to the question was correct. Using the word "cut" might be ambiguous; if you cut something, do you throw away that part...
                    Read more