I'm using Ubuntu 12.04 LTS on my machine.
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?
- SSH into the machine. Using the proper credentials and ip address,
ssh firstname.lastname@example.org. 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
- How to import data from text file to mysql database
- How to install Debian 9 build-essential offline if standard system utilities weren't installed and there is no c compiler in $PATH
- MYSQL Round the datetime to 15 minute
- How do you connect a OnePlus Two Device to Ubuntu through MTP?
- Inconsistent performance of WHERE and ORDER BY depending on size of WHERE match
- Laravel migration: unique key is too long, even if specified
- Does MySQL Replication hamper the performance of my DB?
- Specify the sort order with LC_COLLATE so lowercase is before uppercase
- MySQL ERROR 1045 (28000): Access denied for user 'bill'@'localhost' (using password: YES)
- mysql_fetch_array()/mysql_fetch_assoc()/mysql_fetch_row()/mysql_num_rows etc… expects parameter 1 to be resource or result