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?
The database server details for MYSQL that I acquired from the phpMyAdmin UI are as follows:
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)
Could someone please assist me?
Asked by PHPFan
If your mySQL service is named something else like mysqld you may have to change the command accordingly or try this: restart mysql sudo /etc/init.d/mysql
Answered by Huey
sudo service mysql stop; sudo service mysql start;
If the preceding procedure does not work, use the code provided above to stop and restart the MySQL server.
Answered by Ram Neduri
Another way is:
systemctl restart mysql
Answered by felixmpa
Answered by Ayman Elshehawy
When I SSH’d into my AWS Lightsail wordpress instance, I was able to do the following: restart mysql sudo /opt/bitnami/ctlscript.sh This is what I discovered here: https://docs.bitnami.com/aws/infrastructure/mysql/administration/control-services/
Answered by Web Dev guy
Post is based on https://stackoverflow.com/questions/30101555/how-to-restart-remote-mysql-server-running-on-ubuntu-linux