Skip to content

add new user

Jump to bottom
Rayhan Uddin edited this page Oct 3, 2017 · 2 revisions 
 mysql> CREATE USER 'finley'@'localhost' IDENTIFIED BY 'some_pass';
 mysql> GRANT ALL PRIVILEGES ON *.* TO 'finley'@'localhost'
  ->     WITH GRANT OPTION;
 mysql> CREATE USER 'finley'@'%' IDENTIFIED BY 'some_pass';
mysql> GRANT ALL PRIVILEGES ON *.* TO 'finley'@'%'
  ->     WITH GRANT OPTION;

mysql> CREATE USER 'admin'@'localhost' IDENTIFIED BY 'admin_pass'; mysql> GRANT RELOAD,PROCESS ON . TO 'admin'@'localhost'; mysql> CREATE USER 'dummy'@'localhost';

Clone this wiki locally