[MDEV-27764] test database is not installed Created: 2022-02-07 Updated: 2022-05-01 |
|
| Status: | Open |
| Project: | MariaDB Server |
| Component/s: | Platform Windows |
| Affects Version/s: | 10.6 |
| Fix Version/s: | N/A |
| Type: | Bug | Priority: | Minor |
| Reporter: | Christopher Yeleighton | Assignee: | Ian Gilfillan |
| Resolution: | Unresolved | Votes: | 0 |
| Labels: | installer | ||
| Environment: |
Windows installer |
||
| Description |
|
The MariaDB Primer says:
Well, it does not. There is no test database installed by default |
| Comments |
| Comment by Ian Gilfillan [ 2022-02-07 ] |
|
Thanks - I've added a note that some setups remove the test database by running mysql_secure_installation. Was this the case in your setup? Please clarify the version and how MariaDB was installed. |
| Comment by Christopher Yeleighton [ 2022-02-12 ] |
|
I do not think anything has removed the test database. The installer just does not create it under Microsoft Windows. There is no option to skip creating it. It would help if you could tell us how to create it by hand. |
| Comment by Sergei Golubchik [ 2022-03-21 ] |
|
what MariaDB version was it? |
| Comment by Christopher Yeleighton [ 2022-03-21 ] |
|
10.6 |
| Comment by Vladislav Vaintroub [ 2022-03-23 ] |
|
as for Windows installer, the "test" database was removed by the commit 9a8498066865b508239b36853403f2700800af2b |
| Comment by Christopher Yeleighton [ 2022-03-23 ] |
|
Microsoft Windows desktop installer should have the option to install the test database provided as a configuration step. Whether it should be enabled by default is a matter of discussion. I say it should be on because it is a breaking change. |
| Comment by Vladislav Vaintroub [ 2022-03-24 ] |
|
I tend to think that we do not really need that database, and option. For the last 4 years, it did not bother anyone, so the status quo is "no test database". The added value of this option is truly minimal. MariaDB Primer was already changed to say it is not created on Windows, and it documents "CREATE DATABASE IF NOT EXISTS test; USE test;" too. |
| Comment by Christopher Yeleighton [ 2022-03-24 ] |
|
CREATE DATABASE is not enough, the test database must be unprotected. |
| Comment by Ian Gilfillan [ 2022-03-28 ] |
|
Clarified that the db_name can be left out. yecril71pl what do you mean by "the test database must be unprotected"? |
| Comment by Christopher Yeleighton [ 2022-03-29 ] |
|
Anybody is allowed to do anything in the test database. |