How to create two same name databases in two different mySQL users ? -
i using mysql 5.5 in ubuntu 12.04. have created 2 different users 'root' , 'abc' , want create 'items' database in both user accounts want 2 databases separate.now problem have created 'items' database in root user 10 tables , when trying create new user 'abc' 'items' database comes automatically in new user 10 tables , don't want do.
how can create 2 same name databases in different user accounts different tables in both dbs?
you cannot. database names unique per mysql server. (so cannot have 2 databases same name, different users)
Comments
Post a Comment