Open your MySQL client or command-line interface.Connect to your MySQL server using appropriate credentials.Execute the desired SQL query to retrieve data from the database

import java.sql.Connection;import java.sql.DriverManager;import java.sql.SQLException;public class DatabaseConnectionManager { private static final String JDBC_URL = "jdbc:mysql://localhost:3306/your_database_name"; // Change to your database name private static final String USERNAME = "your_username"; // Change to your MySQL username private static final String PASSWORD = "your_password"; // Change to your MySQL password private static Connection connection; private DatabaseConnectionManager() { // Private constructor to prevent instantiation } public static Connection getConnection() { try { if (connection == null || connection.isClosed()) { connection = DriverManager.getConnection(JDBC_URL, USERNAME, PASSWORD); } } catch (SQLException e) { e.printStackTrace(); } return connection; }}

5. How do you connect to a MySQL database using the command line or a MySQL client?

Which function in PHP can be utilised to query an MySQL database with an SQL statement?a. sql()b. mysql()c. query()d. mysqli_query()e. None of the above.

Write a script that lists all states from the database hbtn_0e_0_usa:Your script should take 3 arguments: mysql username, mysql password and database name (no argument validation needed)You must use the module MySQLdb (import MySQLdb)Your script should connect to a MySQL server running on localhost at port 3306Results must be sorted in ascending order by states.idResults must be displayed as they are in the example belowYour code should not be executed when imported

Assume the connection to database is saved in connection.php file. The php syntax to connect to the database.