Database Super User Creation Script

This repository offers scripts designed to streamline the process of creating super users for MariaDB or MySQL databases. With just a few prompts, these scripts handle user creation and assign all necessary privileges, enabling the new super user to access the database from a specified IP address. Scripts are available in PHP, Bash, and Python, catering to diverse operational environments.

Utilizing these scripts not only simplifies database user management but also minimizes the risk of manual errors. They're especially handy for developers and database administrators who frequently work with MariaDB and MySQL databases.

Simply choose your preferred scripting language, follow the guidelines provided, and have your super user set up in no time!

This repository contains scripts for creating a super user in MariaDB/MySQL databases. Scripts are provided in 3 languages: Bash, Python and PHP.

Table of Contents

• Requirements
• Usage
  • Bash
  • Python
  • PHP
• Support
• Contribution

Requirements

1. MariaDB/MySQL: Ensure you have MariaDB or MySQL installed and accessible from the command line.
2. Bash: For the Bash script, you should be on a UNIX-like system or have Bash installed on Windows (e.g., through WSL).
3. Python: For the Python script, ensure you have Python 3 installed.
4. PHP: For the PHP script, you need to have PHP CLI installed.

Usage

Bash

1. Save the Bash script as create_db_user.sh.
2. Give it execute permissions: chmod +x create_db_user.sh
3. Run the script: ./create_db_user.sh

Python

1. Save the Python script as create_db_user.py.
2. Run the script: python3 create_db_user.py

PHP

1. Save the PHP script as create_db_user.php.
2. Run the script: php create_db_user.php

Python Script Usage Example

1. Script Execution: Start by running the create_db_user.py script.

   $ python3 create_db_user.py

   Output:

   Which database are you using (mariadb/mysql)? 

2. Database Choice: Here, provide your choice of database (mariadb or mysql).

   mariadb

   Output:

   Username: 

3. Entering Username: Input the username you wish to create.

    mysuperuser

   Output:

   Password:

4. Entering Password: Provide the desired password.

    supersecretpassword

   Output:

   IP Address:

5. IP Address Input: Specify the IP address from which the user can connect.

    192.168.1.100

   Output:

   Operation completed.

Support

For support, issues, or feedback, please open an issue on this repository.

Contribution

Contributions, issues, and feature requests are welcome. Feel free to check issues page if you want to contribute.