rano9999/MySql Tooltips.md

Forked from jzzdog/MySql Tooltips.md

Created October 19, 2021 07:05

Star (0) You must be signed in to star a gist
Fork (0) You must be signed in to fork a gist

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/rano9999/9eb52d3f021fbbb36ec294d5c8236170.js"></script>
Save rano9999/9eb52d3f021fbbb36ec294d5c8236170 to your computer and use it in GitHub Desktop.

Download ZIP

MySql Tooltips

Raw

MySql Tooltips.md

MySql Initial settings

$ mysql -u root -p
mysql> CREATE DATABASE azcommunity_production DEFAULT CHARACTER SET utf8;
mysql> GRANT ALL PRIVILEGES ON azcommunity_production.* TO 'deploy'@'localhost' 
       IDENTIFIED BY 'deploy';
mysql> EXIT;

Backup and restore

> mysqldump -u deploy -p[password] azcommunity_production > dump.sql
> mysql -u deploy -p[password] azcommunity_production < community_dump.sql

more info: http://habrahabr.ru/post/105954/