My new domain, with many sub_domains, each needing to access and individually administer the sub_domains unique data, will grow beyond the maximum number (50) of Mysql databases allowed by the ISP per domain. What are the trade offs between combining all sub_domains data into one database or using a unique database for each sub_domain.

While it would be possible to include a field in one database that carried an identifier for each sub_domain, I think trying to have this combined setup managed by a different adminitrator for each sub_domain would be very difficult.

What are the collective thoughts on how to handle this problem.

Frodocyber

Not really difficult,

give the tables for each sub a prefix eg sub1_table1, sub2_table1 etc then when each admin logs in only those tables for that sub are visible.

Thanks Chrishirst. Does anyone know of a Mysql administration tool, other than phpMyAdmin? My Isp only allows the main domain webmaster to use phpMyAdmin. Sub_domain administrators must use some other tool.

The only functions I want the sub_domain administrators to be authorized to perform is Add, Update, Delete members (rows), Create table entries for new usernames and passwords, and review and approve new uploaded files for read-only access by users (both public and/or members only). The sub_domain administrators will have no access to database structures or be able to create or drop databases or tables.

Does anyone know of a Mysql adminisration tool that would permit such limited database management either free or fee based?

Frodocyber

Create a different user name for the subdomain users. If you could login ssh intotthe console, use th grant comment. If you can't do it, you could also use phpmyadmin to exeucte the grant comment. To look further in the mysql rights system. It is divided between host and user. You can define what host to have access by what user. So you have full control of how and who to access to what table and database.

simplest way would be to write a limited function control panel for the admins to login to, this will then only have the functions that are written into it and the permissions that allowed for each of the admin users.

the majority of MySQL admin tools around are designed for admin of the whole server or a specific database not groups of tables

Thanks for the limited control panel idea Chrishirst!

I have solved part of the problem by creating an admin control panel limited to add, update, delete, and register new user. I reserved to myself the rights to register the first user, which would be the administrator, giving access to the control panel. All the sub-domains will be identical except for the administrator, national language, and database content and I can administer all databases using phpMyadmin with full rights.

I do not want to combine multiple sub-domains into one database. The remaining problem is the limit of 50 Mysql databases per domain. There is time to work on a solution since it may take a year before over 50 chapters subscribe to this website. May have to have a hard chat with the hosting ISP management about this 50 limit.

All suggestions encouraged.

Frodocyber

dedicated server or co-located server then you can have as many as you want