How To create a MySQL database and set privileges to a user

mysql> CREATE USER 'root'@'10.0.0.1' IDENTIFIED BY 'password';


mysql> GRANT ALL PRIVILEGES ON *.* TO 'root'@'10.0.0.1' WITH GRANT OPTION;


mysql> FLUSH PRIVILEGES;