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. MySQL Error: : ‘Access denied for user ‘root’@’localhost’
  11. MySQL Error: : ‘Access denied for user ‘root’@’localhost’
  12. How to use mysqli_query() in PHP?
  13. Cannot connect to the Docker daemon at unix:/var/run/docker.sock. Is the docker daemon running?
  14. Access Denied for User ‘root’@’localhost’ (using password: YES) – No Privileges?
  15. Access Denied for User ‘root’@’localhost’ (using password: YES) – No Privileges?
  16. Column count doesn’t match value count at row 1
  17. Undefined function mysql_connect()
  18. MySQL string replace
  19. Cannot add or update a child row: a foreign key constraint fails
  20. Undefined function mysql_connect()
  21. String concatenation in MySQL
  22. What’s the difference between INNER JOIN, LEFT JOIN, RIGHT JOIN and FULL JOIN? [duplicate]
  23. apt-get error: Sub-process /usr/bin/dpkg returned an error code (1)
  24. What is a clearfix?
  25. “Couldn’t find a file descriptor referring to the console” on Ubuntu bash on Windows
  26. Cannot add or update a child row: a foreign key constraint fails
  27. MySQL Error “Operand should contain 1 column”
  28. How to use MySQL DECIMAL?
  29. Access denied for user ‘root@localhost’ (using password:NO)
  30. Can’t connect to local MySQL server through socket ‘/var/mysql/mysql.sock’ (38)
  31. How to make MySQL table primary key auto increment with some prefix
  32. Access denied for user ‘root@localhost’ (using password:NO)
  33. MySQL ERROR 1290 (HY000) –secure-file-priv option
  34. MySQL error 2006: mysql server has gone away
  35. Which MySQL data type to use for storing boolean values
  36. sql query with multiple where statements
  37. ERROR 2003 (HY000): Can’t connect to MySQL server on localhost (10061)
  38. ERROR 1698 (28000): Access denied for user ‘root’@’localhost’
  39. Cannot delete or update a parent row: a foreign key constraint fails
  40. Cannot delete or update a parent row: a foreign key constraint fails
  41. “E: Unable to locate package python-pip” on Ubuntu 18.04 [duplicate]
  42. ERROR 2003 (HY000): Can’t connect to MySQL server on localhost (10061)
  43. MySQL server startup error ‘The server quit without updating PID file’
  44. Rename a column in MySQL
  45. “INSERT IGNORE” vs “INSERT … ON DUPLICATE KEY UPDATE”
  46. Cannot delete or update a parent row: a foreign key constraint fails
  47. “E: Unable to locate package python-pip” on Ubuntu 18.04 [duplicate]
  48. MySQL server startup error ‘The server quit without updating PID file’
  49. How do I restore a dump file from mysqldump?
  50. Syntax error due to using a reserved word as a table or column name in MySQL
  51. ERROR 1698 (28000): Access denied for user ‘root’@’localhost’
  52. MySQL root password change
  53. Installation of MySQL for Visual Studio 1.2.8 failed
  54. Not unique table/alias
  55. How do I import an SQL file using the command line in MySQL?
  56. “sed” command in bash
  57. PHP Connection failed: SQLSTATE[HY000] [2002] Connection refused
  58. #1273 – Unknown collation: ‘utf8mb4_unicode_520_ci’
  59. MySQL ERROR 1045 (28000): Access denied for user ‘bill’@’localhost’ (using password: YES)
  60. Your password does not satisfy the current policy requirements
  61. How do I quickly rename a MySQL database (change schema name)?
  62. What does SQL Select symbol || mean?
  63. Install mysql-python (Windows)
  64. MySQL: Access denied for user ‘test’@’localhost’ (using password: YES) except root user
  65. PHP Connection failed: SQLSTATE[HY000] [2002] Connection refused
  66. SQL – Update multiple records in one query
  67. Mysql: Setup the format of DATETIME to ‘DD-MM-YYYY HH:MM:SS’ when creating a table
  68. What is the definition of cardinality in SQL
  69. Authentication plugin ‘caching_sha2_password’ cannot be loaded
  70. Ubuntu: OpenJDK 8 – Unable to locate package
  71. MySQL DROP all tables, ignoring foreign keys
  72. #1055 – Expression of SELECT list is not in GROUP BY clause and contains nonaggregated column this is incompatible with sql_mode=only_full_group_by
  73. When to use SELECT … FOR UPDATE?
  74. Host ‘xxx.xx.xxx.xxx’ is not allowed to connect to this MySQL server
  75. Can’t connect to local MySQL server through socket ‘/var/lib/mysql/mysql.sock’ (2)
  76. Setting up foreign keys in phpMyAdmin?
  77. using pip3: module “importlib._bootstrap” has no attribute “SourceFileLoader”
  78. Select from multiple tables without a join?
  79. WSL – GEDIT Unable to init server: Could not connect: Connection refused
  80. PHP Deprecated: Methods with the same name as their class will not be constructors in a future version of PHP
  81. ERROR 1396 (HY000): Operation CREATE USER failed for ‘jack’@’localhost’
  82. SQL Query Where Field DOES NOT Contain $x
  83. Create a new database with MySQL Workbench
  84. Duplicating a MySQL table, indices, and data
  85. Disable ONLY_FULL_GROUP_BY
  86. what does “/index.php?admin/admin_dashboard” in my url mean
  87. How to open some ports on Ubuntu?
  88. Column ‘user_id’ in field list is ambiguous
  89. How to join two tables by multiple columns in SQL?
  90. How to get size of mysql database?
  91. mysql Foreign key constraint is incorrectly formed error
  92. Uncompress tar.gz file
  93. Database sharding vs partitioning
  94. Selecting data from two different tables without using joins
  95. MySQL WHERE IN ()
  96. Access Denied for User ‘root’@’localhost’ (using password: YES) – No Privileges?
  97. Is there an SQLite equivalent to MySQL’s DESCRIBE [table]?
  98. ERROR 2003 (HY000): Can’t connect to MySQL server on ‘127.0.0.1’ (111)
  99. SQL – Update multiple records in one query
  100. Difference between VARCHAR and TEXT in MySQL

Leave a Comment

Hata!: SQLSTATE[HY000] [1045] Access denied for user 'divattrend_liink'@'localhost' (using password: YES)