Home / server / Questions / 341371
In Process
Elgoog
Asked: 2011-12-16 13:10:30 +0800 CST

How would I set up mysql db hosting

  • 772

I have a VPS and have set up vhosts so I cant host websites, im wanting to give each user the ability to create there own db within mysql, I have phpmyadmin installed so can login to that to view the db's, but I want the 'user' to be able to log in and only see there databases. what is the best way of dealing with this? thanks

mysql web-hosting

2 Answers

  1. If I remember well the user only sees the databases in phpmyadmin what he/she has rights.

    • 1

  2. Use phpmyadmin: execute the GRANT query within the phpmyadmin query tab, repeat this process for other hosts you want to grant access for.

    Edit the config.inc file for your controlled users granted access by the MYSQL GRANT query. Essentially what you are doing is provided segmented access, and seperate Login and permissions for users you specify. see the following link for more info: click this!

    • 0