MySQL is one of the most popular and open source database used by many large and small scale organizations.It is reliable and a organized database to maintain all your data in one place which can be accessed centrally from anywhere.Recently,It has been acquired by the most renowned company Oracle.
Below are the complete steps of installing MySQL community server database which is an open source database.You can use this for your production environment as well.
3. You will see the first Welcome screen. Click on Install MySQL Products:
4. Accept License Agreement and click on Next:
5. If you have access to the internet, then click on Execute to check if there are newer versions of the products:
6. Choose the type of the setup. I am selecting Full as I want all features to be included:
7. Requirements is checked and in this case, Microsoft
Visual C++ runtime is missing. Click Execute to download the missing
requirement:
8. Accept the License Terms and click on Install:
9. A final requirement check. Click on Next to proceed:
10. List of products to be installed is displayed. Click on Execute to proceed:
11. Progress Summary is displayed:
12. When all products are installed successfully, click on Next:
13. Products which require configuration is displayed. Click Next to proceed:
14. Choose the type of the configuration which you require for the MySQL server. Read the description for each type to learn about the differences. I am choosing Developer Machine since I am going to use it with other products and I want the minimal memory. Click Next to proceed:
15. Default Network and Security settings are displayed. Enter root account password and click Next to continue:
16. Confirm the configuration overview and click Next:
17. Products are going to be installed and a completion message is displayed in the end. Click on Start MySQL Workbench to start working with MySQL. Click Finish:
18. MySQL Workbench will start. As this is the first time, click on New Connection to create a connection to the database so that we can query:
19. Type in the connection name: MydbConnection and click on OK:
20. You will be prompted with root account password. Enter and click OK:
21. Now you can see your database objects on the left side and you can write your SQL query in the middle box.
Below are the complete steps of installing MySQL community server database which is an open source database.You can use this for your production environment as well.
1. Download
the MySQL Community Server from the link below.
http://www.mysql.com/downloads/installer/5.6.html
Click on Download and then save to your computer the msi installer.(full installer 170.6M)
2. Double click on the mysql-installer-5.5.21.0.msi Windows
Installer Package.http://www.mysql.com/downloads/installer/5.6.html
Click on Download and then save to your computer the msi installer.(full installer 170.6M)
3. You will see the first Welcome screen. Click on Install MySQL Products:
4. Accept License Agreement and click on Next:
5. If you have access to the internet, then click on Execute to check if there are newer versions of the products:
6. Choose the type of the setup. I am selecting Full as I want all features to be included:
8. Accept the License Terms and click on Install:
9. A final requirement check. Click on Next to proceed:
10. List of products to be installed is displayed. Click on Execute to proceed:
11. Progress Summary is displayed:
12. When all products are installed successfully, click on Next:
13. Products which require configuration is displayed. Click Next to proceed:
14. Choose the type of the configuration which you require for the MySQL server. Read the description for each type to learn about the differences. I am choosing Developer Machine since I am going to use it with other products and I want the minimal memory. Click Next to proceed:
15. Default Network and Security settings are displayed. Enter root account password and click Next to continue:
16. Confirm the configuration overview and click Next:
17. Products are going to be installed and a completion message is displayed in the end. Click on Start MySQL Workbench to start working with MySQL. Click Finish:
18. MySQL Workbench will start. As this is the first time, click on New Connection to create a connection to the database so that we can query:
19. Type in the connection name: MydbConnection and click on OK:
20. You will be prompted with root account password. Enter and click OK:
21. Now you can see your database objects on the left side and you can write your SQL query in the middle box.
No comments:
Post a Comment