Use JDBC/Mysql Connector in intellij idea

Question

I'm new in Java, and I need to establish a connection to a MySQL server (local), I have add the libraries in Intellij idea but it seems not work, the IDE can't find the class i think... I become crazy I'm searching since two hours... I come from visual studio/c# dev environment and i think that i should miss something...

Here you can have a pic from my IDE and the simple code that I wanted use. You can also deduce that I have import the jar in my project (mysql-jdbc).

IDE pic

Edit : here is the code, the comment show where the error appear :

import java.sql.Connection; import java.sql.DriverManager; import java.sql.*; import org.*; import com.mysql.jdbc.Driver;   public class JdbcLogin {     public String Login;     public String MotDePasse;     private boolean Logged = false;      public void StartBdd(){         String driverName = "com.mysql.jdbc.Driver";         Class.forName(driverName); // here is the ClassNotFoundException          String serverName = "localhost";         String mydatabase = "suptodo";         String url = "jdbc:mysql://" + serverName + "/" + mydatabase;          String username = "root";         String password = "azerty";         Connection connection = DriverManager.getConnection(url, username, password);     } } 

Answer 1

It's easy to configure first just open the InteliJ IDE and follow this simple step

File->Project Structure->Libraries 

Then Click on the plus(+) sign and select From Meven....

After you'll get a search box there you should put

mysql:mysql-connector-java:5.1.40

This will solve the issue

Answer 2

You have to add 'mysql:mysql-connector-java:5.1.40' from maven or add it as java library as shown: