26. Java Basics for Selenium - Java Database Connectivity - Installing XAMPP MySql Database

Installing MySql database locally for practice:
For installing MySql, we will download and install XAMPP. With this we get Apache server and MySql database.
Note: We also use this when we do a project on selenium. So, I recommend you to install this.
Go to google and search for XAMPP download.
You will get many sources from where you can download XAMPP. The following is one of them.
Once you download XAMPP, install it on your system.
Once it is installed successfully, go to windows start button and go to folder XAMPP and you will see XAMPP Control Panel. Open the XAMPP control panel.
Start the Apache Server and MySQL server by clicking on start buttons. You should see that both are started without any errors.
Now you can access the database using the following url.
On the left-hand side, you will see different databases.
Once you click on any database, you will see the different tables associated with it.
Once you click on any table you will see the data of the tables.
Setting up a User Name and Password:
Once you install XAMPP, the default user name and password for phpMyAdmin are
User name: root
Password: (no password).
You can use the above details for connecting to any database using JDBC. But let’s create a new username and password.
Go to the home page by clicking on the home button or phpMyAdmin image on the top left side. Now click on “User Accounts” and you should be able to see all the user names here.
Click on “Add User Account” link.
Enter the user name and password you like.
Enter the user name and password you like. (I am adding username: subbu123 and password: subbu123)
Select the host as localhost. (This is important otherwise it won’t work)
Under the Global Privileges section, select the checkbox “Check All” and save it and a new user should be created with all the privileges.
This step is important as if you don’t select this check box the new user will not get all the privileges.