Skip to content

Instantly share code, notes, and snippets.

@mstfydmr

mstfydmr/mysql_cli.sql

Last active August 29, 2019 18:29
Show Gist options
  • Save mstfydmr/f8fad66b3897ba1a5087950f3d2874f5 to your computer and use it in GitHub Desktop.
Save mstfydmr/f8fad66b3897ba1a5087950f3d2874f5 to your computer and use it in GitHub Desktop.
Download ZIP
MySQL CLI
Raw
mysql_cli.sql
CREATE DATABASE dbname CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
CREATE USER 'newuser'@'localhost' IDENTIFIED BY 'password';
GRANT ALL PRIVILEGES ON * . * TO 'newuser'@'localhost';
FLUSH PRIVILEGES;
# Dump
mysqldump -uUSER -pPASS DBNAME > dump.sql
# Restore
mysql -uUSER -pPASS DBNAME < dump.sql
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment