MySQL

From Wiki

Privileges

To grant privileges to an application:

mysql -u root -ppassword

use database

grant all privileges on `database`.* to user identified by 'password';

Importing

To import an SQL dump into an empty database:

mysql -u USER -pPASSWORD DBNAME < FILENAME.sql