[MySQL] ERROR 1044 (42000): Access denied for user 'user'@'localhost' to database 'userdb'

 

grant all privileges on db_name.* to 'user_name'@localhost;
grant all privileges on db_name.* to 'user_name'@'%';

show grants for user_name@localhost;
show grants for user_name@'%';

flush privileges;