(Created page with 'MySQL is the best database we know. That's what we use. = Survival kit = <pre>SHOW databases;</pre> is may be the most important command. It shows you what's in store. == Cre…') |
(→Survival kit) |
||
Line 12: | Line 12: | ||
CREATE USER 'laussy' IDENTIFIED BY 'mypass'; | CREATE USER 'laussy' IDENTIFIED BY 'mypass'; | ||
GRANT ALL PRIVILEGES ON *.* TO 'laussy'; | GRANT ALL PRIVILEGES ON *.* TO 'laussy'; | ||
+ | </pre> | ||
+ | |||
+ | == Import a database == | ||
+ | |||
+ | From the command line: | ||
+ | |||
+ | <pre> | ||
+ | mysql -u laussy -p -h localhost wikilaussy < wikilaussy-24-jan-10.sql | ||
</pre> | </pre> |
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 -h localhost wikilaussy < wikilaussy-24-jan-10.sql