MySQL: creating a new user/trying to access the database -

MySQL: creating a new user/trying to access the database -

my problem is: had created new user:grant privilages on sampdb.* 'monty'@'' identified 'pass' user had appiared in 2 databases: mysql.user(with no privilages @ all) , mysql.db(with privilages except grant one). ok. after tried access sampdb database new user:mysql -u monty -ppass sampdb. mysql answered: "access denied user 'monty'@'localhost (using password: yes)'.

please, tell me, did mistake?

i think need grant privileges 'monty'@'localhost', rather 'monty'@''. @ moment, you're trying connect via localhost, , 'monty'@'localhost' doesn't exist.

edit: or 'monty'@'%', allow connections host.

mysql mysql-error-1045