Creating new user in MySQL

1. Login to MySQL using root user

2. CREATE USER 'spn'@'localhost' IDENTIFIED BY 'spn';

3. GRANT ALL PRIVILEGES ON * . * TO 'spn'@'localhost';

4. FLUSH PRIVILEGES;