By the way, the “systemctl stop mysql” code is implemented in the python source code. If I’m using in the terminal or putty, its succeed… but by implementing it in the python source code for the telegram bot that been integrated with the server itself, it cant be done…
:- Ubuntu server 16.04 :- Wordpress 4.7 :- Windows 8.1 :- Python Source Code :- Telegram application for Android 6.0
Source code is:
def stop_mysql(self, stop_mysql): stop = “systemctl stop mysql” if stop_mysql == “/mysql_stop”: process = subprocess.Popen(stop.split(), stdout=subprocess.PIPE, shell=True) output = “MySQL Stop: \n” + process.communicate()[0] else: print “Debug message: nothing to do :&(” return output
@superdevop it seems that this code “mysqladmin -u’root’ -p’Password’ shutdown” sent me a bad request (400) in bot… “sudo /etc/init.d./mysql stop”, i have done this but still not actions taken… if my password wordpress same as mysql, can i made it?
Just a wild guess. can you use full path to mysql like /etc/init.d./mysql stop better way of doing this to issue mysqldmin to shut itself. this is the finest and safest way of shutting down mysql without any data crashes
mysqladmin -u’root’ -p’Password’ shutdown
this will definitely work.