Lists users from all wordpress databases on a MySQL/MariaDB database

listwpusers.py

#!/usr/bin/python3
#
# Lists users from all wordpress databases on a MySQL/MariaDB database
#
# Copyright (c) 2018 Benjamin Bryan
#
# Permission is hereby granted, free of charge, to any person obtaining a copy
# of this software and associated documentation files (the "Software"), to deal
# in the Software without restriction, including without limitation the rights
# to use, copy, modify, merge, publish, distribute, sublicense, and/or sell
# copies of the Software, and to permit persons to whom the Software is
# furnished to do so, subject to the following conditions:
# 
# The above copyright notice and this permission notice shall be included in all
# copies or substantial portions of the Software.
# 
# THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR
# IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY,
# FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THE
# AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER
# LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING FROM,
# OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN THE
# SOFTWARE.
#
# How to Install Python on Ubuntu:
# sudo apt install python3
# sudo apt install python3-mysql.connector
#
# Edit your connection parameters (below)
#
# chmod 700 listwpuser.py
# Run with:
# ./listwpusers.py

import mysql.connector
import getpass

mysql_host = input('MySQL Hostname or IP: ')
mysql_user = input('MySQL User: ' )
mysql_pass = getpass.getpass(prompt='MySQL Password: ')
mysql_port = input('MySQL Port: ')


cnx = mysql.connector.connect(user=mysql_user, password=mysql_pass, host=mysql_host, port=mysql_port)
cursor_databases = cnx.cursor(buffered=True)
cursor_tables = cnx.cursor(buffered=True)
cursor_users = cnx.cursor(buffered=True)


databases = ("SHOW DATABASES")
cursor_databases.execute(databases)

for databases in cursor_databases:
    tables = ("SHOW TABLES IN " + databases[0] + " WHERE Tables_in_" + databases[0] + " LIKE '%_users'")
    cursor_tables.execute(tables)

    for tables in cursor_tables:
        users = ("SELECT user_login FROM " + databases[0] + "." + tables[0])
        cursor_users.execute(users)

        for users in cursor_users:
            print(databases[0] + "." + tables[0] + " " + users[0])

cnx.close()