I was trying to use Test-mysqld to see how much it is useful for creating mysqld instances on the fly.
I tried creating a sample database and a table within that and ran using Test::mysqld.
I was able to access database and the table within the same instance of the Test::mysqld, but when i ran another script to just show the contents of the table I created, the sample database and table were not present.
After that I ran mysqld on the system to start persistent mysqld and connected to it using 'mysql' command. Then I issued 'show databases' command and there also that sample table was not showing.
My question is, is this the expected behavior of this module. If yes, then what's its use when you can't access any existing user created database or if anything created using this module instance is not available persistently.