MySQL

Creating a user and assigning to a DB.

First create the user:

CREATE USER ‘uname’@’localhost’ IDENTIFIED BY ‘somepassword’;

Then grant permissions to the user for a DB:

GRANT all on dbname.* TO ‘uname’@’localhost’;

Advertisements
Standard

2 thoughts on “Creating a user and assigning to a DB.

  1. Pingback: Database appearing in one tool but not another | CL-UAT

  2. Pingback: Database appearing in one tool but not another | XL-UAT

Thinking about someting? 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