Create user

grant all on user_database.* to 'user'@'localhost' identified by 'password';

See what mysql user can do

show grants for 'user'@'localhost'

TO show all of the users in the database

select * from  mysql.user