LinuxQuestions.org
Welcome to the most active Linux Forum on the web.
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 04-13-2012, 12:56 PM   #1
snooze1
Member
 
Registered: Sep 2011
Posts: 34

Rep: Reputation: Disabled
phpMyAdmin not allowing logins from users setup to specific databases.


I recently installed phpMyAdmin with MySQL, it works fine, allows the root to login via the website, but when I attempt to create users and give assign them to a database, it gives me the error "#1045 Cannot log in to the MySQL server". This server is running on CentOS 5.8.

MySQL is installed correctly, it lets me login with root perfectly fine, cookie auth is on, blowfish secret set, etc, etc.
 
Old 04-13-2012, 01:24 PM   #2
snooze1
Member
 
Registered: Sep 2011
Posts: 34

Original Poster
Rep: Reputation: Disabled
I setup a user to test it via commandline.

Originally the user 'jeffrey' had the host as any host '%', but when changing it to localhost it seemed to of worked, is it possible that I can allow remote logins?

Quote:
[root@vm phpmyadmin]# mysql -u jeffrey -pabc
ERROR 1045 (28000): Access denied for user 'jeffrey'@'localhost' (using password: YES)
[root@vm phpmyadmin]# mysql -u jeffrey -p
Enter password:
ERROR 1045 (28000): Access denied for user 'jeffrey'@'localhost' (using password: YES)
[root@vm phpmyadmin]# mysql -u jeffrey -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 245
Server version: 5.5.22-cll MySQL Community Server (GPL) by Atomicorp

Copyright (c) 2000, 2011, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql>
 
Old 04-13-2012, 01:25 PM   #3
snooze1
Member
 
Registered: Sep 2011
Posts: 34

Original Poster
Rep: Reputation: Disabled
Solved.
 
Old 04-14-2012, 05:06 AM   #4
linuxlover.chaitanya
Senior Member
 
Registered: Apr 2008
Location: Nagpur, India
Distribution: Cent OS 5/6, Ubuntu Server 10.04
Posts: 4,629

Rep: Reputation: Disabled
It would be nice to list your solution here so that other members coming here with same issue can find it outright. Also mark your thread as SOLVED using thread tools.
 
Old 04-14-2012, 05:07 AM   #5
snooze1
Member
 
Registered: Sep 2011
Posts: 34

Original Poster
Rep: Reputation: Disabled
For some reason I needed to create two users for the one DB, one with any hostname and one with the hostname as localhost.
 
  


Reply


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
LXer: Administrate Databases Over the Web With phpMyAdmin LXer Syndicated Linux News 0 04-24-2011 11:20 AM
Tying WinSCP logins to specific directory tiedyeguy64 Linux - Software 1 02-16-2011 12:01 PM
phpmyadmin - show databases melkoraton Linux - Software 3 06-23-2010 12:32 PM
phpMyAdmin - Allow Users to create Databases blizunt7 Linux - Server 2 10-10-2007 06:00 AM
Allowing the creation of MYSQL databases by a user rustyz82 Linux - Software 5 06-26-2006 01:11 AM

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

All times are GMT -5. The time now is 07:12 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
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration