Answers for "connect mysql"

PHP
12

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);
        }  
    }
}
Posted by: Guest on May-22-2020
3

mysql cli connect with password

mysql --user=root --password=mypass
Posted by: Guest on July-01-2020
1

mysqli connect

<?php
$mysqli = new mysqli("localhost","my_user","my_password","my_db");

// Check connection
if ($mysqli -> connect_errno) {

  echo "Failed to connect to MySQL: " . $mysqli -> connect_error;
  
  exit();

  }
?>
Posted by: Guest on November-12-2020
-1

mysql connect

$mysqli -> new mysqli(host, username, password, dbname, port, socket)
Posted by: Guest on April-26-2021

Browse Popular Code Answers by Language