MySQL Forums
Forum List  »  General

I dont want 'INFORMATION_SCHEMA' db
Posted by: cristian stoica
Date: September 19, 2006 06:06AM

I have installed MySQL 5.x , apache2.2 last php version and phpMyAdmin
I set my root user and password for sql in phpMyAdmin
and I have 3 DBs : "mysql", "test" and "information_schema"
I create a new user(for example COMMA),password (******) and a new db with user name(db name = COMMA) for same user...and I set the permision fos this db (COMMA) with same user (COMMA)
but...when I login with user COMMA & password ***** and I see 2 bd : first db is "COMMA" and second db is "INFORMATION_SCHEMA"

the question is... how can I set the restriction for user COMMA such us this user can see just db with name "COMMA"
I dont want to see db with name "INFORMATION_SCHEMA" for each user.

Options: ReplyQuote


Subject
Written By
Posted
I dont want 'INFORMATION_SCHEMA' db
September 19, 2006 06:06AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.