programming:mysql:mysql
Differences
This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revisionNext revision | Previous revision | ||
programming:mysql:mysql [2017/11/24 15:00] – [Mysql timezone] mferreira | programming:mysql:mysql [2019/10/11 09:34] (current) – [Export database] maferreira | ||
---|---|---|---|
Line 4: | Line 4: | ||
Enter password: | Enter password: | ||
- | | + | ===== Export database ===== |
+ | With data: | ||
+ | < | ||
+ | Without data: | ||
+ | <code mysql> | ||
+ | ===== Import | ||
+ | <code mysql> | ||
+ | <note important> | ||
+ | |||
+ | <code mysql> | ||
Query OK, 1 row affected (0.01 sec) | Query OK, 1 row affected (0.01 sec) | ||
+ | |||
+ | ===== Create user ===== | ||
+ | <code mysql> | ||
mysql> grant usage on *.* to myUsername@localhost identified by ' | mysql> grant usage on *.* to myUsername@localhost identified by ' |
programming/mysql/mysql.1511535656.txt.gz · Last modified: 2017/11/24 15:00 by mferreira