LinuxAnswers - the LQ Linux tutorial section.
Go Back > Forums > Linux Forums > Linux - Newbie
User Name
Linux - Newbie This Linux forum is for members that are new to Linux.
Just starting out and have a question? If it is not in the man pages or the how-to's this is the place!


  Search this Thread
Old 03-16-2013, 11:07 AM   #1
LQ Newbie
Registered: Aug 2012
Posts: 3

Rep: Reputation: Disabled
Angry 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?
Old 03-17-2013, 09:00 AM   #2
Registered: May 2010
Location: In world
Distribution: RHEL, CentOS, Ubuntu
Posts: 275
Blog Entries: 3

Rep: Reputation: 50
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.
Old 03-25-2013, 10:43 AM   #3
LQ Newbie
Registered: Aug 2012
Posts: 3

Original Poster
Rep: Reputation: Disabled

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?
Old 03-25-2013, 10:53 AM   #4
LQ Newbie
Registered: Mar 2013
Posts: 1

Rep: Reputation: Disabled
The user you add befoce is correctly in mysql.user? the host, the privileges ......
did phpmysql flushed privileges?
Old 03-25-2013, 10:57 AM   #5
LQ Newbie
Registered: Aug 2012
Posts: 3

Original Poster
Rep: Reputation: Disabled
No, I don't know. How do find out if phpmysql has flushed the privileges.
Old 03-26-2013, 05:39 AM   #6
Registered: Mar 2013
Posts: 612

Rep: Reputation: 135Reputation: 135
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.

Last edited by eklavya; 03-26-2013 at 05:40 AM.


mysql5, phpmyadmin, ubuntu 12.04

Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off

Similar Threads
Thread Thread Starter Forum Replies Last Post
bugzilla -> mysql (log user) t0bias Linux - Server 2 10-12-2007 03:23 AM
.htaccess with Basic authentication throws MySQL error in Error Log shailesh_mishra Linux - Security 6 01-17-2007 11:15 AM
Basic authentication with .htaccess throws MySQL error in Error Log shailesh_mishra Linux - Networking 2 01-12-2007 02:16 PM
The mythtvfrontend can't log into MySQL from any other user than the mythtv user! LiquidSlumber Linux - Software 1 03-25-2006 12:04 AM

All times are GMT -5. The time now is 12:56 AM.

Main Menu
Write for LQ is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration