如何重新启动运行在 Ubuntu linux 上的远程 MySQL 服务器？

我用的是 Ubuntu 12.04 LTS。

在 MySQL 服务器上有一个远程的。我想重新启动它。

有没有人能给我详细的一步一步的指示，重新启动 MySQL 服务器？

以下是我从 phpMyAdmin UI 获得的 MYSQL 的数据库服务器详细信息:

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)

有人能帮帮我吗？

334509 次浏览
小开
最佳答案
  1. 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.
  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

小开

What worked for me on an Amazon EC2 server was:

sudo service mysqld restart
小开 
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

小开

Another way is:

systemctl restart mysql
小开
  • To restart mysql use this command

sudo service mysql restart

Or

sudo restart mysql

Reference

小开

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/

小开

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.

小开

You can simply run from your local terminal
ssh username@www.remoteserver.com -- sudo service mysqld restart


提交答案