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/10/04 13:03] – kroduit | 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 ' | ||
Line 84: | Line 96: | ||
$ mysql_tzinfo_to_sql / | $ mysql_tzinfo_to_sql / | ||
For more info see http:// | For more info see http:// | ||
+ | |||
+ | If this error, | ||
+ | <note warning> | ||
+ | |||
+ | <note tip>< | ||
+ | To keep variable always ON even if you restart the server, create file my.cnf | ||
+ | |||
+ | Read : | ||
+ | http:// | ||
+ | </ | ||
<code mysql> | <code mysql> |
programming/mysql/mysql.1507122216.txt.gz · Last modified: 2017/10/04 13:03 by kroduit