make new user in mysql terminal and give permissions to one database code example

Example: mysql user permission database

GRANT ALL PRIVILEGES ON `db_name`.* TO 'user'@'host'