Mysql Command

gistfile1.txt

// Create new user, new db and grant privilege
> CREATE USER 'phong'@'localhost' IDENTIFIED BY 'phong!';

> CREATE DATABASE phong
> GRANT ALL PRIVILEGES ON phong.* TO 'phong'@'localhost';

> FLUSH PRIVILEGES


// Check size all db 
> SELECT table_schema AS "Database", SUM(data_length + index_length) / 1024 / 1024 AS "Size (MB)" FROM information_schema.TABLES GROUP BY table_schema

// Import DB
$ mysql -u user -p phong < file.sql

// Import multiple db
$ mysql -u user -p < file.sql

// start brew mysql in MacOs
brew services start mysql

// stop brew mysql in MacOs
brew services start mysql

// Import DB from file
sudo mysqldump -u phong -p phongdatabase > file.sql