Hello, I'm part of a shared hosting environment that uses the above software, and I'd like to create my own databases without having to email the support guy. We've discussed this, and the hoster will allow me to do this, but the sysadmin can't seem to get PHPMyAdmin to allow users of a shared MySQL server to create their own databases. It's kind of fallen on me to figure out how, if I want this feature ;-) I'm a graphic designer and just learning the development issues in PHP/MySQL, so that tells ya how much I know about back-end MySQL admin and privileges --which ain't much <grin>.
This is a RackShack/WEBppliance set up. Has anyone given the rights for a user to create their own databases/users etc with this? We basically need to give all privileges to just me for my own databases and such, and not be able to see or edit the other databases on the system. The syntax/manual is driving us a little nuts--we could use some help :) Someone told us to use GRANT ALL PRIVILEGES ON *.* TO 'testuser'@'localhost', but wouldn't that allow me to do everything to *all* the databases? I just want to do anything I want to my own :) Thanks, and please ask for any info you need to help answer this, I know this is probably pretty inept info. Gina --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php