mysql create user debian 10 code example

Example: create user mysql debian 10

mysql -u root -p
--enter password--
CREATE USER 'user'@'localhost' IDENTIFIED BY 'password';
CREATE DATABASE `myDB`;
GRANT ALL PRIVILEGES ON myDB . * TO 'user'@'localhost';
FLUSH PRIVILEGES;