How to restart remote MySQL server running on Ubuntu linux?

Question

I'm using Ubuntu 12.04 LTS.

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?

Answer 1

1. SSH into the machine. Using the proper credentials and ip address, ssh [email protected]. This should provide you with shell access to the Ubuntu server.
2. 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

Answer 2

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