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 [2019/05/24 09:50] – [Import database] maferreira | programming:mysql:mysql [2019/10/11 09:34] (current) – [Export database] maferreira | ||
---|---|---|---|
Line 5: | Line 5: | ||
===== Export database ===== | ===== Export database ===== | ||
+ | With data: | ||
<code mysql> | <code mysql> | ||
+ | Without data: | ||
+ | <code mysql> | ||
===== Import database ===== | ===== Import database ===== | ||
<code mysql> | <code mysql> | ||
<note important> | <note important> | ||
- | | + | < |
Query OK, 1 row affected (0.01 sec) | Query OK, 1 row affected (0.01 sec) | ||
===== Create user ===== | ===== Create user ===== | ||
- | | + | <code mysql>CREATE USER '< |
mysql> grant usage on *.* to myUsername@localhost identified by ' | mysql> grant usage on *.* to myUsername@localhost identified by ' |
programming/mysql/mysql.1558691420.txt.gz · Last modified: 2019/05/24 09:50 by maferreira