Re: User can see all databases...

2005-12-19 Thread William R. Dickson
OK, I spoke a little too soon. Users can no longer list all databases, which is great. Unfortunately, they also can't list their own, resulting in errors when they log into phpMyAdmin: SQL-query: SHOW DATABASES ; MySQL said: #1045 - Access denied for user: '[EMAIL PROTECTED]' (Using passwor

Re: User can see all databases...

2005-12-19 Thread William R. Dickson
This did the trick. Many thanks. I had found that option, but misinterpreted what I read; I thought it was only available in 4.x. Thanks again! -Bill On Dec 14, 2005, at 6:59 PM, Michael Stassen wrote: William R. Dickson wrote: OK, I strongly suspect I've just done something stupid here, bu

Re: User can see all databases...

2005-12-14 Thread Michael Stassen
William R. Dickson wrote: OK, I strongly suspect I've just done something stupid here, but I'm having trouble figuring it out. I had a disk go bad on a MySQL server this past weekend. I did a clean system install (FreeBSD 5.4) on a new disk, installed the MySQL 3.23 port, and restored the my

User can see all databases...

2005-12-14 Thread William R. Dickson
OK, I strongly suspect I've just done something stupid here, but I'm having trouble figuring it out. I had a disk go bad on a MySQL server this past weekend. I did a clean system install (FreeBSD 5.4) on a new disk, installed the MySQL 3.23 port, and restored the mysql data directory from b