How to restart remote MySQL server running on Ubuntu linux?

mysql linux ubuntu restart database-server
PHPFan picture PHPFan · May 7, 2015 · Viewed 242.6k times · Source

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.

Answer

Huey picture Huey · May 7, 2015
  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

Related questions

error: 'Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)' -- Missing /var/run/mysqld/mysqld.sock

My problem started off with me not being able to log in as root any more on my mysql install. I was attempting to run mysql without passwords turned on... but whenever I ran the command # mysqld_safe --skip-grant-tables & …

Read More
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)

I am an electrical engineer who mainly plays around with power systems instead of programming. Recently, I have been following a manual to install a software suite on Ubuntu. I have no knowledge of mySQL at all, actually. I have …

Read More
How to test which port MySQL is running on and whether it can be connected to?

I have installed MySQL and even logged in there as a user. But when I try to connect like this: http://localhost:3306 mysql://localhost:3306 Neither works. Not sure if both are supposed to work, but at least one of them …

Read More