CODEWITHSUNDEEP
mysqldatabaseprivileges
Freddie
Freddie

Reputation: 1707

Default MySQL user privileges after executing CREATE USER

What privileges does a newly created user have after running:

CREATE USER 'jeffrey'@'localhost' IDENTIFIED BY 'mypass';

Upvotes: 3

Views: 3877

Answers (1)

David O'Meara
David O'Meara

Reputation: 3033

creates a new row in the mysql.user table and assigns the account no privileges http://dev.mysql.com/doc/refman/5.1/en/create-user.html

Upvotes: 4

Related Questions