Filed under: nnxj.com — rose @ March 15, 2010 edit
Hi there. I am running a server on Redhat 8 with Apache, PHP 4.22 and MySQL as per the default install. I have secured the root account and created a less privileged account for my forums. What I'd like to now be able to do is state that for example, if a user logs into the mysql prompt over telnet and does a "SHOW DATABASES" command, that only the vbulletin database they are associated with would show up. Is this at all possible? What I hope to have is x amount of users each with their own database, that can only ever "see" their own database on the server.You can't have multiple databases for one installation of vB. But there is of course a way to cut priviledges of users so that they are only allowed to view a certain database, read up on GRANT on www.mysql.com .Yes, that is possible with GRANT. You can limit the rights of a user so that he can just see database A, but not B.I didn't mean that, eg, multiple databases, one vB. What I meant was "I'm running a server, I only want each database user to see their own database and nobody else's" - is this possible?Yes, that is possible with GRANT. You can limit the rights of a user so that he can just see database A, but not B.
Thanks, I'm doing that now :)I didn't mean that, eg, multiple databases, one vB. What I meant was "I'm running a server, I only want each database user to see their own database and nobody else's" - is this possible?
read
http://mysql.com/doc/U/s/User_Account_Management.html
http://mysql.com/doc/P/r/Privilege_system.html#If you have any other info about this subject , Please add it free.# |
|
