MySQL

Moderators: Jonathan
Number of threads: 266
Number of posts: 525

This Forum Only
Post New Thread
Single Post View       Linear View       Threaded View      f

Report
grant access to only one db via shell script Posted by Souldrinker on 27 Sept 2002 at 8:08 AM
hi there,

I have to write some ISP-tools to allow users to register on a webserver, now I want them to be able to create ONE database (better said: a script generates it). I create the directory for the database and change the permissions, so it should work.

After doing that I insert the db with user into the mysql->db table, now he should be able to work with his db - but it does not work, does anyone have a clue 'bout this?
best regards,

sebastian mohrenstecher
executive secretary
net::allies

www.net-allies.de
info@net-allies.de
Report
Re: grant access to only one db via shell script Posted by jcarlsson on 16 Oct 2002 at 9:54 AM
: After doing that I insert the db with user into the mysql->db table, now he should be able to work with his db - but it does not work, does anyone have a clue 'bout this?
: best regards,

did you create the directory with mkdir or anything like that? you should create the database with the help of mysql, not using mkdir or anything, do as you do when you create a database following the mysql documentation and then you just say that the user that the person you created it for should have all rights on it
--
jcarlsson <jcarlsson@linux.nu>
http://www.jcarlsson.tk




 

Recent Jobs

Official Programmer's Heaven Blogs
Web Hosting | Browser and Social Games | Gadgets

Popular resources on Programmersheaven.com
Assembly | Basic | C | C# | C++ | Delphi | Flash | Java | JavaScript | Pascal | Perl | PHP | Python | Ruby | Visual Basic
© Copyright 2011 Programmersheaven.com - All rights reserved.
Reproduction in whole or in part, in any form or medium without express written permission is prohibited.
Violators of this policy may be subject to legal action. Please read our Terms Of Use and Privacy Statement for more information.
Operated by CommunityHeaven, a BootstrapLabs company.