Difference between revisions of "Creating MySQL Users/Databases"

From HyperSecurity Wiki
Jump to: navigation, search
(No difference)

Revision as of 21:01, 8 July 2013

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';