How to navigate to MySQL prompt using cmd without setting environment variable or without navigating MySQL service folder in Windows

Question

I want to run bat file in mysql prompt automatically in all computers without setting environment variable path.

I am using Xampp server,but some of my friends using Wampp and MysqlServer. However I want to run my sql commands by running a .bat file.So I want to navigate to the MySql> prompt first.

I tried following CMD command to find the service,

tasklist /svc >mysqld.exe

but I can't navigate to mysql>

Help me if someone has any solution. Thanks.

Answer 1

This would do the trick:

for /f "tokens=3 skip=3" %a in ('tasklist /svc /fi "imagename eq mysqld.exe"') do @cmd /c sc qc %a ^| findstr PATH