Please note, that this is an old archived version of this site. Check out the new version at andunix.net!

This is an old revision of the document!

MySQL: Create 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}'@'%';

admin, database, mysql, sql

andunix.net

Sidebar

andunix Infos

Tags

MySQL: Create User

Create User

Create User and Database

andunix.net

User Tools

Site Tools

Sidebar

andunix Infos

Tags

MySQL: Create User

Create User

Create User and Database

Page Tools