MySQL and PHPMyAdmin


#1

Just want to make sure that I get this straight. You cannot create databases or users from the PHPMyAdmin panel, only from the DH Control Panel, is that correct? Also, can you create more than one database per domain or subdomain. For example, if I have a database for a wiki at blah.blah.com/blah1, could I install another wiki at blah.blah.com/blah2 using a seperate database? Or do I have to create a subdomain blah2.blah.com to make a new database?

Chris


#2

You can’t create new databases from phpMyAdmin. You have to use the control panel.

You can have as many databases you want and you do not have to create additionally subdomains. The only limitation is that the database servers is shared between users so you can’t add a database with a name that is already occupied.


#3

So for every database that I would create, I would have to make a new user for it?


#4

You could, but you don’t need to create more than one user to have unlimited databases.


#5

this is the way it works.

you need at least one user for one database server. for example, user1 for mysql.domainname.com

you can have more than one databases in the same server. for example, database1 and database2 in mysql.domainname.com

therefore, if you create new databases in the same database server, you don’t have to create a new user for it.

Save [color=#CC0000]$97[/color] (max discount) on dreamhost by using promo code: [color=#CC0000]97CRAZY[/color].