Default Test Database When MySQL is Installed and Started

Question

In most versions of MySQL that I've worked with, there is a default "test" database that is pre-loaded with the performance, information, and mysql databases. I've never seen this database populated. Is it safe to delete this DB or will MySQL use this as a resource in the future?

Something is called test? Shoot first and ask questions later. — Pekka
– Pekka, Commented Dec 1, 2013 at 23:48

Michael - sqlbot · Accepted Answer · 2013-12-02 00:00:01Z

2

Yes, you can delete it... but the fact that you are asking indicates that the installations in question may not have been properly secured and may still also have the anonymous accounts active also. There is an official script to take care of both:

http://dev.mysql.com/doc/refman/5.6/en/mysql-secure-installation.html

answered Dec 2, 2013 at 0:00

Michael - sqlbot

180k28 gold badges388 silver badges458 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Pekka · Accepted Answer · 2013-12-01 23:50:16Z

1

The mySQL manual says:

The test database often is available as a workspace for users to try things out.

that's arguably good enough reason to assume it's safe to remove.

answered Dec 1, 2013 at 23:50

Pekka

451k150 gold badges989 silver badges1.1k bronze badges

Collectives™ on Stack Overflow

Default Test Database When MySQL is Installed and Started

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related