title: Provide simple mysql table administration interface in a hosting environment
body: <p>I have a web portal, consisting of various projects, based on MySQL database. The project administrators need to administrate their tables. I would like to provide them some <strong>already existing, free, simple interface with as cheap setup as possible</strong> (like <strong>10-15 minutes max of my time per each new project - IMPORTANT!</strong> The number of project administrators and their requests grows...). It should support:</p>
  
  <ul>
  <li><em>required:</em> table export, import, insert new row, modify existing rows </li>
  <li><em>not needed, but a plus:</em> foreign keys replaced with some other field value from the foreign table (usualy a "dictionary"), display only certain columns, etc.</li>
  </ul>
  
  <p>The problem is that it is a <strong>hosting environment, so I have no superuser permissions</strong> to the MySQL database. I don't have the grant permission so I must ask my hosting provider to run every <code>grant</code> command, so I want to minimize these requests as it is an above-standard service (it's their grace to me). And these requests would have to be done quite often.</p>
  
  <p>What database administration tools/solutions can I use?</p>
  
  <p>My ideas:</p>
  
  <p>1) <strong>MySQL ODBC connector + MS Access</strong> as a client. The MS Access would connect via ODBC connector to the MySQL server. I can prepare small MS Access file that would contain a link to desired tables, and also quickly generated forms! </p>
  
  <ul>
  <li>This is cool, however, I would need to contact my provider every time to create db user with desired permissions... to prevent users from changing table structure or destroying other tables...</li>
  </ul>
  
  <p>2) <strong>Client -> Proxy -> MySQL server.</strong> Like in 1), but with some proxy. I'm now theorizing, but the Access could also use other protocol (e.g. HTTP) to connect some proxy that would handle the permissions and this proxy would then pass it to MySQL server. Does there exist something like that?</p>
  
  <p>3) <strong>PHPMyADMIN</strong>. The problem from point 1) remains. However, the <strong>permission checking could be theoretically implemented on the PHP level</strong> here, so no need to change any MySQL permissions! Is PHPMyADMIN capable of that, out of the box? Can I simply configure a new user which can only see table A &amp; B and only modify column C, etc.?</p>
  
  <ul>
  <li>However, the import is not much user friendly (no XLS, only CSV, no delimiter autodetection etc.), as well as inserting new records...</li>
  </ul>
  
  <p>4) There are plenty of modern <strong>web tools with spreadsheet-like look like GoogleDocs</strong>. Could these be used for the task. Again, in theory the permission checking could be done at the web-server (not database) layer... and set up easily...  (?)</p>
  
  <p>I'm sure many people had to solve the same issue, so I'm looking forward your experiences and ideas!</p>