How to restart remote MySQL server running on Ubuntu linux?
MysqlLinuxUbuntuRestartDatabase ServerMysql Problem Overview
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?
Mysql Solutions
Solution 1 - Mysql
- 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. - Restart the mySQL service.
sudo service mysql restartshould 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
Solution 2 - Mysql
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
Solution 3 - Mysql
Another way is:
systemctl restart mysql
Solution 4 - Mysql
Solution 5 - Mysql
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/
Solution 6 - Mysql
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.
Solution 7 - Mysql
You can simply run from your local terminal
ssh [email protected] -- sudo service mysqld restart
Solution 8 - Mysql
What worked for me on an Amazon EC2 server was:
sudo service mysqld restart