Advertisement
Guest User

Untitled

a guest
Sep 30th, 2018
93
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 15.12 KB | None | 0 0
  1. root@fileserver:~# mysql --user=root -p
  2. Enter password:
  3. ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
  4.  
  5. root@fileserver:~# sudo apt-get remove --purge mysql-server mysql-client mysql-common -y
  6. Reading package lists... Done
  7. Building dependency tree
  8. Reading state information... Done
  9. The following packages were automatically installed and are no longer required:
  10. libaio1 libevent-core-2.0-5 libnuma1 mysql-client-core-5.7 mysql-server-core-5.7
  11. Use 'sudo apt autoremove' to remove them.
  12. The following packages will be REMOVED:
  13. mysql-client* mysql-client-5.7* mysql-common* mysql-server* mysql-server-5.7*
  14. 0 upgraded, 0 newly installed, 5 to remove and 18 not upgraded.
  15. 2 not fully installed or removed.
  16. After this operation, 82.7 MB disk space will be freed.
  17. (Reading database ... 150440 files and directories currently installed.)
  18. Removing mysql-server (5.7.23-0ubuntu0.16.04.1) ...
  19. Removing mysql-server-5.7 (5.7.23-0ubuntu0.16.04.1) ...
  20. update-alternatives: warning: alternative /etc/mysql/my.cnf.fallback (part of link group my.cnf) doesn't exist; removing from list of alternatives
  21. update-alternatives: warning: alternative /etc/mysql/mysql.cnf (part of link group my.cnf) doesn't exist; removing from list of alternatives
  22. update-alternatives: warning: /etc/alternatives/my.cnf is dangling; it will be updated with best choice
  23. Purging configuration files for mysql-server-5.7 (5.7.23-0ubuntu0.16.04.1) ...
  24. Removing mysql-client (5.7.23-0ubuntu0.16.04.1) ...
  25. Removing mysql-client-5.7 (5.7.23-0ubuntu0.16.04.1) ...
  26. Removing mysql-common (5.7.23-0ubuntu0.16.04.1) ...
  27. Purging configuration files for mysql-common (5.7.23-0ubuntu0.16.04.1) ...
  28. Processing triggers for man-db (2.7.5-1) ...
  29. Processing triggers for systemd (229-4ubuntu21.4) ...
  30. root@fileserver:~# sudo apt-get remove --purge mysql-server mysql-client mysql-common -y
  31. Reading package lists... Done
  32. Building dependency tree
  33. Reading state information... Done
  34. Package 'mysql-client' is not installed, so not removed
  35. Package 'mysql-common' is not installed, so not removed
  36. Package 'mysql-server' is not installed, so not removed
  37. The following packages were automatically installed and are no longer required:
  38. libaio1 libevent-core-2.0-5 libnuma1 mysql-client-core-5.7 mysql-server-core-5.7
  39. Use 'sudo apt autoremove' to remove them.
  40. 0 upgraded, 0 newly installed, 0 to remove and 18 not upgraded.
  41. root@fileserver:~# sudo apt-get autoremove -y
  42. Reading package lists... Done
  43. Building dependency tree
  44. Reading state information... Done
  45. The following packages will be REMOVED:
  46. libaio1 libevent-core-2.0-5 libnuma1 mysql-client-core-5.7 mysql-server-core-5.7
  47. 0 upgraded, 0 newly installed, 5 to remove and 18 not upgraded.
  48. After this operation, 78.0 MB disk space will be freed.
  49. (Reading database ... 150299 files and directories currently installed.)
  50. Removing mysql-server-core-5.7 (5.7.23-0ubuntu0.16.04.1) ...
  51. Removing mysql-client-core-5.7 (5.7.23-0ubuntu0.16.04.1) ...
  52. Removing libaio1:amd64 (0.3.110-2) ...
  53. Removing libevent-core-2.0-5:amd64 (2.0.21-stable-2ubuntu0.16.04.1) ...
  54. Removing libnuma1:amd64 (2.0.11-1ubuntu1.1) ...
  55. Processing triggers for man-db (2.7.5-1) ...
  56. Processing triggers for libc-bin (2.23-0ubuntu10) ...
  57. root@fileserver:~# sudo apt-get autoclean
  58. Reading package lists... Done
  59. Building dependency tree
  60. Reading state information... Done
  61. root@fileserver:~# rm -rf /etc/mysql
  62. root@fileserver:~# sudo find / -iname 'mysql*' -exec rm -rf {} ;
  63. find: '/var/lib/mysql-files': No such file or directory
  64. find: '/var/lib/mysql-keyring': No such file or directory
  65. root@fileserver:~#
  66.  
  67. root@fileserver:~# sudo apt-get install mysql-client mysql-server
  68. Reading package lists... Done
  69. Building dependency tree
  70. Reading state information... Done
  71. The following NEW packages will be installed:
  72. mysql-client mysql-server
  73. 0 upgraded, 2 newly installed, 0 to remove and 18 not upgraded.
  74. 1 not fully installed or removed.
  75. Need to get 0 B/20.9 kB of archives.
  76. After this operation, 219 kB of additional disk space will be used.
  77. Selecting previously unselected package mysql-client.
  78. (Reading database ... 150436 files and directories currently installed.)
  79. Preparing to unpack .../mysql-client_5.7.23-0ubuntu0.16.04.1_all.deb ...
  80. Unpacking mysql-client (5.7.23-0ubuntu0.16.04.1) ...
  81. Selecting previously unselected package mysql-server.
  82. Preparing to unpack .../mysql-server_5.7.23-0ubuntu0.16.04.1_all.deb ...
  83. Unpacking mysql-server (5.7.23-0ubuntu0.16.04.1) ...
  84. Setting up mysql-server-5.7 (5.7.23-0ubuntu0.16.04.1) ...
  85. update-alternatives: error: alternative path /etc/mysql/mysql.cnf doesn't exist
  86. dpkg: error processing package mysql-server-5.7 (--configure):
  87. subprocess installed post-installation script returned error exit status 2
  88. Setting up mysql-client (5.7.23-0ubuntu0.16.04.1) ...
  89. dpkg: dependency problems prevent configuration of mysql-server:
  90. mysql-server depends on mysql-server-5.7; however:
  91. Package mysql-server-5.7 is not configured yet.
  92.  
  93. dpkg: error processing package mysql-server (--configure):
  94. dependency problems - leaving unconfigured
  95. No apport report written because the error message indicates its a followup error from a previous failure.
  96. Errors were encountered while processing:
  97. mysql-server-5.7
  98. mysql-server
  99. E: Sub-process /usr/bin/dpkg returned an error code (1)
  100.  
  101. root@fileserver:~# sudo /etc/init.d/mysql start
  102. [....] Starting mysql (via systemctl): mysql.serviceJob for mysql.service failed because the control process exited with error code. See "systemctl status mysql.service" and "journalctl -xe" for details.
  103. failed!
  104.  
  105. root@fileserver:~# journalctl -xe
  106. -- The process /usr/share/mysql/mysql-systemd-start could not be executed and failed.
  107. --
  108. -- The error number returned by this process is 3.
  109. Sep 30 06:35:38 fileserver systemd[1]: mysql.service: Control process exited, code=exited status=217
  110. Sep 30 06:35:38 fileserver systemd[1]: Failed to start MySQL Community Server.
  111. -- Subject: Unit mysql.service has failed
  112. -- Defined-By: systemd
  113. -- Support: http://lists.freedesktop.org/mailman/listinfo/systemd-devel
  114. --
  115. -- Unit mysql.service has failed.
  116. --
  117. -- The result is failed.
  118. Sep 30 06:35:38 fileserver systemd[1]: mysql.service: Unit entered failed state.
  119. Sep 30 06:35:38 fileserver systemd[1]: mysql.service: Failed with result 'exit-code'.
  120. Sep 30 06:35:39 fileserver systemd[1]: mysql.service: Service hold-off time over, scheduling restart.
  121. Sep 30 06:35:39 fileserver systemd[1]: Stopped MySQL Community Server.
  122. -- Subject: Unit mysql.service has finished shutting down
  123. -- Defined-By: systemd
  124. -- Support: http://lists.freedesktop.org/mailman/listinfo/systemd-devel
  125. --
  126. -- Unit mysql.service has finished shutting down.
  127. Sep 30 06:35:39 fileserver systemd[1]: Starting MySQL Community Server...
  128. -- Subject: Unit mysql.service has begun start-up
  129. -- Defined-By: systemd
  130. -- Support: http://lists.freedesktop.org/mailman/listinfo/systemd-devel
  131. --
  132. -- Unit mysql.service has begun starting up.
  133. Sep 30 06:35:39 fileserver systemd[16248]: mysql.service: Failed at step USER spawning /usr/share/mysql/mysql-systemd-start: No such process
  134. -- Subject: Process /usr/share/mysql/mysql-systemd-start could not be executed
  135. -- Defined-By: systemd
  136. -- Support: http://lists.freedesktop.org/mailman/listinfo/systemd-devel
  137. --
  138. -- The process /usr/share/mysql/mysql-systemd-start could not be executed and failed.
  139. --
  140. -- The error number returned by this process is 3.
  141. Sep 30 06:35:39 fileserver systemd[1]: mysql.service: Control process exited, code=exited status=217
  142. Sep 30 06:35:39 fileserver systemd[1]: Failed to start MySQL Community Server.
  143. -- Subject: Unit mysql.service has failed
  144. -- Defined-By: systemd
  145. -- Support: http://lists.freedesktop.org/mailman/listinfo/systemd-devel
  146. --
  147. -- Unit mysql.service has failed.
  148. --
  149. -- The result is failed.
  150. Sep 30 06:35:39 fileserver systemd[1]: mysql.service: Unit entered failed state.
  151. Sep 30 06:35:39 fileserver systemd[1]: mysql.service: Failed with result 'exit-code'.
  152. Sep 30 06:35:39 fileserver systemd[1]: mysql.service: Service hold-off time over, scheduling restart.
  153. Sep 30 06:35:39 fileserver systemd[1]: Stopped MySQL Community Server.
  154. -- Subject: Unit mysql.service has finished shutting down
  155. -- Defined-By: systemd
  156. -- Support: http://lists.freedesktop.org/mailman/listinfo/systemd-devel
  157. --
  158. -- Unit mysql.service has finished shutting down.
  159. Sep 30 06:35:39 fileserver systemd[1]: mysql.service: Start request repeated too quickly.
  160. Sep 30 06:35:39 fileserver systemd[1]: Failed to start MySQL Community Server.
  161. -- Subject: Unit mysql.service has failed
  162. -- Defined-By: systemd
  163. -- Support: http://lists.freedesktop.org/mailman/listinfo/systemd-devel
  164. --
  165. -- Unit mysql.service has failed.
  166. --
  167. -- The result is failed.
  168.  
  169. root@fileserver:~# mysql --user=root -p
  170. Enter password:
  171. ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
  172. root@fileserver:~# sudo apt-get install mysql-client mysql-server
  173. Reading package lists... Done
  174. Building dependency tree
  175. Reading state information... Done
  176. The following NEW packages will be installed:
  177. mysql-client mysql-server
  178. 0 upgraded, 2 newly installed, 0 to remove and 18 not upgraded.
  179. 1 not fully installed or removed.
  180. Need to get 0 B/20.9 kB of archives.
  181. After this operation, 219 kB of additional disk space will be used.
  182. Selecting previously unselected package mysql-client.
  183. (Reading database ... 150436 files and directories currently installed.)
  184. Preparing to unpack .../mysql-client_5.7.23-0ubuntu0.16.04.1_all.deb ...
  185. Unpacking mysql-client (5.7.23-0ubuntu0.16.04.1) ...
  186. Selecting previously unselected package mysql-server.
  187. Preparing to unpack .../mysql-server_5.7.23-0ubuntu0.16.04.1_all.deb ...
  188. Unpacking mysql-server (5.7.23-0ubuntu0.16.04.1) ...
  189. Setting up mysql-server-5.7 (5.7.23-0ubuntu0.16.04.1) ...
  190. update-alternatives: error: alternative path /etc/mysql/mysql.cnf doesn't exist
  191. dpkg: error processing package mysql-server-5.7 (--configure):
  192. subprocess installed post-installation script returned error exit status 2
  193. Setting up mysql-client (5.7.23-0ubuntu0.16.04.1) ...
  194. dpkg: dependency problems prevent configuration of mysql-server:
  195. mysql-server depends on mysql-server-5.7; however:
  196. Package mysql-server-5.7 is not configured yet.
  197.  
  198. dpkg: error processing package mysql-server (--configure):
  199. dependency problems - leaving unconfigured
  200. No apport report written because the error message indicates its a followup error from a previous failure.
  201. Errors were encountered while processing:
  202. mysql-server-5.7
  203. mysql-server
  204. E: Sub-process /usr/bin/dpkg returned an error code (1)
  205. root@fileserver:~# ^C
  206. root@fileserver:~# ^C
  207. root@fileserver:~# service mysql start
  208. Job for mysql.service failed because the control process exited with error code. See "systemctl status mysql.service" and "journalctl -xe" for details.
  209. root@fileserver:~# sudo /etc/init.d/mysql start
  210. [....] Starting mysql (via systemctl): mysql.serviceJob for mysql.service failed because the control process exited with error code. See "systemctl status mysql.service" and "journalctl -xe" for details.
  211. failed!
  212. root@fileserver:~# ^C
  213. root@fileserver:~# systemctl status mysql.service
  214. ● mysql.service - MySQL Community Server
  215. Loaded: loaded (/lib/systemd/system/mysql.service; enabled; vendor preset: enabled)
  216. Active: inactive (dead) (Result: exit-code) since Sun 2018-09-30 06:38:37 EDT; 25s ago
  217. Process: 16482 ExecStartPre=/usr/share/mysql/mysql-systemd-start pre (code=exited, status=217/USER)
  218. Main PID: 15680 (code=exited, status=203/EXEC)
  219.  
  220. Sep 30 06:38:37 fileserver systemd[1]: Failed to start MySQL Community Server.
  221. Sep 30 06:38:37 fileserver systemd[1]: mysql.service: Unit entered failed state.
  222. Sep 30 06:38:37 fileserver systemd[1]: mysql.service: Failed with result 'exit-code'.
  223. Sep 30 06:38:37 fileserver systemd[1]: mysql.service: Service hold-off time over, scheduling restart.
  224. Sep 30 06:38:37 fileserver systemd[1]: Stopped MySQL Community Server.
  225. Sep 30 06:38:37 fileserver systemd[1]: mysql.service: Start request repeated too quickly.
  226. Sep 30 06:38:37 fileserver systemd[1]: Failed to start MySQL Community Server.
  227. root@fileserver:~# ^C
  228. root@fileserver:~# journalctl -xe
  229. -- The process /usr/share/mysql/mysql-systemd-start could not be executed and failed.
  230. --
  231. -- The error number returned by this process is 3.
  232. Sep 30 06:38:36 fileserver systemd[1]: mysql.service: Control process exited, code=exited status=217
  233. Sep 30 06:38:36 fileserver systemd[1]: Failed to start MySQL Community Server.
  234. -- Subject: Unit mysql.service has failed
  235. -- Defined-By: systemd
  236. -- Support: http://lists.freedesktop.org/mailman/listinfo/systemd-devel
  237. --
  238. -- Unit mysql.service has failed.
  239. --
  240. -- The result is failed.
  241. Sep 30 06:38:36 fileserver systemd[1]: mysql.service: Unit entered failed state.
  242. Sep 30 06:38:36 fileserver systemd[1]: mysql.service: Failed with result 'exit-code'.
  243. Sep 30 06:38:37 fileserver systemd[1]: mysql.service: Service hold-off time over, scheduling restart.
  244. Sep 30 06:38:37 fileserver systemd[1]: Stopped MySQL Community Server.
  245. -- Subject: Unit mysql.service has finished shutting down
  246. -- Defined-By: systemd
  247. -- Support: http://lists.freedesktop.org/mailman/listinfo/systemd-devel
  248. --
  249. -- Unit mysql.service has finished shutting down.
  250. Sep 30 06:38:37 fileserver systemd[1]: Starting MySQL Community Server...
  251. -- Subject: Unit mysql.service has begun start-up
  252. -- Defined-By: systemd
  253. -- Support: http://lists.freedesktop.org/mailman/listinfo/systemd-devel
  254. --
  255. -- Unit mysql.service has begun starting up.
  256. Sep 30 06:38:37 fileserver systemd[16482]: mysql.service: Failed at step USER spawning /usr/share/mysql/mysql-systemd-start: No such process
  257. -- Subject: Process /usr/share/mysql/mysql-systemd-start could not be executed
  258. -- Defined-By: systemd
  259. -- Support: http://lists.freedesktop.org/mailman/listinfo/systemd-devel
  260. --
  261. -- The process /usr/share/mysql/mysql-systemd-start could not be executed and failed.
  262. --
  263. -- The error number returned by this process is 3.
  264. Sep 30 06:38:37 fileserver systemd[1]: mysql.service: Control process exited, code=exited status=217
  265. Sep 30 06:38:37 fileserver systemd[1]: Failed to start MySQL Community Server.
  266. -- Subject: Unit mysql.service has failed
  267. -- Defined-By: systemd
  268. -- Support: http://lists.freedesktop.org/mailman/listinfo/systemd-devel
  269. --
  270. -- Unit mysql.service has failed.
  271. --
  272. -- The result is failed.
  273. Sep 30 06:38:37 fileserver systemd[1]: mysql.service: Unit entered failed state.
  274. Sep 30 06:38:37 fileserver systemd[1]: mysql.service: Failed with result 'exit-code'.
  275. Sep 30 06:38:37 fileserver systemd[1]: mysql.service: Service hold-off time over, scheduling restart.
  276. Sep 30 06:38:37 fileserver systemd[1]: Stopped MySQL Community Server.
  277. -- Subject: Unit mysql.service has finished shutting down
  278. -- Defined-By: systemd
  279. -- Support: http://lists.freedesktop.org/mailman/listinfo/systemd-devel
  280. --
  281. -- Unit mysql.service has finished shutting down.
  282. Sep 30 06:38:37 fileserver systemd[1]: mysql.service: Start request repeated too quickly.
  283. Sep 30 06:38:37 fileserver systemd[1]: Failed to start MySQL Community Server.
  284. -- Subject: Unit mysql.service has failed
  285. -- Defined-By: systemd
  286. -- Support: http://lists.freedesktop.org/mailman/listinfo/systemd-devel
  287. --
  288. -- Unit mysql.service has failed.
  289. --
  290. -- The result is failed.
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement