Mysql

From Attie's Wiki
Revision as of 17:04, 25 January 2012 by Attie (Talk | contribs)

Jump to: navigation, search
mysql --user=$USERNAME --password=$PASSWORD
mysql --user=user -p
mysqlimport --user=user -p -D wiki_old mediawiki.sql

Useful commands

CREATE USER 'user'@'localhost' IDENTIFIED BY 'password';
CREATE DATABASE database;
GRANT ALL PRIVILEGES ON db.* TO 'user'@'localhost' WITH GRANT OPTION;
REVOKE ALL PRIVILEGES ON *.* FROM 'user'@'localhost';
DROP DATABASE db;
DROP USER user;
Personal tools
Namespaces

Variants
Actions
Navigation
Toolbox