mysql command line for the creating a database install step?

Question

Can some please share their command line for the following step?

Create a MySQL database, and a MySQL user with full permissions for that database.
If you're interested, the privileges actually needed are: CREATE, ALTER, DELETE, INSERT, SELECT, UPDATE, LOCK TABLES

 

Answer 1

check below link

http://cloudservers.rackspacecloud.com/index.php/MySQL_-_Creating_and_editing_users

Comments

Thanks :) The exact commands ended up being...
mysql> CREATE DATABASE qadb;
mysql> CREATE USER 'qauser'@'localhost' IDENTIFIED BY 'password';
mysql> GRANT CREATE, ALTER, DELETE, INSERT, SELECT, UPDATE, LOCK TABLES ON `qadb` . * TO 'qauser'@'localhost';
mysql> FLUSH PRIVILEGES;