Running MYSQL/MariaDB Commands Remotely

Some remote Administration consoles will only allow running a command without output for a few seconds before terminating it, So running mysql updates with the -p and entering the password after the command is not possible.


"C:\Program Files\MariaDB 10.1\bin\mysql.exe" -u root -p12345678 geolog -e "Update `data` set `state`='TX' where `id`=16206;"

make sure the password ,{12345678} here, is touching the -p if there is a space in it it will not work.