Create the new User in Mysql

1. Get Terminal/windows cmd and type this command to login the mysql terminal.

mysql -u <username> -p<password>

2. Ru'n this command for create new user.

CREATE USER 'sammy'@'localhost' IDENTIFIED BY 'password'; 


3. Grant Privileges.

GRANT ALL PRIVILEGES ON *.* TO 'sammy'@'localhost' WITH GRANT OPTION;

Post a Comment

Previous Post Next Post