Organizational Research By

Surprising Reserch Topic

Experts Most Trusted Topic


let mysql users create databases but allow access to only their own databases using -'mysql'


let mysql users create databases but allow access to only their own databases  using -'mysql'

I want to have multiple a MySQL users to be able to issue commands like

CREATE DATABASE dbTest;


But I also want each of these users to be able to see and access only their own databases.

All I could find was how to either create the databases by a DBA and grant the privileges on this database to the specific user:

GRANT ALL PRIVILEGES ON dbTest.* TO 'user';


or grant privileges on all databases to a user:

GRANT ALL PRIVILEGES ON *.* TO 'user';


But neither is what I want, because it needs to scale and be secure.
    

asked Sep 7, 2015 by rajesh
0 votes
3 views



Related Hot Questions



Government Jobs Opening


...