How to restart remote MySQL server running on Ubuntu linux?

  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.

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

Related Posts:

  1. ERROR 1045 (28000): Access denied for user ‘root’@’localhost’ (using password: YES)
  2. ERROR 1045 (28000): Access denied for user ‘root’@’localhost’ (using password: YES)
  3. ERROR 1045 (28000): Access denied for user ‘root’@’localhost’ (using password: YES)
  4. error: ‘Can’t connect to local MySQL server through socket ‘/var/run/mysqld/mysqld.sock’ (2)’ — Missing /var/run/mysqld/mysqld.sock
  5. error: ‘Can’t connect to local MySQL server through socket ‘/var/run/mysqld/mysqld.sock’ (2)’ — Missing /var/run/mysqld/mysqld.sock
  6. MySQL config file location – redhat linux server
  7. How to configure WordPress Database for CentOS 7
  8. 403 Forbidden home on localhost with nginx server
  9. What is the debian-sys-maint MySQL user (and more)?
  10. apt-get error: Sub-process /usr/bin/dpkg returned an error code (1)
  11. MySQL error 2006: mysql server has gone away
  12. Which MySQL data type to use for storing boolean values
  13. “INSERT IGNORE” vs “INSERT … ON DUPLICATE KEY UPDATE”
  14. “sed” command in bash
  15. #1273 – Unknown collation: ‘utf8mb4_unicode_520_ci’
  16. MySQL: Access denied for user ‘test’@’localhost’ (using password: YES) except root user
  17. Host ‘xxx.xx.xxx.xxx’ is not allowed to connect to this MySQL server
  18. WSL – GEDIT Unable to init server: Could not connect: Connection refused
  19. PHP Deprecated: Methods with the same name as their class will not be constructors in a future version of PHP
  20. mysql Foreign key constraint is incorrectly formed error
  21. Uncompress tar.gz file
  22. Selecting data from two different tables without using joins
  23. Difference between VARCHAR and TEXT in MySQL
  24. MySQL: Invalid use of group function
  25. How can I loop through all rows of a table? (MySQL)
  26. How to avoid MySQL ‘Deadlock found when trying to get lock; try restarting transaction’
  27. Simple Random Samples from a Sql database
  28. What does SQL clause “GROUP BY 1” mean?
  29. LAST_INSERT_ID() MySQL
  30. SQL select only rows with max value on a column
  31. Trying to perform MINUS operation in MySQL
  32. How do I find the MySQL my.cnf location
  33. How do I find which transaction is causing a “Waiting for table metadata lock” state?
  34. mysql count duplicates
  35. phpmyadmin #1045 Cannot log in to the MySQL server. after installing mysql command line client
  36. wget returns “Unable to establish SSL connection”
  37. Create boolean column in MySQL with false as default value?
  38. Is there a naming convention for MySQL?
  39. List all mounts in Linux
  40. Error Code 1292 – Truncated incorrect DOUBLE value – Mysql
  41. MySql – HAVING vs WHERE 
  42. How to stop mysqld
  43. Is merge statement available in MySQL
  44. GROUP_CONCAT comma separator – MySQL
  45. Error: Duplicate entry ‘0’ for key ‘PRIMARY’
  46. Set page template for all pages?
  47. Optimize Multiple Taxonomy Term MySQL Query?
  48. WordPress MySQL & PHP Performance
  49. What specific database privileges does WordPress need?
  50. Using source control with WordPress
  51. My WordPress site always displays a cached version of its homepage
  52. Updating User Meta with SQL Query
  53. wpdb prepare syntax
  54. How to run this SQL query of wp_terms database
  55. Proper way to work with wpdb to get user’s firstname
  56. How to change post format from Aside to Image for all posts?
  57. Inserting Hundreds of Thousands of Posts at Once
  58. wp_admin edit.php slow with lots of queries
  59. How to add and SQL query of posts only published
  60. Slow Mysql Queries
  61. can database and media folder be moved to a different drive?
  62. Find duplicate posts with same slug and author
  63. SQL error #1062 – Duplicate entry ‘1’ for key ‘PRIMARY’ [closed]
  64. writing inner join in wpdb
  65. How to get data from WordPress site sql file
  66. Unknown collation when I import a dump from an existing site into a development database?
  67. PHP script can’t connect to Database on port 3307
  68. WordPress with php5-fpm and nginx
  69. When WordPress Default table, Echo Success. When Plugin Table, Echo Blank
  70. How to translate this mySQL query to $wpdb query
  71. $wpdb to insert html form information
  72. Proper usage of $wpdb->update()?
  73. MySQL 5.5 upgrade ‘broke’ WordPress [closed]
  74. Separate DB by yearly archive of WordPress
  75. What should a WordPress developer know about MySQL? [closed]
  76. Copyright: Get first and last date of post type
  77. Update MySQL query so that it functions again
  78. Query posts by custom taxonomy and sort by post_modified
  79. WordPress $wpdb get posts from category and sort by custom meta
  80. Copy usermeta value where ID matches in the same table
  81. Array Formation Issue
  82. Migration problems with mysql: Operation not allowed when innodb_forced_recovery > 0 [closed]
  83. WordPress $wpdb no result
  84. User set date and time from frontend doesn’t get stored into database
  85. when using $wpdb sudden connection rejection without changing anything. Access denied, with errors from repair tool
  86. edit_user_created_user hook – using to update Groups
  87. Mysql Error in querying form entries in Gravity Form plugin
  88. Improving performance of SQL sub-queries in WordPress
  89. Saving custom term value to the database in new table
  90. MySQL errors after a WordPress clone
  91. MYSQL Join on meta key value?
  92. Complicated MySQL Query
  93. problem with quotes on new post
  94. Initialization of table in database using ‘CREATE … IF NOT EXISTS’
  95. mysqldump throws: Unknown table ‘COLUMN_STATISTICS’ in information_schema (1109)
  96. How do I load a sql.gz file to my database? (importing)
  97. df says disk is full, but it is not
  98. Is there a proper way to clear logs?
  99. How should an IT department choose a standard Linux distribution?
  100. Batch Replace URLs in WordPress Database

Leave a Comment