Revision as of 17:52, 11 November 2011

MySQL

MySQL is the best database we know. That's what we use.

Survival kit

SHOW databases;

is may be the most important command. It shows you what's in store.

Create a user

CREATE USER 'laussy' IDENTIFIED BY 'mypass';
GRANT ALL PRIVILEGES ON *.* TO 'laussy';

Import a database

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.

Links

• Linux command line and MySQL.