What is that 'test' database?

General Web Coding PHP and MySQL
1

Each time I create the new MySQL DB from HSphere CP it creates extra ‘test’ database. I cannot remove it with ‘DROP DATABASE test’ query. What’s up with that? Is it on purpose or it is some sort of glitch? I didn’t see that ‘test’ db appearing on its own at another HSphere based host. Can someone explain that?

2

[QUOTE=cnisvcs]
Each time I create the new MySQL DB from HSphere CP it creates extra ‘test’ database. I cannot remove it with ‘DROP DATABASE test’ query. What’s up with that? Is it on purpose or it is some sort of glitch? I didn’t see that ‘test’ db appearing on its own at another HSphere based host. Can someone explain that?
[/QUOTE]

At my other HSphere host, it shows up as well. Not sure what it is. Glad you asked though, as I have always wondered.

3

it is a system-wide test database that everyone has access to :slight_smile:

4

What is its purpose?

5

To test :slight_smile: (or to make you ask questions :smiley: )

6

OK, so I added a table into that ‘test’ DB. Just for a heck of it. Can everybody see it? What is its name?

7

Everyone could see it, but I am not logged in to tell you the name of it :slight_smile:

8

Excuses, excuses, excuses… :smiley:

So, I see how it works, but still: what a heck is for? When you need to test - you create a db, when you are done with it - you delete it. Anyways, not a big deal…