Skip to content

Instantly share code, notes, and snippets.

@tojibon

tojibon/mysql.bat

Created February 8, 2019 12:47
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save tojibon/50c773883663b7516e50730ff6cfa5dc to your computer and use it in GitHub Desktop.
Save tojibon/50c773883663b7516e50730ff6cfa5dc to your computer and use it in GitHub Desktop.
Download ZIP
Connect MySQL + Create Database + Import SQL via terminal
Raw
mysql.bat
mysql -u root -p
CREATE DATABASE phpapp_db;
CREATE USER 'phpapp_user'@'localhost' IDENTIFIED BY 'phpapp_user_pass';
GRANT ALL ON phpapp_db.* TO 'phpapp_user'@'localhost';
exit;
mysql -u phpapp_user -pphpapp_user_pass -D phpapp_db;
exit;
mysql -u phpapp_user -pphpapp_user_pass -D phpapp_db < dummy_data.sql;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment