Sounds from the North

MySQL dump

Posted on 17. Feb, 2010 by admin in Code

This is a code dump of  simple and most useful MySQL commands for those people who have bad memory and need to get things done very quickly. There might be more efficient ways to deal with the below, I am sure that according to your project, you know if this is enough for you or if you need more experienced resources like http://forums.mysql.com/

Creating a new database and a new user with all rights

CREATE DATABASE databasename;

GRANT ALL PRIVILEGES ON databasename.* TO user@localhost
      IDENTIFIED BY 'password';

Tags: MySQL