无法连接到远程MySQL(v. 8.0.33| ubuntu 22.04.2)

jdg4fx2g  于 2023-08-03  发布在  Mysql
关注(0)|答案(2)|浏览(176)

在操作系统为ubuntu 22.04.2的服务器上，安装了MySQL版本8.0.33，配置如下：
/etc/mysql/mysql.conf.d/mysqld.cnf

  1. #
  2. # The MySQL database server configuration file.
  3. #
  4. # One can use all long options that the program supports.
  5. # Run program with --help to get a list of available options and with
  6. # --print-defaults to see which it would actually understand and use.
  7. #
  8. # For explanations see
  9. # http://dev.mysql.com/doc/mysql/en/server-system-variables.html
  10. #
  11. # Here is entries for some specific programs
  12. # The following values assume you have at least 32M ram
  13. #
  14. [mysqld]
  15. #
  16. # * Basic Settings
  17. #
  18. user            = mysql
  19. pid-file        = /var/run/mysqld/mysqld.pid
  20. socket  = /var/run/mysqld/mysqld.sock
  21. port            = 3306
  22. datadir = /var/lib/mysql
  23. #
  24. #
  25. # If MySQL is running as a replication slave, this should be
  26. # changed. Ref https://dev.mysql.com/doc/refman/8.0/en/server-system-variables.html#sysvar_tmpd>
  27. # tmpdir                = /tmp
  28. #
  29. # Instead of skip-networking the default is now to listen only on
  30. # localhost which is more compatible and is not less secure.
  31. bind-address            = 0.0.0.0
  32. mysqlx-bind-address     = 0.0.0.0
  33. #
  34. # * Fine Tuning
  35. #
  36. key_buffer_size         = 16M
  37. # max_allowed_packet    = 64M
  38. # thread_stack          = 256K
  39. #
  40. #
  41. # thread_cache_size       = -1
  42. #
  43. # This replaces the startup script and checks MyISAM tables if needed
  44. # the first time they are touched
  45. myisam-recover-options  = BACKUP
  46. #
  47. # max_connections        = 151
  48. #
  49. # table_open_cache       = 4000
  50. #
  51. # * Logging and Replication
  52. #
  53. # Both location gets rotated by the cronjob.
  54. #
  55. # Log all queries
  56. # Be aware that this log type is a performance killer.
  57. # general_log_file        = /var/log/mysql/query.log
  58. # general_log             = 1
  59. #
  60. # Error log - should be very few entries.
  61. #
  62. log_error = /var/log/mysql/error.log
  63. log_error_verbosity = 3
  64. #
  65. # Here you can see queries with especially long duration
  66. # slow_query_log                = 1
  67. # slow_query_log_file   = /var/log/mysql/mysql-slow.log
  68. # long_query_time = 2
  69. # log-queries-not-using-indexes
  70. #
  71. # The following can be used as easy to replay backup logs or for replication.
  72. # note: if you are setting up a replication slave, see README.Debian about
  73. #       other settings you may need to change.
  74. # server-id             = 1
  75. # log_bin                       = /var/log/mysql/mysql-bin.log
  76. # binlog_expire_logs_seconds    = 2592000
  77. max_binlog_size   = 100M
  78. # binlog_do_db          = include_database_name
  79. # binlog_ignore_db      = include_database_name
  80. #

字符串
sudo nano /etc/mysql/mysql.conf.d/mysqld.cnf

  1. ● mysql.service - MySQL Community Server
  2.      Loaded: loaded (/lib/systemd/system/mysql.service; enabled; vendor preset: enabled)
  3.      Active: active (running) since Wed 2023-06-28 22:25:07 +03; 6min ago
  4.     Process: 2043942 ExecStartPre=/usr/share/mysql/mysql-systemd-start pre (code=exited, status=0/SUCCESS)
  5.    Main PID: 2043950 (mysqld)
  6.      Status: "Server is operational"
  7.       Tasks: 37 (limit: 77022)
  8.      Memory: 369.5M
  9.         CPU: 1.782s
  10.      CGroup: /system.slice/mysql.service
  11.              └─2043950 /usr/sbin/mysqld

型
journalctl -xeu mysql.service

  1. ░░ The job identifier is 40379 and the job result is done.
  2. чэр 28 22:31:19 riven systemd[1]: mysql.service: Consumed 1.865s CPU time.
  3. ░░ 
  4. ░░ The unit mysql.service completed and consumed the indicated resources.
  5. чэр 28 22:31:20 riven systemd[1]: Started MySQL Community Server.
  6. ░░ Subject: A start job for unit mysql.service has finished successfully
  7. ░░ Defined-By: systemd
  8. ░░ Support: http://www.ubuntu.com/support
  9. ░░ 
  10. ░░ A start job for unit mysql.service has finished successfully.
  11. ░░ 
  12. ░░ The job identifier is 40379.

型
正如你所看到的，MySQL工作正常，我可以在本地连接到数据库。
同时，防火墙中的端口3306是打开的：
ufw状态

  1. Status: active
  3. To                         Action      From
  4. --                         ------      ----
  5. 7346                       ALLOW       Anywhere                  
  6. 20                         DENY        Anywhere                  
  7. 21                         DENY        Anywhere                  
  8. 40000:50000/tcp            ALLOW       Anywhere                  
  9. 63940/tcp                  ALLOW       Anywhere                  
  10. 22                         DENY        Anywhere                  
  11. 62390/tcp                  ALLOW       Anywhere                  
  12. 3306                       ALLOW       Anywhere                  
  13. 7346 (v6)                  ALLOW       Anywhere (v6)             
  14. 20 (v6)                    DENY        Anywhere (v6)             
  15. 5438 (v6)                  DENY        Anywhere (v6)             
  16. 40000:50000/tcp (v6)       ALLOW       Anywhere (v6)             
  17. 63940/tcp (v6)             ALLOW       Anywhere (v6)             
  18. 21 (v6)                    DENY        Anywhere (v6)             
  19. 22 (v6)                    DENY        Anywhere (v6)             
  20. 62390/tcp (v6)             ALLOW       Anywhere (v6)             
  21. 3306 (v6)                  ALLOW       Anywhere (v6)

型
在MikroTIK路由器的防火墙中，端口也是打开的，当检查站点上的端口时，系统检测到端口是打开的：
Port Checker
netstat -plant| grep 3306

  1. tcp        0      0 0.0.0.0:3306            0.0.0.0:*               LISTEN      1352891/mysqld      
  2. tcp        0      0 0.0.0.0:33060           0.0.0.0:*               LISTEN      1352891/mysqld      
  3. tcp        0      0 127.0.0.1:3306          127.0.0.1:58800         ESTABLISHED 1352891/mysqld      
  4. tcp        0      0 127.0.0.1:3306          127.0.0.1:55746         ESTABLISHED 1352891/mysqld      
  5. tcp        0      0 127.0.0.1:3306          127.0.0.1:33418         ESTABLISHED 1352891/mysqld      
  6. tcp        0      0 127.0.0.1:3306          127.0.0.1:39848         ESTABLISHED 1352891/mysqld      
  7. tcp        0      0 127.0.0.1:3306          127.0.0.1:46750         ESTABLISHED 1352891/mysqld      
  8. tcp        0      0 127.0.0.1:3306          127.0.0.1:59064         ESTABLISHED 1352891/mysqld      
  9. tcp        0      0 127.0.0.1:3306          127.0.0.1:51772         ESTABLISHED 1352891/mysqld      
  10. tcp        0      0 127.0.0.1:3306          127.0.0.1:54564         ESTABLISHED 1352891/mysqld      
  11. tcp        0      0 127.0.0.1:3306          127.0.0.1:52302         ESTABLISHED 1352891/mysqld      
  12. tcp        0      0 127.0.0.1:3306          127.0.0.1:35614         ESTABLISHED 1352891/mysqld      
  13. tcp        0      0 127.0.0.1:3306          127.0.0.1:37432         ESTABLISHED 1352891/mysqld      
  14. tcp        0      0 127.0.0.1:3306          127.0.0.1:60826         ESTABLISHED 1352891/mysqld      
  15. tcp        0      0 127.0.0.1:3306          127.0.0.1:33426         ESTABLISHED 1352891/mysqld      
  16. tcp        0      0 127.0.0.1:3306          127.0.0.1:42130         ESTABLISHED 1352891/mysqld      
  17. tcp        0      0 127.0.0.1:3306          127.0.0.1:41456         ESTABLISHED 1352891/mysqld      
  18. tcp        0      0 127.0.0.1:3306          127.0.0.1:41460         ESTABLISHED 1352891/mysqld      
  19. tcp        0      0 127.0.0.1:3306          127.0.0.1:36806         ESTABLISHED 1352891/mysqld      
  20. tcp        0      0 127.0.0.1:3306          127.0.0.1:35598         ESTABLISHED 1352891/mysqld      
  21. tcp        0      0 127.0.0.1:3306          127.0.0.1:34444         ESTABLISHED 1352891/mysqld      
  22. tcp        0      0 127.0.0.1:3306          127.0.0.1:38860         ESTABLISHED 1352891/mysqld      
  23. tcp        0      0 127.0.0.1:3306          127.0.0.1:36408         ESTABLISHED 1352891/mysqld      
  24. tcp        0      0 127.0.0.1:3306          127.0.0.1:35390         ESTABLISHED 1352891/mysqld      
  25. tcp        0      0 127.0.0.1:3306          127.0.0.1:51960         ESTABLISHED 1352891/mysqld      
  26. tcp        0      0 127.0.0.1:3306          127.0.0.1:43738         ESTABLISHED 1352891/mysqld      
  27. tcp        0      0 127.0.0.1:3306          127.0.0.1:41452         ESTABLISHED 1352891/mysqld      
  28. tcp        0      0 127.0.0.1:3306          127.0.0.1:54074         ESTABLISHED 1352891/mysqld      
  29. tcp        0      0 127.0.0.1:3306          127.0.0.1:41412         ESTABLISHED 1352891/mysqld      
  30. tcp        0      0 127.0.0.1:3306          127.0.0.1:34454         ESTABLISHED 1352891/mysqld      
  31. tcp        0      0 127.0.0.1:3306          127.0.0.1:51952         ESTABLISHED 1352891/mysqld      
  32. tcp        0      0 127.0.0.1:3306          127.0.0.1:40964         ESTABLISHED 1352891/mysqld      
  33. tcp        0      0 127.0.0.1:3306          127.0.0.1:45992         ESTABLISHED 1352891/mysqld      
  34. tcp        0      0 127.0.0.1:3306          127.0.0.1:35824         ESTABLISHED 1352891/mysqld      
  35. tcp        0      0 127.0.0.1:3306          127.0.0.1:40960         ESTABLISHED 1352891/mysqld      
  36. tcp        0      0 127.0.0.1:3306          127.0.0.1:41428         ESTABLISHED 1352891/mysqld      
  37. tcp        0      0 127.0.0.1:3306          127.0.0.1:55762         ESTABLISHED 1352891/mysqld      
  38. tcp        0      0 127.0.0.1:3306          127.0.0.1:50532         ESTABLISHED 1352891/mysqld      
  39. tcp        0      0 127.0.0.1:3306          127.0.0.1:58294         ESTABLISHED 1352891/mysqld      
  40. tcp        0      0 127.0.0.1:3306          127.0.0.1:34820         ESTABLISHED 1352891/mysqld      
  41. tcp        0      0 127.0.0.1:3306          127.0.0.1:59480         ESTABLISHED 1352891/mysqld      
  42. tcp        0      0 127.0.0.1:3306          127.0.0.1:57184         ESTABLISHED 1352891/mysqld      
  43. tcp        0      0 127.0.0.1:3306          127.0.0.1:36818         ESTABLISHED 1352891/mysqld      
  44. tcp        0      0 127.0.0.1:3306          127.0.0.1:43718         ESTABLISHED 1352891/mysqld      
  45. tcp        0      0 127.0.0.1:3306          127.0.0.1:56458         ESTABLISHED 1352891/mysqld      
  46. tcp        0      0 127.0.0.1:3306          127.0.0.1:33416         ESTABLISHED 1352891/mysqld      
  47. tcp        0      0 127.0.0.1:3306          127.0.0.1:33284         ESTABLISHED 1352891/mysqld      
  48. tcp        0      0 127.0.0.1:3306          127.0.0.1:43732         ESTABLISHED 1352891/mysqld      
  49. tcp        0      0 127.0.0.1:3306          127.0.0.1:38978         ESTABLISHED 1352891/mysqld      
  50. tcp        0      0 127.0.0.1:3306          127.0.0.1:57180         ESTABLISHED 1352891/mysqld      
  51. tcp        0      0 127.0.0.1:3306          127.0.0.1:55758         ESTABLISHED 1352891/mysqld      
  52. tcp        0      0 127.0.0.1:3306          127.0.0.1:60552         ESTABLISHED 1352891/mysqld      
  53. tcp        0      0 127.0.0.1:3306          127.0.0.1:54072         ESTABLISHED 1352891/mysqld      
  54. tcp        0      0 127.0.0.1:44856         127.0.0.1:3306          ESTABLISHED 368580/Code --stand 
  55. tcp        0      0 127.0.0.1:3306          127.0.0.1:33412         ESTABLISHED 1352891/mysqld      
  56. tcp        0      0 127.0.0.1:3306          127.0.0.1:57182         ESTABLISHED 1352891/mysqld      
  57. tcp        0      0 127.0.0.1:3306          127.0.0.1:42242         ESTABLISHED 1352891/mysqld      
  58. tcp        0      0 127.0.0.1:3306          127.0.0.1:35774         ESTABLISHED 1352891/mysqld      
  59. tcp        0      0 127.0.0.1:3306          127.0.0.1:35184         ESTABLISHED 1352891/mysqld      
  60. tcp        0      0 127.0.0.1:3306          127.0.0.1:38870         ESTABLISHED 1352891/mysqld      
  61. tcp        0      0 127.0.0.1:3306          127.0.0.1:60834         ESTABLISHED 1352891/mysqld      
  62. tcp        0      0 127.0.0.1:3306          127.0.0.1:60844         ESTABLISHED 1352891/mysqld      
  63. tcp        0      0 127.0.0.1:3306          127.0.0.1:38858         ESTABLISHED 1352891/mysqld      
  64. tcp        0      0 127.0.0.1:3306          127.0.0.1:46758         ESTABLISHED 1352891/mysqld      
  65. tcp        0      0 127.0.0.1:3306          127.0.0.1:40978         ESTABLISHED 1352891/mysqld      
  66. tcp        0      0 127.0.0.1:3306          127.0.0.1:50702         ESTABLISHED 1352891/mysqld      
  67. tcp        0      0 127.0.0.1:35824         127.0.0.1:3306          ESTABLISHED 368580/Code --stand 
  68. tcp        0      0 127.0.0.1:3306          127.0.0.1:55730         ESTABLISHED 1352891/mysqld      
  69. tcp        0      0 127.0.0.1:3306          127.0.0.1:33112         ESTABLISHED 1352891/mysqld      
  70. tcp        0      0 127.0.0.1:3306          127.0.0.1:36820         ESTABLISHED 1352891/mysqld      
  71. tcp        0      0 127.0.0.1:3306          127.0.0.1:38874         ESTABLISHED 1352891/mysqld      
  72. tcp        0      0 127.0.0.1:3306          127.0.0.1:52296         ESTABLISHED 1352891/mysqld      
  73. tcp        0      0 127.0.0.1:3306          127.0.0.1:38420         ESTABLISHED 1352891/mysqld      
  74. tcp        0      0 127.0.0.1:3306          127.0.0.1:38770         ESTABLISHED 1352891/mysqld      
  75. tcp        0      0 127.0.0.1:3306          127.0.0.1:40164         ESTABLISHED 1352891/mysqld      
  76. tcp        0      0 127.0.0.1:3306          127.0.0.1:45996         ESTABLISHED 1352891/mysqld      
  77. tcp        0      0 127.0.0.1:3306          127.0.0.1:36790         ESTABLISHED 1352891/mysqld      
  78. tcp        0      0 127.0.0.1:3306          127.0.0.1:49712         ESTABLISHED 1352891/mysqld      
  79. tcp        0      0 127.0.0.1:3306          127.0.0.1:41442         ESTABLISHED 1352891/mysqld      
  80. tcp        0      0 127.0.0.1:3306          127.0.0.1:44856         ESTABLISHED 1352891/mysqld      
  81. tcp        0      0 127.0.0.1:3306          127.0.0.1:38880         ESTABLISHED 1352891/mysqld      
  82. tcp        0      0 127.0.0.1:3306          127.0.0.1:34834         ESTABLISHED 1352891/mysqld      
  83. tcp        0      0 127.0.0.1:3306          127.0.0.1:41430         ESTABLISHED 1352891/mysqld      
  84. tcp        0      0 127.0.0.1:3306          127.0.0.1:60818         ESTABLISHED 1352891/mysqld      
  85. tcp        0      0 127.0.0.1:3306          127.0.0.1:38984         ESTABLISHED 1352891/mysqld      
  86. tcp        0      0 127.0.0.1:3306          127.0.0.1:50706         ESTABLISHED 1352891/mysqld      
  87. tcp        0      0 127.0.0.1:3306          127.0.0.1:35630         ESTABLISHED 1352891/mysqld      
  88. tcp        0      0 127.0.0.1:3306          127.0.0.1:41618         ESTABLISHED 1352891/mysqld      
  89. tcp        0      0 127.0.0.1:3306          127.0.0.1:51780         ESTABLISHED 1352891/mysqld      
  90. tcp        0      0 127.0.0.1:3306          127.0.0.1:40974         ESTABLISHED 1352891/mysqld      
  91. tcp6       0      0 127.0.0.1:46750         127.0.0.1:3306          ESTABLISHED 883/java            
  92. tcp6       0      0 127.0.0.1:34444         127.0.0.1:3306          ESTABLISHED 883/java            
  93. tcp6       0      0 127.0.0.1:38870         127.0.0.1:3306          ESTABLISHED 829/java            
  94. tcp6       0      0 127.0.0.1:55758         127.0.0.1:3306          ESTABLISHED 819/java            
  95. tcp6       0      0 127.0.0.1:38874         127.0.0.1:3306          ESTABLISHED 819/java            
  96. tcp6       0      0 127.0.0.1:51960         127.0.0.1:3306          ESTABLISHED 800/java            
  97. tcp6       0      0 127.0.0.1:33416         127.0.0.1:3306          ESTABLISHED 825/java            
  98. tcp6       0      0 127.0.0.1:42130         127.0.0.1:3306          ESTABLISHED 883/java            
  99. tcp6       0      0 127.0.0.1:57180         127.0.0.1:3306          ESTABLISHED 829/java            
  100. tcp6       0      0 127.0.0.1:49712         127.0.0.1:3306          ESTABLISHED 883/java            
  101. tcp6       0      0 127.0.0.1:57182         127.0.0.1:3306          ESTABLISHED 829/java            
  102. tcp6       0      0 127.0.0.1:59064         127.0.0.1:3306          ESTABLISHED 800/java            
  103. tcp6       0      0 127.0.0.1:33418         127.0.0.1:3306          ESTABLISHED 800/java            
  104. tcp6       0      0 127.0.0.1:38770         127.0.0.1:3306          ESTABLISHED 1997254/java        
  105. tcp6       0      0 127.0.0.1:35614         127.0.0.1:3306          ESTABLISHED 847/java            
  106. tcp6       0      0 127.0.0.1:41430         127.0.0.1:3306          ESTABLISHED 819/java            
  107. tcp6       0      0 127.0.0.1:38858         127.0.0.1:3306          ESTABLISHED 800/java            
  108. tcp6       0      0 127.0.0.1:35184         127.0.0.1:3306          ESTABLISHED 847/java            
  109. tcp6       0      0 127.0.0.1:50702         127.0.0.1:3306          ESTABLISHED 847/java            
  110. tcp6       0      0 127.0.0.1:34454         127.0.0.1:3306          ESTABLISHED 829/java            
  111. tcp6       0      0 127.0.0.1:54564         127.0.0.1:3306          ESTABLISHED 1997254/java        
  112. tcp6       0      0 127.0.0.1:50706         127.0.0.1:3306          ESTABLISHED 883/java            
  113. tcp6       0      0 127.0.0.1:40964         127.0.0.1:3306          ESTABLISHED 825/java            
  114. tcp6       0      0 127.0.0.1:41456         127.0.0.1:3306          ESTABLISHED 883/java            
  115. tcp6       0      0 127.0.0.1:50532         127.0.0.1:3306          ESTABLISHED 800/java            
  116. tcp6       0      0 127.0.0.1:60834         127.0.0.1:3306          ESTABLISHED 819/java            
  117. tcp6       0      0 127.0.0.1:39848         127.0.0.1:3306          ESTABLISHED 883/java            
  118. tcp6       0      0 127.0.0.1:40960         127.0.0.1:3306          ESTABLISHED 883/java            
  119. tcp6       0      0 127.0.0.1:52296         127.0.0.1:3306          ESTABLISHED 847/java            
  120. tcp6       0      0 127.0.0.1:51772         127.0.0.1:3306          ESTABLISHED 883/java            
  121. tcp6       0      0 127.0.0.1:41460         127.0.0.1:3306          ESTABLISHED 800/java            
  122. tcp6       0      0 127.0.0.1:36818         127.0.0.1:3306          ESTABLISHED 819/java            
  123. tcp6       0      0 127.0.0.1:35598         127.0.0.1:3306          ESTABLISHED 800/java            
  124. tcp6       0      0 127.0.0.1:41428         127.0.0.1:3306          ESTABLISHED 847/java            
  125. tcp6       0      0 127.0.0.1:34834         127.0.0.1:3306          ESTABLISHED 800/java            
  126. tcp6       0      0 127.0.0.1:33112         127.0.0.1:3306          ESTABLISHED 825/java            
  127. tcp6       0      0 127.0.0.1:46758         127.0.0.1:3306          ESTABLISHED 800/java            
  128. tcp6       0      0 127.0.0.1:40974         127.0.0.1:3306          ESTABLISHED 800/java            
  129. tcp6       0      0 127.0.0.1:40978         127.0.0.1:3306          ESTABLISHED 847/java            
  130. tcp6       0      0 127.0.0.1:41452         127.0.0.1:3306          ESTABLISHED 819/java            
  131. tcp6       0      0 127.0.0.1:40164         127.0.0.1:3306          ESTABLISHED 800/java            
  132. tcp6       0      0 127.0.0.1:51780         127.0.0.1:3306          ESTABLISHED 800/java            
  133. tcp6       0      0 127.0.0.1:51952         127.0.0.1:3306          ESTABLISHED 825/java            
  134. tcp6       0      0 127.0.0.1:35390         127.0.0.1:3306          ESTABLISHED 825/java            
  135. tcp6       0      0 127.0.0.1:60818         127.0.0.1:3306          ESTABLISHED 800/java            
  136. tcp6       0      0 127.0.0.1:55762         127.0.0.1:3306          ESTABLISHED 800/java            
  137. tcp6       0      0 127.0.0.1:60552         127.0.0.1:3306          ESTABLISHED 1997254/java        
  138. tcp6       0      0 127.0.0.1:45992         127.0.0.1:3306          ESTABLISHED 1997254/java        
  139. tcp6       0      0 127.0.0.1:60826         127.0.0.1:3306          ESTABLISHED 825/java            
  140. tcp6       0      0 127.0.0.1:38880         127.0.0.1:3306          ESTABLISHED 829/java            
  141. tcp6       0      0 127.0.0.1:36790         127.0.0.1:3306          ESTABLISHED 800/java            
  142. tcp6       0      0 127.0.0.1:38420         127.0.0.1:3306          ESTABLISHED 1997254/java        
  143. tcp6       0      0 127.0.0.1:33284         127.0.0.1:3306          ESTABLISHED 825/java            
  144. tcp6       0      0 127.0.0.1:33412         127.0.0.1:3306          ESTABLISHED 800/java            
  145. tcp6       0      0 127.0.0.1:43738         127.0.0.1:3306          ESTABLISHED 883/java            
  146. tcp6       0      0 127.0.0.1:36806         127.0.0.1:3306          ESTABLISHED 829/java            
  147. tcp6       0      0 127.0.0.1:43732         127.0.0.1:3306          ESTABLISHED 819/java            
  148. tcp6       0      0 127.0.0.1:56458         127.0.0.1:3306          ESTABLISHED 825/java            
  149. tcp6       0      0 127.0.0.1:45996         127.0.0.1:3306          ESTABLISHED 1997254/java        
  150. tcp6       0      0 127.0.0.1:43718         127.0.0.1:3306          ESTABLISHED 847/java            
  151. tcp6       0      0 127.0.0.1:58294         127.0.0.1:3306          ESTABLISHED 825/java            
  152. tcp6       0      0 127.0.0.1:54074         127.0.0.1:3306          ESTABLISHED 1997254/java        
  153. tcp6       0      0 127.0.0.1:35630         127.0.0.1:3306          ESTABLISHED 829/java            
  154. tcp6       0      0 127.0.0.1:41412         127.0.0.1:3306          ESTABLISHED 825/java            
  155. tcp6       0      0 127.0.0.1:59480         127.0.0.1:3306          ESTABLISHED 847/java            
  156. tcp6       0      0 127.0.0.1:41442         127.0.0.1:3306          ESTABLISHED 819/java            
  157. tcp6       0      0 127.0.0.1:34820         127.0.0.1:3306          ESTABLISHED 847/java            
  158. tcp6       0      0 127.0.0.1:42242         127.0.0.1:3306          ESTABLISHED 800/java            
  159. tcp6       0      0 127.0.0.1:52302         127.0.0.1:3306          ESTABLISHED 825/java            
  160. tcp6       0      0 127.0.0.1:36820         127.0.0.1:3306          ESTABLISHED 819/java            
  161. tcp6       0      0 127.0.0.1:55730         127.0.0.1:3306          ESTABLISHED 800/java            
  162. tcp6       0      0 127.0.0.1:35774         127.0.0.1:3306          ESTABLISHED 800/java            
  163. tcp6       0      0 127.0.0.1:37432         127.0.0.1:3306          ESTABLISHED 829/java            
  164. tcp6       0      0 127.0.0.1:58800         127.0.0.1:3306          ESTABLISHED 1997254/java        
  165. tcp6       0      0 127.0.0.1:60844         127.0.0.1:3306          ESTABLISHED 829/java            
  166. tcp6       0      0 127.0.0.1:57184         127.0.0.1:3306          ESTABLISHED 800/java            
  167. tcp6       0      0 127.0.0.1:33426         127.0.0.1:3306          ESTABLISHED 829/java            
  168. tcp6       0      0 127.0.0.1:38978         127.0.0.1:3306          ESTABLISHED 800/java            
  169. tcp6       0      0 127.0.0.1:36408         127.0.0.1:3306          ESTABLISHED 1997254/java        
  170. tcp6       0      0 127.0.0.1:38984         127.0.0.1:3306          ESTABLISHED 800/java            
  171. tcp6       0      0 127.0.0.1:38860         127.0.0.1:3306          ESTABLISHED 825/java            
  172. tcp6       0      0 127.0.0.1:54072         127.0.0.1:3306          ESTABLISHED 1997254/java        
  173. tcp6       0      0 127.0.0.1:55746         127.0.0.1:3306          ESTABLISHED 847/java            
  174. tcp6       0      0 127.0.0.1:41618         127.0.0.1:3306          ESTABLISHED 819/java

型
但是，当尝试使用DataGrip连接到数据库时，会出现错误：
[08 S 01]通信链路故障最后一个成功发送到服务器的数据包发生在0毫秒之前。驱动程序未从服务器收到任何数据包。
更多详情请参阅日志：
idea.log

  1. 2023-06-26 22:34:52,336 [262405502]   INFO - ution.rmi.RemoteProcessSupport - /Applications/DataGrip.app/Contents/jbr/Contents/Home/bin/java -Djava.rmi.server.hostname=127.0.0.1 -Duser.timezone=UTC -Xmx2048m -Xms128m -Dfile.encoding=UTF-8 -classpath "/Applications/DataGrip.app/Contents/lib/util.jar:/Applications/DataGrip.app/Contents/lib/groovy-2.5.14.jar:/Applications/DataGrip.app/Contents/plugins/DatabaseTools/lib/jdbc-console.jar:/Users/riven/Library/Application Support/JetBrains/DataGrip2021.2/jdbc-drivers/MySQL ConnectorJ/8.0.25/mysql-connector-java-8.0.25.jar" com.intellij.database.remote.RemoteJdbcServer com.mysql.cj.jdbc.Driver 
  2. 2023-06-26 22:34:52,538 [262405704]   INFO - ution.rmi.RemoteProcessSupport - Port/ServicesPort/ID: 6001/52099/RemoteDriverImpla304eaa8 
  3. 2023-06-26 22:34:52,538 [262405704]   INFO - ution.rmi.RemoteProcessSupport -  
  4. 2023-06-26 22:34:52,555 [262405721]   INFO - atabaseCredentialsAuthProvider - Connecting as: ExBot 
  5. 2023-06-26 22:34:52,555 [262405721]   INFO - .DatabaseConnectionEstablisher - Connecting to: jdbc:mysql://91.149.xxx.xxx:3306/ExLandSite 
  6. 2023-06-26 22:35:08,444 [262421610]   WARN - .DatabaseConnectionEstablisher - Connecting to: jdbc:mysql://91.149.xxx.xxx:3306/ExLandSite 
  7. 2023-06-26 22:35:08,444 [262421610]   WARN - .DatabaseConnectionEstablisher - Connection reset 
  8. 2023-06-26 22:35:08,445 [262421611]   WARN - alects.mysql.MysqlErrorHandler - Connection reset 
  9. java.net.SocketException: Connection reset
  10.     at java.base/java.net.SocketInputStream.read(SocketInputStream.java:186)
  11.     at java.base/java.net.SocketInputStream.read(SocketInputStream.java:140)
  12.     at com.mysql.cj.protocol.ReadAheadInputStream.fill(ReadAheadInputStream.java:107)
  13.     at com.mysql.cj.protocol.ReadAheadInputStream.readFromUnderlyingStreamIfNecessary(ReadAheadInputStream.java:150)
  14.     at com.mysql.cj.protocol.ReadAheadInputStream.read(ReadAheadInputStream.java:180)
  15.     at java.base/java.io.FilterInputStream.read(FilterInputStream.java:133)
  16.     at com.mysql.cj.protocol.FullReadInputStream.readFully(FullReadInputStream.java:64)
  17.     at com.mysql.cj.protocol.a.SimplePacketReader.readHeader(SimplePacketReader.java:63)
  18.     at com.mysql.cj.protocol.a.SimplePacketReader.readHeader(SimplePacketReader.java:45)
  19.     at com.mysql.cj.protocol.a.NativeProtocol.readMessage(NativeProtocol.java:540)
  20.     at com.mysql.cj.protocol.a.NativeProtocol.readServerCapabilities(NativeProtocol.java:498)
  21.     at com.mysql.cj.protocol.a.NativeProtocol.beforeHandshake(NativeProtocol.java:385)
  22.     at com.mysql.cj.protocol.a.NativeProtocol.connect(NativeProtocol.java:1351)
  23.     at com.mysql.cj.NativeSession.connect(NativeSession.java:157)
  24.     at com.mysql.cj.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:953)
  25.     at com.mysql.cj.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:823)
  26.     at com.mysql.cj.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:453)
  27.     at com.mysql.cj.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:246)
  28.     at com.mysql.cj.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:198)
  29.     at com.intellij.database.remote.jdbc.helpers.JdbcHelperImpl.connect(JdbcHelperImpl.java:629)
  30.     at com.intellij.database.remote.jdbc.helpers.MysqlBaseJdbcHelper.connect(MysqlBaseJdbcHelper.java:179)
  31.     at com.intellij.database.remote.jdbc.impl.RemoteDriverImpl.connect(RemoteDriverImpl.java:54)
  32.     at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  33.     at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
  34.     at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  35.     at java.base/java.lang.reflect.Method.invoke(Method.java:566)
  36.     at java.rmi/sun.rmi.server.UnicastServerRef.dispatch(UnicastServerRef.java:359)
  37.     at java.rmi/sun.rmi.transport.Transport$1.run(Transport.java:200)
  38.     at java.rmi/sun.rmi.transport.Transport$1.run(Transport.java:197)
  39.     at java.base/java.security.AccessController.doPrivileged(Native Method)
  40.     at java.rmi/sun.rmi.transport.Transport.serviceCall(Transport.java:196)
  41.     at java.rmi/sun.rmi.transport.tcp.TCPTransport.handleMessages(TCPTransport.java:562)
  42.     at java.rmi/sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run0(TCPTransport.java:796)
  43.     at java.rmi/sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.lambda$run$0(TCPTransport.java:677)
  44.     at java.base/java.security.AccessController.doPrivileged(Native Method)
  45.     at java.rmi/sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run(TCPTransport.java:676)
  46.     at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128)
  47.     at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628)
  48.     at java.base/java.lang.Thread.run(Thread.java:829)
  49.     Suppressed: com.intellij.database.util.AsyncTask$Frame$FrameData: Async frame data: Test Connection -> Prepare connection -> Establish database connection -> Get database credentials -> Perform database connection
  50. 2023-06-26 22:35:08,445 [262421611]   INFO - ution.rmi.RemoteProcessSupport - Terminating: 127.0.0.1:6001/RemoteDriverImpla304eaa8 
  51. 2023-06-26 22:35:08,485 [262421651]   INFO - ution.rmi.RemoteProcessSupport - Process finished with exit code 137 (interrupted by signal 9: SIGKILL)

型
我尝试通过telnet测试连接：

  1. telnet 91.149.xxx.xxx 3306
  2. Trying 91.149.xxx.xxx...
  3. Connected to leased-line-91-149-xxx-xxx.telecom.by.
  4. Escape character is '^]'.
  5. Connection closed by foreign host.

型
值得注意的是，当我通过portchecker.co/checking检查端口时-数据包到达路由器（我可以通过路由器接口看到这一点），当我尝试通过DataGrip或telnet连接时-数据包没有到达路由器。

  1. mysqld --validate-config
  2. 2023-06-28T19:31:32.936163Z 0 [Note] [MY-013667] [Server] Error-log destination "stderr" is not a file. Can not restore error log messages from previous run.
  3. 2023-06-28T19:31:32.939545Z 0 [Note] [MY-010747] [Server] Plugin 'FEDERATED' is disabled.
  4. 2023-06-28T19:31:32.939929Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'MyISAM'
  5. 2023-06-28T19:31:32.939955Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'CSV'

型
我不明白为什么我不能连接到我的数据库，我已经尝试了大量的文章在互联网上-没有工作。我已经试过其他方法了。
我试着在mysql设置中将ip从www.example.com更改127.0.0.1为0.0.0.0。我试着将mysql用户从@localhost升级到我的ip。

ubuntu

2条答案

按热度按时间
k5hmc34c

k5hmc34c1#

似乎问题可能与启用的TLS版本-https://youtrack.jetbrains.com/issue/DBE-13313有关
自DataGrip 2021.1版本以来，它应该会自动建议为无法通过TLS 1.3访问的MySQL服务器启用TLS 1.1：
x1c 0d1x的数据
尝试上述的一种变通方法，例如，尝试在DataGrip上设置enabledTLSProtocols = TLSv1.1，位于数据源属性>高级选项卡

赞(0）分享  回复(0）举报  2023-08-03
5hcedyr0

5hcedyr02#

我为自己找到了解决办法。修改mysql配置中的端口对我有帮助。我只是改变了一个不同的端口，打开它在路由器和一切工作，我可以连接到数据库，我可以管理它.

赞(0）分享  回复(0）举报  2023-08-03
我来回答

相关问题

    查看更多

    热门标签

    更多
    JavaquerypythonNode开发语言requestUtil数据库Table后端算法LoggerMessageElementParser

    最新问答

    更多
    • 蜀ICP备13028337号-1 大数据知识库 https://www.saoniuhuo.com © All rights reserved
    • 本站内容来源互联网,如果侵犯您的权益请联系我们删除, 联系方式：448109455@qq.com