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;
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;
Tags:
mysql