connect to mysql server code example

Example 1: java connect to mysql

import java.sql.*;  
class MySqlConn{  
    public static void main(String args[]){  
        try{  
            Class.forName("com.mysql.cj.jdbc.Driver");  
            Connection conn = DriverManager.getConnection("jdbc:mysql://
            localhost:3306/databasename","username","password");  
            Statement stmt = conn.createStatement();  
            ResultSet rs = stmt.executeQuery("select * from emp");    
            con.close();  
        }catch(Exception ex){
            System.out.println(ex);
        }  
    }
}

Example 2: mysql login console

mysql -u USERNAME -p

Example 3: mysql connect command

mysql --host=localhost --user=myname --password mydb
mysql -h localhost -u myname -p mydb

Example 4: mysql cli connect with password

mysql --user=root --password=mypass

Example 5: how to connect mysql local server

\connect root@localhost:3306

Example 6: mysql connect

$mysqli -> new mysqli(host, username, password, dbname, port, socket)