programming:mysql:mysql
Differences
This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revisionNext revision | Previous revisionLast revisionBoth sides next revision | ||
programming:mysql:mysql [2019/05/24 09:49] – [Export database] maferreira | programming:mysql:mysql [2019/05/24 09:51] – [Import database] maferreira | ||
---|---|---|---|
Line 7: | Line 7: | ||
<code mysql> | <code mysql> | ||
===== Import database ===== | ===== Import database ===== | ||
- | | + | <code mysql>mysql -u username -p database_name < file.sql</ |
<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.txt · Last modified: 2019/10/11 09:34 by maferreira