MySQL Enumeration Module - Metasploit


This page contains detailed information about how to use the auxiliary/admin/mysql/mysql_enum metasploit module. For list of all metasploit modules, visit the Metasploit Module Library.

Table Of Contents
hide

Module Overview

Name: MySQL Enumeration Module
Module: auxiliary/admin/mysql/mysql_enum
Source code: modules/auxiliary/admin/mysql/mysql_enum.rb
Disclosure date: -
Last modification time: 2017-07-24 06:26:21 +0000
Supported architecture(s): -
Supported platform(s): -
Target service / protocol: -
Target network port(s): 3306
List of CVEs: -

This module allows for simple enumeration of MySQL Database Server provided proper credentials to connect remotely.

Module Ranking and Traits

Module Ranking:

  • normal: The exploit is otherwise reliable, but depends on a specific version and can't (or doesn't) reliably autodetect. More information about ranking can be found here.

Basic Usage

msf > use auxiliary/admin/mysql/mysql_enum
msf auxiliary(mysql_enum) > show targets
    ... a list of targets ...
msf auxiliary(mysql_enum) > set TARGET target-id
msf auxiliary(mysql_enum) > show options
    ... show and set options ...
msf auxiliary(mysql_enum) > exploit

Required Options

  • RHOSTS: The target host(s), range CIDR identifier, or hosts file with syntax 'file:<path>'

Go back to menu.

Msfconsole Usage

Here is how the admin/mysql/mysql_enum auxiliary module looks in the msfconsole:

msf6 > use auxiliary/admin/mysql/mysql_enum

msf6 auxiliary(admin/mysql/mysql_enum) > show info

       Name: MySQL Enumeration Module
     Module: auxiliary/admin/mysql/mysql_enum
    License: Metasploit Framework License (BSD)
       Rank: Normal

Provided by:
  Carlos Perez <[email protected]>

Check supported:
  No

Basic options:
  Name      Current Setting  Required  Description
  ----      ---------------  --------  -----------
  PASSWORD                   no        The password for the specified username
  RHOSTS                     yes       The target host(s), range CIDR identifier, or hosts file with syntax 'file:<path>'
  RPORT     3306             yes       The target port (TCP)
  USERNAME                   no        The username to authenticate as

Description:
  This module allows for simple enumeration of MySQL Database Server 
  provided proper credentials to connect remotely.

References:
  https://cisecurity.org/benchmarks.html

Module Options

This is a complete list of options available in the admin/mysql/mysql_enum auxiliary module:

msf6 auxiliary(admin/mysql/mysql_enum) > show options

Module options (auxiliary/admin/mysql/mysql_enum):

   Name      Current Setting  Required  Description
   ----      ---------------  --------  -----------
   PASSWORD                   no        The password for the specified username
   RHOSTS                     yes       The target host(s), range CIDR identifier, or hosts file with syntax 'file:<path>'
   RPORT     3306             yes       The target port (TCP)
   USERNAME                   no        The username to authenticate as

Advanced Options

Here is a complete list of advanced options supported by the admin/mysql/mysql_enum auxiliary module:

msf6 auxiliary(admin/mysql/mysql_enum) > show advanced

Module advanced options (auxiliary/admin/mysql/mysql_enum):

   Name            Current Setting  Required  Description
   ----            ---------------  --------  -----------
   CHOST                            no        The local client address
   CPORT                            no        The local client port
   ConnectTimeout  10               yes       Maximum number of seconds to establish a TCP connection
   Proxies                          no        A proxy chain of format type:host:port[,type:host:port][...]
   SSL             false            no        Negotiate SSL/TLS for outgoing connections
   SSLCipher                        no        String for SSL cipher - "DHE-RSA-AES256-SHA" or "ADH"
   SSLVerifyMode   PEER             no        SSL verification method (Accepted: CLIENT_ONCE, FAIL_IF_NO_PEER_CERT, NONE, PEER)
   SSLVersion      Auto             yes       Specify the version of SSL/TLS to be used (Auto, TLS and SSL23 are auto-negotiate) (Accepted: Auto, TLS, SSL23, SSL3, TLS1, TLS1.1, TLS1.2)
   VERBOSE         false            no        Enable detailed status messages
   WORKSPACE                        no        Specify the workspace for this module

Auxiliary Actions

This is a list of all auxiliary actions that the admin/mysql/mysql_enum module can do:

msf6 auxiliary(admin/mysql/mysql_enum) > show actions

Auxiliary actions:

   Name  Description
   ----  -----------

Evasion Options

Here is the full list of possible evasion options supported by the admin/mysql/mysql_enum auxiliary module in order to evade defenses (e.g. Antivirus, EDR, Firewall, NIDS etc.):

msf6 auxiliary(admin/mysql/mysql_enum) > show evasion

Module evasion options:

   Name                Current Setting  Required  Description
   ----                ---------------  --------  -----------
   TCP::max_send_size  0                no        Maxiumum tcp segment size.  (0 = disable)
   TCP::send_delay     0                no        Delays inserted before every send.  (0 = disable)

Go back to menu.

Error Messages

This module may fail with the following error messages:

Error Messages

Check for the possible causes from the code snippets below found in the module source code. This can often times help in identifying the root cause of the problem.

The following accounts are not restricted by source

Here is a relevant code snippet related to the "The following accounts are not restricted by source" error message:

230:	
231:	    # Wildcard host
232:	    querywildcrd = 'select user, host from mysql.user where host = "%"'
233:	    res = mysql_query(querywildcrd)
234:	    if res and res.size > 0
235:	      print_status("\tThe following accounts are not restricted by source:")
236:	      res.each do |row|
237:	        print_status("\t\tUser: #{row[0]} Host: #{row[1]}")
238:	      end
239:	    end
240:

Go back to menu.

References

See Also

Check also the following modules related to this module:

Authors

  • Carlos Perez <carlos_perez[at]darkoperator.com>

Version

This page has been produced using Metasploit Framework version 6.1.24-dev. For more modules, visit the Metasploit Module Library.

Go back to menu.