mysql create user


mysql> CREATE USER 'repl'@'%.myslaves.com' IDENTIFIED BY 'slavepass';

//=== https://dev.mysql.com/doc/refman/5.1/en/create-user.html
mysql> CREATE USER 'jeff'@'localhost' IDENTIFIED BY 'mypass';

* to enable the user to connect with no password, remove "IDENTIFIED BY" clause:
mysql> CREATE USER 'jeff'@'localhost';

* to assign the hashed password directly, use "IDENTIFIED BY PASSWORD" clause:
mysql> CREATE USER 'jeff'@'localhost' IDENTIFIED BY PASSWORD '*90Exfydsajd12324959dfare5ere895989';