MySQL DataBase Testing

MySQL Data Base INSTALLATION testing Step-by-Step Guide

  1. Introduction
    SQL Part of “MYSQL” stands for Structured Query Language. MYSQL is a relational database from oracle where data is stored in tables.
    MYSQL is open source and it is very fast, reliable and easy to use. MYSQL works in a client/server architecture.
  2. Download
    To Download the MYSQL please access the following URL->https://dev.mysql.com/downloads/installer/.
    Select the Windows (x86, 32-bit) MSI Installer to download the software.
  3. MYSQL INSTALLATION

  4. Double click on the software to open the installer.
    Note:: If you are getting any error as shown below while launching MYSQL Software please download the .NET Framework from this link->https://www.microsoft.com/en-us/download/confirmation.aspx?id=42642
  5. MYSQL INSTALLATION

  6. Click on Finish and Restart the System to reflect the changes.
  7. MYSQL INSTALLATION

  8. Accept the License agreement and Click on Next.
  9. MYSQL INSTALLATION

  10. Select the Setup Type as Custom and click on Next.
  11. MYSQL INSTALLATION

  12. Select the products MYSQL Server and SQL Workbench and click on Next to download.
  13. MYSQL INSTALLATION

  14. Check Requirements dialog shows the failing requirements.
  15. Note:: Download the Microsoft Visual C++ from this link ->https://www.microsoft.com/en-in/download/details.aspx?id=40784.
    Once the Microsoft Visual C++ setup is successful reopen the installer from the beginning to continue the process of installtation.

    MYSQL INSTALLATION

  16. MY SQL Server and Workbench is ready to be installed. Click on Execute to continue.
  17. MYSQL INSTALLATION

  18. Continue with default values and click on Next.
  19. MYSQL INSTALLATION

  20. Provide the username and password.
  21. MYSQL INSTALLATION

  22. Deselect the option to start the MYSQL Server during System Startup.
  23. Click on Finish to complete installation.
  24. Start the MYSQL Server from the System by accessing ‘services.msc’ from the Start Menu. Select the MYSQL service and click on Start button to start the server.
  25. Open MYSQL Command line Client from Start Menu. Execute the following Commands:
    • Create Database testDB
    • show databases
    • use testdb
    • show tables
    • create table employee (name VARCHAR(20),salary INTEGER);
    • INSERT into employee values (‘JOHN’,25000);

  26. Create a Maven Project add the mysql-connector.jar as an dependency for the project.
  27. This jar file contains “com.mysql.jdbc.Driver” class it must be present in Build path of the project
    in order to successful connection to mysql database.Copy the Maven Dependencies information from the
    Repository URL mentioned below: https://mvnrepository.com/artifact/mysql/mysql-connector-java/5.1.21
    Dependency Infromation:

  28. Execute the following code to retrieve the data from Database ‘testDB’.
  29. Please find the console ouput::

2 comments on “MySQL DataBase Testing

  1. Shweta Bhalerao

    After Step 12, (before #13) the wizard asks for Plugins and Extensions. There is checkbox for Enable X Protocol / MySQL as a Document Store. The default value is NOT checked. If this is checked then it enables other two items a) Text Box for Port Number which shows default value 33060. b) Checkbox for Open Firewall port for network access. Default value is NOT checked.
    Should we keep this screen of wizard as Default? or what? I have a screenshot if you did like to see?

    Reply
    1. TOTAL-QA Post author

      The default Port for MYSQL to be installed in 3306.
      Yes, please proceed with default values.
      Also make sure remember the username/password provided during the installation.

      Reply

Leave a Reply

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