connect to database mysql code example

Example 1: login to database mysql terminal

mysql -u USERNAME -p

Example 2: mysql connect

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

Example 3: login to database mysql terminal

use DBNAME;

Example 4: login to database mysql terminal

show databases;