MySql Database IN VB.NET 2010

Question

I am using MySql5.7 in VB.NET 2010. I want to create another data directory other than system data directory through vb.net dynamically on other drivers and also create a database at the newly created data directory and tables are also created at runtime.

 

When we install MySQL server it installs on os drive and the database are stored on program data/mysql5.7/data. This is the default dir but I want another data dir other than default dir and that is not on os drive.

When we install MySQL server it installs on os drive and the database is stored on program data/mysql5.7/data. This is the default dir but I want another data dir other than default dir and that is not on os drive.