CODEWITHSUNDEEP
mysqllinuxubunturestartdatabase-server
PHPLover
PHPLover

Reputation: 12957

How to restart remote MySQL server running on Ubuntu linux?

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?

Upvotes: 99

Views: 399050

Answers (8)

Dimitris
Dimitris

Reputation: 21

You can simply run from your local terminal
ssh [email protected] -- sudo service mysqld restart

Upvotes: 0

MARZAG EL ALAOUI Hassan
MARZAG EL ALAOUI Hassan

Reputation: 1

I have had a problem with my WordPress site, the connection with MySql has gone away, and to get it back I had to restart the server. This has been an annoying issue as I do not have that high traffic on the site.

I tried to check if MySQL is up and make the cronjob restart it but that does not work that well. I have been looking at the log, using.

tail /var/log/mysql/error.log

In the log, I looked for shutdown messages or errors. I identified that the MySQL connection crashed when the server run out of memory, so why did it run out of memory. I started to optimize Mysql resources by using the optimization tool from Percona tools.

I also checked when my WordPress is running smoothly or what is causing heavy traffic peaks to your DB. One way is to increase the size of the server, I did not have that much traffic, so I installed the New Relic tool on my server to monitor the server resources to find out which processes are consuming memory.

I found out that the server did not have enough memory and MySQL can’t allocate what it needs so it crashes, what I did was add swap space to help this.

here is the method to Add Swap Space
https://www.digitalocean.com/community/tutorials/how-to-add-swap-space-on-ubuntu-16-04

If that's not enough, you may need to consider upgrading to a larger server. Either way, you should take a closer look at your memory consumption to better understand the problem.

Upvotes: 0

Web Dev guy
Web Dev guy

Reputation: 41

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/

Upvotes: 0

Jonathan Plackett
Jonathan Plackett

Reputation: 2426

What worked for me on an Amazon EC2 server was:

sudo service mysqld restart

Upvotes: -2

felixmpa
felixmpa

Reputation: 2128

Another way is:

systemctl restart mysql

Upvotes: 27

Ayman Elshehawy
Ayman Elshehawy

Reputation: 2964

  • To restart mysql use this command

sudo service mysql restart

Or

sudo restart mysql

Reference

Upvotes: 5

Ram Neduri
Ram Neduri

Reputation: 448

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

Upvotes: 28

Huey
Huey

Reputation: 5220

  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

Upvotes: 195

Related Questions