LinuxQuestions.org
Review your favorite Linux distribution.
Home Forums Tutorials Articles Register
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Software
User Name
Password
Linux - Software This forum is for Software issues.
Having a problem installing a new program? Want to know which application is best for the job? Post your question in this forum.

Notices


Reply
  Search this Thread
Old 02-03-2004, 12:10 PM   #1
Transition
Member
 
Registered: Aug 2003
Distribution: Slackware 10
Posts: 48

Rep: Reputation: 15
MySQL / phpMyAdmin - Can only see test table after granting proper privelages..


I've got a user - lets say it's called pma. When pma logs into phpMyAdmin he can only see thte test database.. Well - thought it might be a grant issue so i double checked pma's grant permissions..
it says....

GRANT USAGE ON *.* to 'pma' @ 'localhost' IDENTIFIED BY PASSWORD 'password'

I must be doing something wrong since i thought granting global usage will get PMA access to everything?
 
Old 02-03-2004, 12:39 PM   #2
phpjames
LQ Newbie
 
Registered: May 2002
Posts: 11

Rep: Reputation: 0
Make sure the phpMyAdmin is correctly setup. Check the config file and make sure you are defining the database perameters correctly. IE mysql, port, user/pass.db
 
Old 02-03-2004, 12:45 PM   #3
Transition
Member
 
Registered: Aug 2003
Distribution: Slackware 10
Posts: 48

Original Poster
Rep: Reputation: 15
Got it fixed. I had fubared some of the grants apparently. Thanks anyway
 
  


Reply



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
mysql and phpmyadmin jungleking Linux - Newbie 1 09-17-2005 08:07 AM
MySQL - PHP5 - phpMyAdmin 2.6.0 Fuel Linux - Software 2 07-25-2004 01:39 PM
Mysql - phpMyadmin questions paleogryph Linux - Software 1 02-27-2004 12:47 PM
MySQL non-realtime table-by-table mirroring Passive Linux - Software 1 01-20-2004 12:11 PM
How to import MS ACCESS Table including OLE filed into the MySQL Table ? myunicom Linux - General 1 11-28-2003 11:30 AM

LinuxQuestions.org > Forums > Linux Forums > Linux - Software

All times are GMT -5. The time now is 02:33 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