mysql> CREATE USER 'user'@'localhost' IDENTIFIED BY 'password';

mysql> GRANT ALL PRIVILEGES ON database.table TO 'user'@'localhost';

mysql> FLUSH PRIVILEGES;