无法连接到使用jdbc或mysql workbench作为docker容器安装的mysql示例

omtl5h9j  于 2021-08-20  发布在  Java
关注(0)|答案(0)|浏览(265)

我是docker的不速之客,刚刚安装了docker,并为mysql示例创建了一个容器。
docker run--name=mysql\u container-d-e mysql\u root\u password=root-e mysql\u root\u host=%-p 6603:6603 mysql/mysql服务器
能够使用docker exec访问mysql示例。
docker exec-it mysql\u容器mysql-uroot-p
无论如何,无法使用mysql工作台连接到docker mysql示例(本地机器中的mysql服务已关闭)。尝试了主机localhost和0.0.0.0,但仍然没有成功。
我刚刚运行了命令“docker inspect mysql_container”,响应如下:

  1. [
  2. {
  3. "Id": "12a30238bf11b08d9c029c528274db96175cc2edd976c8861e566e3ef4e26775",
  4. "Created": "2021-07-05T00:42:17.1792371Z",
  5. "Path": "/entrypoint.sh",
  6. "Args": [
  7. "mysqld"
  8. ],
  9. "State": {
  10. "Status": "running",
  11. "Running": true,
  12. "Paused": false,
  13. "Restarting": false,
  14. "OOMKilled": false,
  15. "Dead": false,
  16. "Pid": 1836,
  17. "ExitCode": 0,
  18. "Error": "",
  19. "StartedAt": "2021-07-05T00:42:17.567659Z",
  20. "FinishedAt": "0001-01-01T00:00:00Z",
  21. "Health": {
  22. "Status": "healthy",
  23. "FailingStreak": 0,
  24. "Log": [
  25. {
  26. "Start": "2021-07-05T01:32:52.8156541Z",
  27. "End": "2021-07-05T01:32:52.85896Z",
  28. "ExitCode": 0,
  29. "Output": "mysqld is alive\n"
  30. },
  31. {
  32. "Start": "2021-07-05T01:33:22.8668644Z",
  33. "End": "2021-07-05T01:33:22.9092576Z",
  34. "ExitCode": 0,
  35. "Output": "mysqld is alive\n"
  36. },
  37. {
  38. "Start": "2021-07-05T01:33:52.9167436Z",
  39. "End": "2021-07-05T01:33:52.9587054Z",
  40. "ExitCode": 0,
  41. "Output": "mysqld is alive\n"
  42. },
  43. {
  44. "Start": "2021-07-05T01:34:22.9666096Z",
  45. "End": "2021-07-05T01:34:23.0097958Z",
  46. "ExitCode": 0,
  47. "Output": "mysqld is alive\n"
  48. },
  49. {
  50. "Start": "2021-07-05T01:34:53.0175935Z",
  51. "End": "2021-07-05T01:34:53.0610566Z",
  52. "ExitCode": 0,
  53. "Output": "mysqld is alive\n"
  54. }
  55. ]
  56. }
  57. },
  58. "Image": "sha256:1504607f1ce72dde82fc3377dce506b347594baf0698ddb0b493977e6f07d739",
  59. "ResolvConfPath": "/var/lib/docker/containers/12a30238bf11b08d9c029c528274db96175cc2edd976c8861e566e3ef4e26775/resolv.conf",
  60. "HostnamePath": "/var/lib/docker/containers/12a30238bf11b08d9c029c528274db96175cc2edd976c8861e566e3ef4e26775/hostname",
  61. "HostsPath": "/var/lib/docker/containers/12a30238bf11b08d9c029c528274db96175cc2edd976c8861e566e3ef4e26775/hosts",
  62. "LogPath": "/var/lib/docker/containers/12a30238bf11b08d9c029c528274db96175cc2edd976c8861e566e3ef4e26775/12a30238bf11b08d9c029c528274db96175cc2edd976c8861e566e3ef4e26775-json.log",
  63. "Name": "/mysql_container",
  64. "RestartCount": 0,
  65. "Driver": "overlay2",
  66. "Platform": "linux",
  67. "MountLabel": "",
  68. "ProcessLabel": "",
  69. "AppArmorProfile": "",
  70. "ExecIDs": null,
  71. "HostConfig": {
  72. "Binds": null,
  73. "ContainerIDFile": "",
  74. "LogConfig": {
  75. "Type": "json-file",
  76. "Config": {}
  77. },
  78. "NetworkMode": "default",
  79. "PortBindings": {
  80. "6603/tcp": [
  81. {
  82. "HostIp": "",
  83. "HostPort": "6603"
  84. }
  85. ]
  86. },
  87. "RestartPolicy": {
  88. "Name": "no",
  89. "MaximumRetryCount": 0
  90. },
  91. "AutoRemove": false,
  92. "VolumeDriver": "",
  93. "VolumesFrom": null,
  94. "CapAdd": null,
  95. "CapDrop": null,
  96. "CgroupnsMode": "host",
  97. "Dns": [],
  98. "DnsOptions": [],
  99. "DnsSearch": [],
  100. "ExtraHosts": null,
  101. "GroupAdd": null,
  102. "IpcMode": "private",
  103. "Cgroup": "",
  104. "Links": null,
  105. "OomScoreAdj": 0,
  106. "PidMode": "",
  107. "Privileged": false,
  108. "PublishAllPorts": false,
  109. "ReadonlyRootfs": false,
  110. "SecurityOpt": null,
  111. "UTSMode": "",
  112. "UsernsMode": "",
  113. "ShmSize": 67108864,
  114. "Runtime": "runc",
  115. "ConsoleSize": [
  116. 63,
  117. 144
  118. ],
  119. "Isolation": "",
  120. "CpuShares": 0,
  121. "Memory": 0,
  122. "NanoCpus": 0,
  123. "CgroupParent": "",
  124. "BlkioWeight": 0,
  125. "BlkioWeightDevice": [],
  126. "BlkioDeviceReadBps": null,
  127. "BlkioDeviceWriteBps": null,
  128. "BlkioDeviceReadIOps": null,
  129. "BlkioDeviceWriteIOps": null,
  130. "CpuPeriod": 0,
  131. "CpuQuota": 0,
  132. "CpuRealtimePeriod": 0,
  133. "CpuRealtimeRuntime": 0,
  134. "CpusetCpus": "",
  135. "CpusetMems": "",
  136. "Devices": [],
  137. "DeviceCgroupRules": null,
  138. "DeviceRequests": null,
  139. "KernelMemory": 0,
  140. "KernelMemoryTCP": 0,
  141. "MemoryReservation": 0,
  142. "MemorySwap": 0,
  143. "MemorySwappiness": null,
  144. "OomKillDisable": false,
  145. "PidsLimit": null,
  146. "Ulimits": null,
  147. "CpuCount": 0,
  148. "CpuPercent": 0,
  149. "IOMaximumIOps": 0,
  150. "IOMaximumBandwidth": 0,
  151. "MaskedPaths": [
  152. "/proc/asound",
  153. "/proc/acpi",
  154. "/proc/kcore",
  155. "/proc/keys",
  156. "/proc/latency_stats",
  157. "/proc/timer_list",
  158. "/proc/timer_stats",
  159. "/proc/sched_debug",
  160. "/proc/scsi",
  161. "/sys/firmware"
  162. ],
  163. "ReadonlyPaths": [
  164. "/proc/bus",
  165. "/proc/fs",
  166. "/proc/irq",
  167. "/proc/sys",
  168. "/proc/sysrq-trigger"
  169. ]
  170. },
  171. "GraphDriver": {
  172. "Data": {
  173. "LowerDir": "/var/lib/docker/overlay2/03a28621f28b92827eaf38f097b25ba53ab31091c3554e0600b721e09c9beb1f-init/diff:/var/lib/docker/overlay2/f43a2ac50d2b3b388b1947fa3a44859c932394c977df5d06e8947eabb13fe154/diff:/var/lib/docker/overlay2/f4fbbff8a89d0bd37b24fcdc05c87bb8d5b322a2cfb756a8bc776c22bef0ba0f/diff:/var/lib/docker/overlay2/47159eeeb0fbd80023fd2ca0e4137766720705180a51fe91dc451fb633cb53ab/diff:/var/lib/docker/overlay2/a7417372516cb1940f18eee241a818b1848e5ff42742fbd77d4df90fd6bd0bcf/diff:/var/lib/docker/overlay2/da77a65d253059537efe311f21e4ce98f70aca276e3e0ecf57757951d77ce0f3/diff:/var/lib/docker/overlay2/8f2a3f629a3bf570743b74f0d9a4211f0666bec21236d4dbd3aa4f6bdbd70743/diff:/var/lib/docker/overlay2/83115d68cd30bf8f45d038c01136c983d94e4d1499ec05a720c2c63aaa0a82a8/diff",
  174. "MergedDir": "/var/lib/docker/overlay2/03a28621f28b92827eaf38f097b25ba53ab31091c3554e0600b721e09c9beb1f/merged",
  175. "UpperDir": "/var/lib/docker/overlay2/03a28621f28b92827eaf38f097b25ba53ab31091c3554e0600b721e09c9beb1f/diff",
  176. "WorkDir": "/var/lib/docker/overlay2/03a28621f28b92827eaf38f097b25ba53ab31091c3554e0600b721e09c9beb1f/work"
  177. },
  178. "Name": "overlay2"
  179. },
  180. "Mounts": [],
  181. "Config": {
  182. "Hostname": "12a30238bf11",
  183. "Domainname": "",
  184. "User": "",
  185. "AttachStdin": false,
  186. "AttachStdout": false,
  187. "AttachStderr": false,
  188. "ExposedPorts": {
  189. "3306/tcp": {},
  190. "33060/tcp": {},
  191. "33061/tcp": {},
  192. "6603/tcp": {}
  193. },
  194. "Tty": false,
  195. "OpenStdin": false,
  196. "StdinOnce": false,
  197. "Env": [
  198. "MYSQL_ROOT_PASSWORD=root",
  199. "MYSQL_ROOT_HOST=%",
  200. "PATH=/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin",
  201. "MYSQL_UNIX_PORT=/var/lib/mysql/mysql.sock"
  202. ],
  203. "Cmd": [
  204. "mysqld"
  205. ],
  206. "Healthcheck": {
  207. "Test": [
  208. "CMD-SHELL",
  209. "/healthcheck.sh"
  210. ]
  211. },
  212. "Image": "mysql/mysql-server",
  213. "Volumes": null,
  214. "WorkingDir": "",
  215. "Entrypoint": [
  216. "/entrypoint.sh"
  217. ],
  218. "OnBuild": null,
  219. "Labels": {}
  220. },
  221. "NetworkSettings": {
  222. "Bridge": "",
  223. "SandboxID": "7c248259a881c317cc21697199a87a7f4706c4a07f0f91c39632194318eab418",
  224. "HairpinMode": false,
  225. "LinkLocalIPv6Address": "",
  226. "LinkLocalIPv6PrefixLen": 0,
  227. "Ports": {
  228. "3306/tcp": null,
  229. "33060/tcp": null,
  230. "33061/tcp": null,
  231. "6603/tcp": [
  232. {
  233. "HostIp": "0.0.0.0",
  234. "HostPort": "6603"
  235. },
  236. {
  237. "HostIp": "::",
  238. "HostPort": "6603"
  239. }
  240. ]
  241. },
  242. "SandboxKey": "/var/run/docker/netns/7c248259a881",
  243. "SecondaryIPAddresses": null,
  244. "SecondaryIPv6Addresses": null,
  245. "EndpointID": "f6ac3760c826e052b525292499ee166608f8307f4cd8618022bfdd8600cdfa54",
  246. "Gateway": "172.17.0.1",
  247. "GlobalIPv6Address": "",
  248. "GlobalIPv6PrefixLen": 0,
  249. "IPAddress": "172.17.0.2",
  250. "IPPrefixLen": 16,
  251. "IPv6Gateway": "",
  252. "MacAddress": "02:42:ac:11:00:02",
  253. "Networks": {
  254. "bridge": {
  255. "IPAMConfig": null,
  256. "Links": null,
  257. "Aliases": null,
  258. "NetworkID": "15d5f77b059c4a53a1182f61dd8cf54734e63e79058cd12d04a2e54867302a37",
  259. "EndpointID": "f6ac3760c826e052b525292499ee166608f8307f4cd8618022bfdd8600cdfa54",
  260. "Gateway": "172.17.0.1",
  261. "IPAddress": "172.17.0.2",
  262. "IPPrefixLen": 16,
  263. "IPv6Gateway": "",
  264. "GlobalIPv6Address": "",
  265. "GlobalIPv6PrefixLen": 0,
  266. "MacAddress": "02:42:ac:11:00:02",
  267. "DriverOpts": null
  268. }
  269. }
  270. }
  271. }

]
spring启动应用程序的application.properties如下

  1. # spring.datasource.url=jdbc:mysql://localhost:6603/test
  2. # spring.datasource.url=jdbc:mysql://0.0.0.0:6603/test
  3. spring.datasource.url=jdbc:mysql://172.17.0.2:6603/test
  4. spring.datasource.username=root
  5. spring.datasource.password=root
  6. spring.datasource.driver-class-name=com.mysql.cj.jdbc.Driver
  7. spring.jpa.properties.hibernate.dialect=org.hibernate.dialect.MySQLDialect

暂无答案!

目前还没有任何答案,快来回答吧!

相关问题