Home › Infos › MySQL › User Administration › MySQL: Create User

MySQL: Create User

  • Replace {db} with the name of the database.
  • Replace {passwd} with the password of the user.
  • Replace {user} with the name of the user.

Create User

CREATE USER '{user}'@'%' IDENTIFIED BY '{passwd}';

Create User and Database

Usually, {user} == {db}

CREATE USER '{user}'@'%' IDENTIFIED BY '{passwd}';
 
GRANT USAGE ON * . * 
TO '{user}'@'%' 
IDENTIFIED BY '{passwd}' 
WITH 
  MAX_QUERIES_PER_HOUR 0 
  MAX_CONNECTIONS_PER_HOUR 0 
  MAX_UPDATES_PER_HOUR 0 
  MAX_USER_CONNECTIONS 0 ;
 
CREATE DATABASE IF NOT EXISTS '{db}' ;
 
GRANT ALL PRIVILEGES 
ON '{db}' . * 
TO '{user}'@'%';

Tags:

Activity