database information_schema

[Desdinova]

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]

Who created it? Only the test database should exist in a new installation. (With the exlusion of the mysql database)

 

[Desdinova]

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]

That's normal... look at the mysql.com site: http://dev.mysql.com/doc/refman/5.0/en/information-schema.html

 

[pucky]

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]

Old thread I know;

But does anyone knows where that test database is for ? Can I delete without any problems ?

 

[scsi]

Why delete it is it taking too much space from you? LOL it prob uses .00000000001bytes

 

[nieuwhier]

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]

Yeaah let's save some space ;-)
No; it is confusing for some customers.

Don't give them access to it.

 

[nieuwhier]

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]

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.