Then, we will guide you through the steps to set up a remote connection to your database. We will provide you with the information to download and install the application. The application can replace phpMyAdmin as your interface to work with your database. You can also subscribe to my YouTube channel for more helpful video content.MySQL Workbench is a free tool that can connect your database to your shared server, VPS, or Dedicated hosting account. If you have any questions, feel free to reach out to me using Twitter or LinkedIn. Thank you for reading the entire article. You can also use MySQL from your terminal as well. Your MySQL Workbench is also ready for any kind of development process. If you want then you can also hide the SQL Additions tab by clicking on the colored box.įor getting the Schemas, click on the "Schemas" tab from the navigator. This is your default MySQL Workbench workspace. If you do not want to go into the same hassle of entering a password every time, check the box on save password in the vault. Paste the path/directory in the new blank box.Īnd click "OK" one more time. Click "New" on the Edit environment variable window. Now apply the same process as you did earlier. Now, we need to do the same thing for the MySQL Shell also. Do not close the window now as we need to do the same thing for the MySQL Shell folder. Paste the path/address that you copied earlier. Simply click on the Windows button and type "env".Ĭlick "New". Now open the Environment Variables settings. Therefore, I am going to the "C" drive and opening the "Program Files" directory. Like others, I have also installed my operating system on the "C" drive. Go to the drive where you have installed your Windows operating system. Now we need to configure the path variables for our operating system. It will open the MySQL Workbench and MySQL Shell. NextĬlick "Finish" to complete the installation. The configuration has beep applied successfully. Then when you will receive a green check box in all configuration steps, simply click "Finish". If you want then you can change the settings here based on your need.Īs I have only one user account in my Windows machine, I can safely keep the first option selected. So if you have multiple user accounts in your computer, then they will not be able to access the MySQL server/Workbench. This will grant the full access to the user running the Windows service and the administrator group only, but the other users and groups will not have its access. Select the option to grant full access to the user running the Windows Service and then click "Next." Next Therefore, keep everything as it is, and simply click "Next". We want to run the service as a Standard System Account for our operating system. It will make sure to setup our root password for the MySQL workbench. Keep everything as it is, and simply click "Next". Also, make sure to remember the password as you will need it when you want to work in MySQL Workbench. For testing purposes, I am using a very simple "1111" as my password, but I would recommend not doing the same. It will apply the TCP/IP connectivity for our MySQL server. Keep everything as it is and simply click "Next". It will install the three selected components for us. In the Product Configuration window, simply click "Next". After it gets finished, simply click "Next". The process might take some time depending on your internet speed and computer configuration. Install necessary componentsĬlick "Execute" to install the three necessary components. Selecting and clicking on the right side arrow will take the product name in the "Products to be installed section". Make sure to select the latest "MySQL Server", "MySQL Workbench" and "MySQL Shell". Choose the setup type as custom and click "Next". It will reload the necessary components and open the installer GUI selection window. Simply double click on the installer file. ➡️ Install both MySQL and MySQL Workbench That is our installer file to install MySQL and MySQL workbench. Then download the file which is larger in size.Ī. After that, on the new page, click "MySQL installer for Windows".įrom the dropdown menu, select your operating system as "Microsoft Windows". Scroll down until you find MySQL Community (GPL) Downloads ».Ĭlick on MySQL Community (GPL) Downloads ». You do not want to get into shoddy websites and download the wrong file that infects your favorite machine, right? Find the official website for MySQL Workbench: Make sure to visit only the official website for downloading the MySQL Workbench. How to Install MySQL Workbench ➡️ Download MySQL Workbench
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |