LinuxQuestions.org
Review your favorite Linux distribution.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Newbie
User Name
Password
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!

Notices


Reply
  Search this Thread
Old 03-16-2013, 10:07 AM   #1
kcmohan
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, 08:00 AM   #2
blue_print
Member
 
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.

http://dev.mysql.com/doc/refman/4.1/...unt-names.html
 
Old 03-25-2013, 09:43 AM   #3
kcmohan
LQ Newbie
 
Registered: Aug 2012
Posts: 3

Original Poster
Rep: Reputation: Disabled
Question

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, 09:53 AM   #4
guru.novice
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, 09:57 AM   #5
kcmohan
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, 04:39 AM   #6
eklavya
Member
 
Registered: Mar 2013
Posts: 636

Rep: Reputation: 142Reputation: 142
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;

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


Reply

Tags
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 02:23 AM
.htaccess with Basic authentication throws MySQL error in Error Log shailesh_mishra Linux - Security 6 01-17-2007 10:15 AM
Basic authentication with .htaccess throws MySQL error in Error Log shailesh_mishra Linux - Networking 2 01-12-2007 01:16 PM
The mythtvfrontend can't log into MySQL from any other user than the mythtv user! LiquidSlumber Linux - Software 1 03-24-2006 11:04 PM

LinuxQuestions.org > Forums > Linux Forums > Linux - Newbie

All times are GMT -5. The time now is 11:04 PM.

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