如何重启在Ubuntu Linux上运行的远程MySQL服务器?

问题描述

我在计算机上使用Ubuntu 12.04 LTS.

I'm using Ubuntu 12.04 LTS on my machine.

MySQL服务器位于远程.我想重新启动它.

There is on MySQL server situated remotely. I want to restart it.

有人可以给我详细的分步说明来重新启动MySQL服务器.

Can someone please give me in detail step-by-step instructions to restart the MySQL server.

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

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)

有人可以帮我吗?

谢谢.

推荐答案

1. SSH进入计算机.使用正确的凭据和IP地址ssh [email protected].这应该为您提供对Ubuntu服务器的Shell访问.
2. 重新启动mySQL服务. sudo service mysql restart应该做得到.

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.

如果您的mySQL服务被命名为mysqld之类的其他名称，则可能必须相应地更改命令或尝试执行以下操作:sudo /etc/init.d/mysql restart

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

这篇关于如何重启在Ubuntu Linux上运行的远程MySQL服务器?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！