Need to start the MySQL service from XAMPP with Java Code.(Without manually using the XAMPP console to start it).
I know you could use:
Process process = Runtime.getRuntime().exec("net START MySQL");
To start the MySQL in windows. But it seems XAMPP has MySQL as a subprogram (If I am right).
Any advice please?
This depends on the path where you have installed XAMPP. You can set MySQL server as an Autostart module in the XAMPP and then you can run
(Assuming you having XAMPP installed in default path)
Process process = Runtime.getRuntime().exec("C:\\xampp\\xampp_start.exe");
This may not be the easiest way but this will work. But also you should know that mysql is stored separately in XAMPP path as in C:\xampp\mysql\bin. So you can also run
Process process = Runtime.getRuntime().exec("C:\\xampp\\mysql\\bin\\mysqld.exe");
Hope this will help you.
This is the simple way get the path where your xampp server is install. Then simply write this command in you main class constructor
Process xamppProcess=Runtime.getRuntime().exec("Path\\xampp_start.exe");
After this command write this command to connect to your Mysql database also get the saved path of mysql from your computer
Process db=Runtime.getRuntime().exec("sqlpath\\mysqld.exe");
this is it hope it work for you!!!
