Create a MySQL Database, Username, Password, and Privileges from the command line

Create the Database

============================

mysql > create database db_name;

 

 Create the User

============================

mysql > create user db_user;

 

Grant privileges while assigning the password

===========================

mysql > grant all on db_name.* to 'db_user'@'localhost' identified by 'db_password';

 

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s