Each in addition to every application has database in addition to It Is really Important to verify that novel Inserted or updated tape In database Is proper or not. In manual testing, We are executing queries manually to verify, update or delete records but If yous are using selenium WebDriver equally automation tool then
there should last around means to create same affair using script. My finish Is to present yous that how to perform database testing using selenium WebDriver. Download MySQL Installer
We volition larn how to perform database testing using selenium WebDriver amongst MySQL database. First of all, We involve to download MySQL Installer in addition to and thence nosotros volition Install It. Steps to download MySQL are equally bellow.
- Go to MySQL on Windows Download Page
- Click on MySQL Installer link equally bellow. It volition create got yous to "Download MySQL Installer" page.
- On "Download MySQL Installer" page, Click on Download push of "Windows (x86, 32-bit), MSI Installer" equally shown bellow. It volition inquire yous to login or register.
- On login or register page, You tin give the sack login using your existing oracle trouble organisation human relationship or yous involve to create novel account. After Login, It volition create got yous to Begin Your Download page equally bellow.
- It volition present yous popup to salve mysql Installer file equally bellow.
- Click on Save File button. It volition firstly downloading file in addition to acquire file similar bellow.
Install MySQL Server Using MySQL Installer
Now nosotros create got MySQL Installer file using which nosotros tin give the sack Install MySQL server. Perform bellow given steps to Install MySQL server.
- Double click on MySQL Installer msi file. It volition cheque your organisation configuration equally bellow.
- After checking your organisation configuration, It volition opened upward MySQL Installer shroud equally bellow. Select Custom in addition to click on Next button.
- On Next screen, Add MySQL server In Features to last Installed box in addition to click on Next push equally shown bellow.
- It volition present yous gear upward to Install MySQL on adjacent shroud equally bellow. Click on Execute button.
- It volition firstly Installing MySQL server equally bellow.
- When Installation completed, Status volition display Ready To Configure. Click on Next push equally bellow.
- On adjacent screen, add port pose out = 3306 in addition to click on Next button.
- On adjacent screen, Set password in addition to repeat password in addition to click on Next button.
Note : Please yell upward your password. It volition last required during Login In MySql. We volition role It In examination scripts.
- On Next screen, proceed all settings equally It Is equally shown In bellow Image in addition to click on Next button.
- Next shroud volition present yous utilise server configuration steps. Click on Execute button. It volition utilise all server settings i yesteryear one.
- When server configuration applied, click on Finish push equally bellow.
- Click on Next push on production configuration step.
- Click on Finish push on Next shroud to cease MySQL server Installation process.
- When Installation completed, You volition encounter MySQL Command Line Client choice In Start card of Windows equally bellow.
Now MySQL Is Installed In your system. We volition encounter how to create novel tabular array in addition to execute enquiry In MySQL database manually In Next step.