switchon@lavalamp.biz
+27(0) 83 419 4851 / +27(0) 21 036 1165
Application & software development
Get A Quote

    • Home
    • Services
      • Application & software development
      • Outsourced software development
      • Project based resourcing
      • Digital marketing & consulting
      • Graphic design & consulting
      • UI / UX design & consulting
      • Recruitment services
      • Lease an expert
    • About
      • How we work
      • NBConsult Group
      • Partners
      • Lightbox Digital
    • Blog
    • Join us
    • Contact

    • Home
    • Services
      • Application & software development
      • Outsourced software development
      • Project based resourcing
      • Digital marketing & consulting
      • Graphic design & consulting
      • UI / UX design & consulting
      • Recruitment services
      • Lease an expert
    • About
      • How we work
      • NBConsult Group
      • Partners
      • Lightbox Digital
    • Blog
    • Join us
    • Contact

    • Home
    • Services
      • Application & software development
      • Outsourced software development
      • Project based resourcing
      • Digital marketing & consulting
      • Graphic design & consulting
      • UI / UX design & consulting
      • Recruitment services
      • Lease an expert
    • About
      • How we work
      • NBConsult Group
      • Partners
      • Lightbox Digital
    • Blog
    • Join us
    • Contact

    • Home
    • Services
      • Application & software development
      • Outsourced software development
      • Project based resourcing
      • Digital marketing & consulting
      • Graphic design & consulting
      • UI / UX design & consulting
      • Recruitment services
      • Lease an expert
    • About
      • How we work
      • NBConsult Group
      • Partners
      • Lightbox Digital
    • Blog
    • Join us
    • Contact
    vim adventures
    Vim & Vim Adventures
    Aug 24, 2021
    angular
    Updating A Primitive Type Variable From A Service In Angular
    Sep 6, 2021

    How To Connect Your Forge Remote Database In DBeaver

    Categories
    • Database
    • Software Development
    Tags
    • database
    • dbeaver
    • forge
    • laravel
    dbeaver
    dbeaver

    Sometimes a client wants to see the structure of the database, or you need an easy way of editing something small (For example a user's role). In the above-mentioned examples, it is always best to use a GUI interface than using the terminal. Here I am going to give the steps on how to connect your Laravel Forge remote database in DBeaver.

     

    SSH Key

    First, you will need to set up your SSH key:

    • Login to Forge 
    • Then click on the drop-down labeled "Servers" and select the server you need to connect to
    • Then click on the SSH Keys button on the left panel

    • Next, we will add a new key by filling out the form with the name (example YOUR-NAME DEVICE ) and your public key (you will find your public key in 'C:\Users\YOUR-USERNAME\.ssh\id_rsa.pub' ) then click add.

     

    DBeaver Setup

    First, you will need to install DBeaver. You can download DBeaver here.

    Once DBeaver has been installed open DBeaver, go to the new connection icon on the top left  dbeaver  and then select MySQL. On the main tab, you need to fill out the following information, you can find all the information on Forge.

    • Server Host = DB_HOST
    • Database = DB_DATABASE
    • Username = DB_USERNAME
    • Password = DB_PASSWORD

     

    How to find the information on Forge?

    Once logged in click on the dropdown labeled 'Sites' and select that is connected to the database you would like to look at. Then select environment on the left panel and copy the database information into DBeaver as shown above.

     

    Next, you will need to go to the SSH tab in DBeaver and click on the checkbox 'Use SSH Tunnel'. The fill out the following:

    • Host/IP - This you will find at the top of the sites page on Forge
    • User name = forge
    • Authentication method - select Public Key
    • Private Key - select the folder icon and then select this file 'C:\Users\YOUR-USERNAME\.ssh\id_rsa.pub'

    Now select Finish and your new collection will be listed on the left pane.

     

    DBeaver Tips

    • If you want to edit an entry double click on the entry, do your change, and then press ctrl + s to save your changes
    • To refresh a table to see if there are any updates press F5.

     

    Happy Coding!

    Contact us


      Related posts:

      laravel envoyer and forgeProvisioning A New Digital Ocean Server With Laravel Forge, And Deploying Code With Laravel Envoyer how to setup git-ftp for windowsHow To Setup Git-ftp For Windows how to deploy a backend api to azureHow To Deploy A Backend API To Azure laravel livewireLaravel Livewire
      Share
      26
      Rayne Logan
      Rayne Logan
      Rayne is a web developer with experience in PHP web apps and has an interest in project management and mobile development.

      Leave a Reply Cancel reply

      Your email address will not be published. Required fields are marked *

      Lava Lamp Lab


      Like technology, a lava lamp constantly changes form, producing new conditions with every passing moment



      lava lamp lab facebook   lava lamp lab twitter   lava lamp lab linkedin   lava lamp lab instgram

      Services


      Application & software development

      Outsourced software development

      Project based resourcing

      Digital marketing & consulting

      Graphic design & consulting

      UI / UX design & consulting

      Contact Us


      +27(0) 83 419 4851

      +27(0) 21 036 1165


      switchon@lavalamp.biz


      Unit 4 Monaco Square,
      14 Church Street,
      Durbanville,
      Cape Town, 7550

      NBConsult Group


      nbconsult
      nbconnect msp
      nbclearning
      river broadband
      designer needed
      © 2023 Lava Lamp Lab (Pty) Ltd | All Rights Reserved | Privacy Policy
      Contact us now

        Application & software development

          Outsourced software development

            Project based resourcing

              Digital marketing & consulting

                Graphic design & consulting

                  UI/UX design & consulting

                    Lease an expert

                      Recruitment services

                        We are using cookies to give you the best experience on our website.

                        You can find out more about which cookies we are using or switch them off in settings.

                        Lava Lamp Lab
                        Powered by  GDPR Cookie Compliance
                        Privacy Overview

                        This website uses cookies so that we can provide you with the best user experience possible. Cookie information is stored in your browser and performs functions such as recognising you when you return to our website and helping our team to understand which sections of the website you find most interesting and useful.

                        Strictly Necessary Cookies

                        Strictly Necessary Cookie should be enabled at all times so that we can save your preferences for cookie settings.

                        If you disable this cookie, we will not be able to save your preferences. This means that every time you visit this website you will need to enable or disable cookies again.

                        3rd Party Cookies

                        This website uses Google Analytics to collect anonymous information such as the number of visitors to the site, and the most popular pages.

                        Keeping this cookie enabled helps us to improve our website.

                        Please enable Strictly Necessary Cookies first so that we can save your preferences!

                        Cookie Policy

                        More information about our Cookie Policy