Hi,
When login i must waiting for log, long time until my browser finished uploading 300 users on screen.

On screen:
user1
user2
user3
user4
user5
user6
....
.....
.......
.....
etc

My question is, how to modified my scripts so i only login to my own database and not see other user on screen ??

NB: my ISP only allowed one datadase per user.

Regards
Rudy

Your sys admin will have to make changes in the MySQL configuration files to enhance security in the MySQL server to disallow access to other user's databases. I posted this same problem about a month ago in this forum.

Alex only recommended that I contact my hosting company. I did and they have not fixed it. Thank goodness that there are not a lot of clients on their servers that are using MySQL databases.



Regards,

Eliot Lee

Hi Rudy,

Actually, there is a solution to by-pass this.
I take it Eliot must not have heard about it. :)

Have a look here: http://www.gossamer-threads.com/p/85036/

Is that what you wanted?

Robert Blackstone
Webmaster of Scato Search
http://www.scato.com

Thanks a lot!!

Hi Rudy,

Your Welcome. :)
BTW... Did it work for you?

Robert Blackstone
Webmaster of Scato Search
http://www.scato.com

Uh...that is NOT a solution...I tried that and also the newest version of MySQLMan has these codes included...and guess what when after logging and accessing my tables, ALL other user's tables show up. It is a security measure that must be implemented in the ROOT in the MySQL configuration files BY the sys admin!

Regards,

Eliot Lee

Yeah, you right Lee. The script still not working; maybe i let my ISP to fix their server in the future.
Thanks

Hi,

Both of you are right, I mis-understood the question.
:)



Robert Blackstone
Webmaster of Scato Search
http://www.scato.com

There are two things, quite often it's possible to view other databases, but if you clikc on any database you will get an access denied. This is acceptable (not perfect, but ok).

However if you can click on any of the other databases and view the tables inside them, then your ISP has not set up mysql properly and I wouldn't put any sensitive data inside your mysql tables. Assume everyone can view all the data (i.e. someone could easily right a cgi script to make all your data viewable from the web).

That said, if you can't view the tables, and you just want to skip the show database screen, then enter in your database connection info in the config file.

Cheers,

Alex


--
Gossamer Threads Inc.