mysql-notes.mdown

#MySQL Notes

Administration

Create a database

create database <db_name>

Create a user with usage to Mysql

grant usage on *.* to <user>@localhost identified by '<password>';

Grant all privileges to a user for a certain database

grant all privileges on <db_name>.* to <user>@localhost;