PDA

View Full Version : database information_schema


Desdinova
03-17-2006, 01:20 AM
At every databaseaccount I have, there's a database called 'information_schema' and 'test', and a database created by myself.

I don't really care about the 'test' database, but the 'information_schema' might be something I'd rather have removed. Is this possible? What's it doing there anyway?
jmstacey
03-17-2006, 11:50 AM
Who created it? Only the test database should exist in a new installation. (With the exlusion of the mysql database)
Desdinova
03-18-2006, 12:33 AM
It was created with the admin account (reseller level -> add user), then I just hit 'login as this user' and go to mysql administration and add a new database.
Pascal
03-19-2006, 07:11 AM
That's normal... look at the mysql.com site: http://dev.mysql.com/doc/refman/5.0/en/information-schema.html
pucky
10-16-2006, 10:25 AM
Originally posted by Pascal
That's normal... look at the mysql.com site: http://dev.mysql.com/doc/refman/5.0/en/information-schema.html

Information_scheme may be normal under v5 but what about test db?

My users can see a test db with Zero records in the db under phpmyadmin. It appears as test and nothing more. No extension, nothing. When i look in /home/mysql there it is. Shows only test.
nieuwhier
01-14-2009, 07:35 AM
Old thread I know;

But does anyone knows where that test database is for ? Can I delete without any problems ?
scsi
01-14-2009, 08:59 AM
Why delete it is it taking too much space from you? LOL it prob uses .00000000001bytes
nieuwhier
01-14-2009, 09:58 AM
Why delete it is it taking too much space from you? LOL it prob uses .00000000001bytes

Yeaah let's save some space ;-)
No; it is confusing for some customers.
floyd
01-14-2009, 10:55 AM
Yeaah let's save some space ;-)
No; it is confusing for some customers.

Don't give them access to it.
nieuwhier
01-14-2009, 11:00 AM
Don't give them access to it.
It is in each standard DA installation available. I would like to know why and if it hurts when I remove it.
floyd
01-14-2009, 11:23 AM
I was commenting on how to keep your users from being confused, not why it exists or if there is any harm in deleting it.

I know mytop at least used to connect to the test database when run. In doing some research just now that may have been fixed. But I am still not sure. mytop may still require it unless you specify another default database for it to connect to.