What you can and can't do with phpMyAdmin may depend on your host. phpMyAdmin itself does have the ability to create databases. However, that ability is determined by the access rights of the user you access the MySQL server with. If your host controls the creation of that user, they may puposely restrict your access rights to dissallow the creation of additional databases. I had this very problem with an old host of mine. I was given one database and that was it. I could not create any more.
Now, my current host (www.webprosinc.net) works a bit different. It is using Plesk, which takes over the responsibility of creating databases and users. The users that it creates do not have the ability to create additional databases, though just about all other access rights are granted (at the database level). This gives the Plesk software absolute control over the MySQL server while still allowing me to create new databases. So, I would make sure your host allows you to create additional databases before you try to get phpMyAdmin to do it. If this is an important feature and your current host does not allow it, there are several other hosts (mine included) that do give that access (usually with some restrictions, of course). --- Seairth Jacobs [EMAIL PROTECTED] "Steve Jackson" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > I am new to MySQL and PHP. > Having looked at PHPMyAdmin the GUI I was wondering if it's possible to > create a new database within the system? > If so what are the commands? I ask because I only have one database on my > server and don't want to populate it with different tables, I'd rather have > seperate ones for seperate functions.. Ideas or advice? is the way I am > suggesting better or worse than the way my hosting company expects me to > work? > Thanks in advance. > Steve. > -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
