How to see my laravel database?











up vote
-2
down vote

favorite












I've set functional laravel project, database connection works, I've added some tables via terminal but now I'd like to see it just as you can see everything with phpmyadmin, for example. How to locate the database file and how to open it, by default?






database laravel







share|improve this question






















  • If you are satisfied with any of the answers, please approve.
    – senty
    Dec 7 '15 at 3:47















up vote
-2
down vote

favorite












I've set functional laravel project, database connection works, I've added some tables via terminal but now I'd like to see it just as you can see everything with phpmyadmin, for example. How to locate the database file and how to open it, by default?






database laravel







share|improve this question






















  • If you are satisfied with any of the answers, please approve.
    – senty
    Dec 7 '15 at 3:47













up vote
-2
down vote

favorite









up vote
-2
down vote

favorite











I've set functional laravel project, database connection works, I've added some tables via terminal but now I'd like to see it just as you can see everything with phpmyadmin, for example. How to locate the database file and how to open it, by default?






database laravel







share|improve this question













I've set functional laravel project, database connection works, I've added some tables via terminal but now I'd like to see it just as you can see everything with phpmyadmin, for example. How to locate the database file and how to open it, by default?






database laravel




database laravel






share|improve this question













share|improve this question











share|improve this question




share|improve this question










asked Dec 7 '15 at 3:07









domagoj

62




62












  • If you are satisfied with any of the answers, please approve.
    – senty
    Dec 7 '15 at 3:47


















  • If you are satisfied with any of the answers, please approve.
    – senty
    Dec 7 '15 at 3:47
















If you are satisfied with any of the answers, please approve.
– senty
Dec 7 '15 at 3:47




If you are satisfied with any of the answers, please approve.
– senty
Dec 7 '15 at 3:47












2 Answers
2






active

oldest

votes

















up vote
2
down vote



accepted










In Terminal:




  • cd into Project directory


  • vagrant ssh


  • cd into Project directory in machine


  • mysql -u[username] -p[password] - e.g mysql -uhomestead -psecret




Vaala! You are connected to MySQL...





  • SHOW databases;


  • USE [Database Name]; - e.g use Homestead;


  • DESCRIBE tables; to see all tables


  • SELECT * from [table]; - e.g select * from users







share|improve this answer






























    up vote
    0
    down vote













    Are you using MySQL? If so, you can install the MySQL Workbench and enter the same database credentials to view your data similar to PHPMyAdmin. Alternatively, you can install PHPMyAdmin wherever you are developing (local machine/vagrant/remote). You can also view everything in tabular format with the command line and mysql as well, but it's not very friendly.






    share|improve this answer





















      Your Answer






      StackExchange.ifUsing("editor", function () {
      StackExchange.using("externalEditor", function () {
      StackExchange.using("snippets", function () {
      StackExchange.snippets.init();
      });
      });
      }, "code-snippets");

      StackExchange.ready(function() {
      var channelOptions = {
      tags: "".split(" "),
      id: "1"
      };
      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: 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%2fstackoverflow.com%2fquestions%2f34125783%2fhow-to-see-my-laravel-database%23new-answer', 'question_page');
      }
      );

      Post as a guest















      Required, but never shown

























      2 Answers
      2






      active

      oldest

      votes








      2 Answers
      2






      active

      oldest

      votes









      active

      oldest

      votes






      active

      oldest

      votes








      up vote
      2
      down vote



      accepted










      In Terminal:




      • cd into Project directory


      • vagrant ssh


      • cd into Project directory in machine


      • mysql -u[username] -p[password] - e.g mysql -uhomestead -psecret




      Vaala! You are connected to MySQL...





      • SHOW databases;


      • USE [Database Name]; - e.g use Homestead;


      • DESCRIBE tables; to see all tables


      • SELECT * from [table]; - e.g select * from users







      share|improve this answer



























        up vote
        2
        down vote



        accepted










        In Terminal:




        • cd into Project directory


        • vagrant ssh


        • cd into Project directory in machine


        • mysql -u[username] -p[password] - e.g mysql -uhomestead -psecret




        Vaala! You are connected to MySQL...





        • SHOW databases;


        • USE [Database Name]; - e.g use Homestead;


        • DESCRIBE tables; to see all tables


        • SELECT * from [table]; - e.g select * from users







        share|improve this answer

























          up vote
          2
          down vote



          accepted







          up vote
          2
          down vote



          accepted






          In Terminal:




          • cd into Project directory


          • vagrant ssh


          • cd into Project directory in machine


          • mysql -u[username] -p[password] - e.g mysql -uhomestead -psecret




          Vaala! You are connected to MySQL...





          • SHOW databases;


          • USE [Database Name]; - e.g use Homestead;


          • DESCRIBE tables; to see all tables


          • SELECT * from [table]; - e.g select * from users







          share|improve this answer














          In Terminal:




          • cd into Project directory


          • vagrant ssh


          • cd into Project directory in machine


          • mysql -u[username] -p[password] - e.g mysql -uhomestead -psecret




          Vaala! You are connected to MySQL...





          • SHOW databases;


          • USE [Database Name]; - e.g use Homestead;


          • DESCRIBE tables; to see all tables


          • SELECT * from [table]; - e.g select * from users








          share|improve this answer














          share|improve this answer



          share|improve this answer








          edited Nov 22 at 17:17









          Илья Зеленько

          1,0291514




          1,0291514










          answered Dec 7 '15 at 3:33









          senty

          3,148549128




          3,148549128
























              up vote
              0
              down vote













              Are you using MySQL? If so, you can install the MySQL Workbench and enter the same database credentials to view your data similar to PHPMyAdmin. Alternatively, you can install PHPMyAdmin wherever you are developing (local machine/vagrant/remote). You can also view everything in tabular format with the command line and mysql as well, but it's not very friendly.






              share|improve this answer

























                up vote
                0
                down vote













                Are you using MySQL? If so, you can install the MySQL Workbench and enter the same database credentials to view your data similar to PHPMyAdmin. Alternatively, you can install PHPMyAdmin wherever you are developing (local machine/vagrant/remote). You can also view everything in tabular format with the command line and mysql as well, but it's not very friendly.






                share|improve this answer























                  up vote
                  0
                  down vote










                  up vote
                  0
                  down vote









                  Are you using MySQL? If so, you can install the MySQL Workbench and enter the same database credentials to view your data similar to PHPMyAdmin. Alternatively, you can install PHPMyAdmin wherever you are developing (local machine/vagrant/remote). You can also view everything in tabular format with the command line and mysql as well, but it's not very friendly.






                  share|improve this answer












                  Are you using MySQL? If so, you can install the MySQL Workbench and enter the same database credentials to view your data similar to PHPMyAdmin. Alternatively, you can install PHPMyAdmin wherever you are developing (local machine/vagrant/remote). You can also view everything in tabular format with the command line and mysql as well, but it's not very friendly.







                  share|improve this answer












                  share|improve this answer



                  share|improve this answer










                  answered Dec 7 '15 at 3:17









                  Brynn Bateman

                  435515




                  435515






























                      draft saved

                      draft discarded




















































                      Thanks for contributing an answer to Stack Overflow!


                      • 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.





                      Some of your past answers have not been well-received, and you're in danger of being blocked from answering.


                      Please pay close attention to the following guidance:


                      • 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%2fstackoverflow.com%2fquestions%2f34125783%2fhow-to-see-my-laravel-database%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

                      What visual should I use to simply compare current year value vs last year in Power BI desktop

                      Image
                      0 I have column SubToBind that shows current year ratio and column PY SubToBind which shows previous year ratio. How can I simply create a card that would be displaying them both in a nice way? Something like that: I cannot achieve that with regular card, I also tried Card with States by OKViz but also unable to see both values. In KPI visual - I dont like the word "Goal", it will confuse end users. Are there any cards or other visuals that would do the job? Thanks powerbi dax powerbi-embedded share | improve this question edited Jun 11 '18 at 20:11 Oleg ...
                      Read more

                      How to ignore python UserWarning in pytest?

                      Image
                      up vote 1 down vote favorite I am using openpyxl for parsing .xlsm files, and pytest for testing. When I open a file, I get the: OpenPyxl -> UserWarning: Data Validation extension is not supported and will be removed That is not really a problem bcs. program works and I can't change the .xlsm file to fix that. But... When I run pytest with something like: def test_wrong_file_format(): assert check_excel(open_excel('file.xlsm')) == True I will get the warning i mentioned altought check_excel(open_excel('file.xlsm')) returns True and the test should suceed... Is there a nice way to tell the pytest that "It's not a bug it's a feature" and tests should pass even when they get this warning? Is there other way than using something like: with pytest.warns(UserWarning): ...
                      Read more

                      Alexandru Averescu

                      Image
                      Alexandre Averescu Alexandru Averescu Naissance 3 avril 1859 Babele, Ismail  (ro) près de Izmaïl (principauté de Moldavie) Décès 2 octobre 1938 (à 79 ans) [ 1 ] Bucarest Origine   Roumanie Arme cavalerie Grade Maréchal Années de service 1901-1917 Commandement chef d'état-major général 2 e  armée 3 e  armée Groupe d'armée sud armée du Danube Conflits Guerre russo-turque de 1877-1878 Deuxième guerre balkanique Première Guerre mondiale Faits d'armes Bataille de Turtucaia/Tutrakan Bataille de Mărăști Distinctions Autres fonctions 3 fois président du Conseil des ministres ministre des Affaires étrangères ministre sans portefeuille conseiller de la Couronne modifier   Alexandre Averescu (en roumain : Alexandru Averescu .mw-parser-output .prononciation>a{background:url("//upload.wikimedia.org/wikipedia/commons/thumb/8/8a/Loudspeaker.svg/11px-Loudspeaker.svg.png")center ...
                      Read more