phpMyAdmin can't show multiple DBs [Q and A] - XOOPS Web Application System

phpMyAdmin can't show multiple DBs

2004/11/17 19:48
dejadingo
Just popping in
Posts: 71
Since: 2004/10/22

With phpMyAdmin 2.6.0-pl1 and MySQL 4.0.18-nt running on localhost as root@localhost, I can only get it to show me the first database I created.

This is a test server I use for several sites I'm building/managing and I now have several databases. It was a minor annoyance until now, but I really need to look into the table contents of the newest database I created.

Anyone have any ideas?
Thanks.

Re: phpMyAdmin can't show multiple DBs

2004/11/17 21:28
skenow
Home away from home
Posts: 993
Since: 2004/11/17

There is an option in config.inc.php for phpmyadmin that can restrict which db's are available. You'll find the file in the phpmyadmin directory. Search for 'only_db', the file is pretty well commented so you should be able to get it going from there.

Re: phpMyAdmin can't show multiple DBs

2004/11/17 21:58
Dave_L
XOOPS is my life!
Posts: 2277
Since: 2003/11/7

In addition to what skenow said, it could also depend on what kind of authorization setting you're using for phpMyAdmin. For example, with cookie authorization, the databases visible depend on who you log in as, and what the grants of that user are.

Re: phpMyAdmin can't show multiple DBs

2004/11/18 17:30
dejadingo
Just popping in
Posts: 71
Since: 2004/10/22

Fantastic!
Works great - thanks.

Stats
Goal:	$100.00
Due Date:	Nov 30
Gross Amount:	$0.00
Net Balance:	$0.00
Left to go:	$100.00

phpMyAdmin can't show multiple DBs

Re: phpMyAdmin can't show multiple DBs

Re: phpMyAdmin can't show multiple DBs

Re: phpMyAdmin can't show multiple DBs

Login

Search

Recent Posts

Re: Captcha to the registration form

XOOPS MyMenus 1.54.0 Beta 10

Re: XOOPS MyMenus 1.54.0 Beta 7

Re: XOOPS MyMenus 1.54.0 Beta 7

Re: XOOPS MyMenus 1.54.0 Beta 7

Re: XOOPS MyMenus 1.54.0 Beta 7

Re: XOOPS MyMenus 1.54.0 Beta 7

Re: XOOPS MyMenus 1.54.0 Beta 7

Re: XOOPS MyMenus 1.54.0 Beta 7

Re: XOOPS MyMenus 1.54.0 Beta 7

Who's Online

Donat-O-Meter

Latest GitHub Commits

{{ record.sha.slice(0, 7) }} - {{ record.commit.message | truncate }}