mysql> GRANT ALL PRIVILEGES ON *.* TO root@localhost IDENTIFIED BY ' your current password ' WITH GRANT Insert the host and password This section will allow to insert the host's name and user account ...

For earlier versions of MySQL, you can combine the user creation and granting privileges into a single statement, but the IDENTIFIED BY clause needs to be used correctly.