JDBC MySql Connection in Ubuntu

Setting Up MySQL:

Run the following command in the terminal:

123sudo apt-get install mysql-serversudo apt-get install mysql-clientsudo apt-get install libmysql-java

This will install both in the most up to date version within your repositories. You will be prompted for a root password. You then need to login and setup the server. To do that, run the following command:

1mysql -u root -p

Password will be asked and after that you will be connected to the server. You have to create a database to work on. Run the following command to create one:

1CREATE [database_name];

Replace [database_name] with the name you want. Now, we have to switch database. Run following command in the terminal:

1>USE [database_name];

Now, we have to set classpath. Enter this command at the end of you bashrc file:

1export CLASSPATH=$CLASSPATH:/usr/share/java/mysql-connector-java.jar

Setting Up IDE:

In you favorite IDE, go to Project Properties tab, and click “Add External Jars”. Choose the jar file located at “/usr/share/java/” directory, in this case “mysql-connector-java.java”. Now test this connection using this program:

import java.sql.Connection;import java.sql.DriverManager; class JDBCTest {     String url = “jdbc:mysql://localhost”;     String user = “username”;     String password = “password”;     public static void main(String args[]) {         try {            Connection con;            con = DriverManager.getConnection(url, user, password);            System.out.println(“Success”);         } catch (Exception e) {            e.printStackTrace();         }    }}

After running this program, “Success” message will be shown if the connection is sucessful.
Got problems? Let me know in the comments.v