Create MariaDB windows service using sc command

Sometimes I’d had difficulty manually creating service in windows, especially mariadb or mysql. Here it is how to do it

sc create "maria55" binpath= "\"d:/var/apps/Maria-10.1.22-x64/bin/mysqld\" \"--defaults-file=d:/var/mysql/conf/mysql-99.ini\" maria55" DisplayName= "Maria55" start= "auto"
sc create [ServiceName]

mysqld bin location: d:\var\apps\Maria-10.1.22-x64\bin
configuration: d:\var\mysql\conf\mysql-99.ini

To delete service

sc delete [ServiceName]