Tuesday, December 31, 2013

How to create a MySql user ?

1. Login as root
> mysql -uroot

2. Run the following commands
> CREATE USER 'newuser'@'localhost' IDENTIFIED BY 'password';
> GRANT ALL PRIVILEGES ON * . * TO 'newuser'@'localhost';
> FLUSH PRIVILEGES; 

No comments: