User Tools

Site Tools


create_new_mysql_user

Create MySQL user

First create user:

 CREATE USER '<username>'@'<host to connect from>' IDENTIFIED BY 'clear text password>';
 or
 CREATE USER '<username>'@'<host to connect from>' IDENTIFIED BY PASSWORD '<encrypted password>';

Grant some rights to the user (here all as * is used):

GRANT * ON <database name>.* TO '<username>'@'<host to connect from>';

Put privileges into action:

FLUSH PRIVILEGES;

Check MySQL documentation for more details.

create_new_mysql_user.txt · Last modified: 2012/03/22 11:10 by root