How to restart remote MySQL server running on Ubuntu linux

Question

I m using Ubuntu 12 04 LTS on my machine   There is on MySQL server situated remotely  I want to restart it   Can someone please give me in detail step-by-step instructions to restart the MySQL server   Following are the Database server details of MYSQL I got from phpMyAdmin UI   Server  Localhost via UNIX socket Server type  MySQL Server version  5 5 40-0ubuntu0 14 04 1 -  Ubuntu  Protocol version  10 User  root localhost Server charset  UTF-8 Unicode  utf8    Can someone please help me   Thanks

User · Answer

What worked for me on an Amazon EC2 server was   sudo service mysqld restart

User · Answer

To restart mysql use this command       sudo service mysql restart      Or      sudo restart mysql   Reference

User · Answer

SSH into the machine  Using the proper credentials and ip address  ssh root 128 0 0 1  This should provide you with shell access to the Ubuntu server  Restart the mySQL service  sudo service mysql restart should do the job    If your mySQL service is named something else like mysqld you may have to change the command accordingly or try this  sudo  etc init d mysql restart

User · Answer

Another way is   systemctl restart mysql

User · Answer

sudo service mysql stop  sudo service mysql start    If the above process will not work let s check one the given code above you can stop Mysql server and again start server

User · Answer

I SSH ed into my AWS Lightsail wordpress instance  the following worked  sudo  opt bitnami ctlscript sh restart mysql I learnt this here  https   docs bitnami com aws infrastructure mysql administration control-services

[mysql] How to restart remote MySQL server running on Ubuntu linux?

Examples related to mysql

Examples related to linux

Examples related to ubuntu

Examples related to restart

Examples related to database-server