MySQL Setup and Connection

Connecting via CLI

mysql -u root -p
mysql -u username -p database_name

SHOW DATABASES;
CREATE DATABASE mydb;
USE mydb;
SHOW TABLES;
EXIT;

CREATE USER 'myuser'@'localhost' IDENTIFIED BY 'password';
GRANT ALL PRIVILEGES ON mydb.* TO 'myuser'@'localhost';
FLUSH PRIVILEGES;

$pdo = new PDO("mysql:host=localhost;dbname=mydb", "user", "pass");
$pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);

Pro Tip

Always use strong passwords for MySQL users in production environments.