LinuxQuestions.org

LinuxQuestions.org (/questions/)
-   Linux - Newbie (http://www.linuxquestions.org/questions/linux-newbie-8/)
-   -   ubuntu 12.04 mysql user log in error (http://www.linuxquestions.org/questions/linux-newbie-8/ubuntu-12-04-mysql-user-log-in-error-4175454328/)

kcmohan 03-16-2013 10:07 AM

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?

blue_print 03-17-2013 08:00 AM

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

kcmohan 03-25-2013 09:43 AM

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?

guru.novice 03-25-2013 09:53 AM

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

kcmohan 03-25-2013 09:57 AM

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

eklavya 03-26-2013 04:39 AM

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.
Code:

mysql> FLUSH PRIVILEGES;


All times are GMT -5. The time now is 03:29 PM.