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
