Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

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';
like image 856
Freddie Avatar asked Nov 16 '25 08:11

Freddie


1 Answers

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

like image 117
David O'Meara Avatar answered Nov 17 '25 20:11

David O'Meara