(→Import a database) |
|||
| Line 1: | Line 1: | ||
| + | = MySQL = | ||
| + | |||
MySQL is the best database we know. That's what we use. | MySQL is the best database we know. That's what we use. | ||
| − | = Survival kit = | + | == Survival kit == |
<pre>SHOW databases;</pre> | <pre>SHOW databases;</pre> | ||
| Line 7: | Line 9: | ||
is may be the most important command. It shows you what's in store. | is may be the most important command. It shows you what's in store. | ||
| − | == Create a user == | + | === Create a user === |
<pre> | <pre> | ||
| Line 14: | Line 16: | ||
</pre> | </pre> | ||
| − | == Import a database == | + | === Import a database === |
From the command line: | From the command line: | ||
Contents |
MySQL is the best database we know. That's what we use.
SHOW databases;
is may be the most important command. It shows you what's in store.
CREATE USER 'laussy' IDENTIFIED BY 'mypass'; GRANT ALL PRIVILEGES ON *.* TO 'laussy';
From the command line:
mysql -u laussy -p wikilaussy < wikilaussy-24-jan-10.sql
to import the database data (wikilaussy-24-jan-10.sql, a readable file with very long lines) into the database structure (named wikilaussy) above.