mysql grant

mysql -u admin -p

mysql> use mysql

grant all on user.* to 'user'@'localhost' identified by 'pass';
SHOW GRANTS FOR librarian@localhost;

mysql -u user -p pass