ubuntu 12.04 mysql user log in error
 

Hi everybody! This is my first post. I am working on defining a mysql database for use in my application. Don't want to use root user to update my tables. So, defined a new user using phpmysql interface and limited user access to a specific database and table. Everything seems to be fine but I can not log into mysql with the new user name. Get an error message saying user can not log in.

I am using mysql 5.5 on ubuntu 12.04. Any ideas?

Are you doing remote loggin in? Or just locally inside the server with mysql console? If from remote, you will need to allow source IPs in MySQL.

http://dev.mysql.com/doc/refman/4.1/...unt-names.html

I have tried both. However, when I add a new user from CLI I am able to login. But, when I add in a new user using phpmysql, the new user is not allowed to log into mysql. Any ideas?

The user you add befoce is correctly in mysql.user? the host, the privileges ......
did phpmysql flushed privileges?

No, I don't know. How do find out if phpmysql has flushed the privileges.

If you set privileges yourself in `mysql`.`user` of phpmyadmin doing checking and unchecking radio buttons, you will face this problem.
You have to give privileges to user in proper way.
If you want to restrict user to access a single data base.
Try this

Although if you want to flush privileges, try this.