Creating MySQL Users/Databases

From HyperSecurity Wiki
Revision as of 21:01, 8 July 2013 by 70.79.79.234 (talk)
(diff) ←Older revision | view current revision (diff) | Newer revision→ (diff)
Jump to: navigation, search

Create a database user:

create user userName;

Create a database:

create database dataBaseName;

Grant user database permissions:

grant all on dataBaseName.* to userName@localhost identified by 'PASSWORD';