To make sure this program runs as designed Python 3.8 should be installed. This project has many modules incorporated, some of which are not included by default. Any missing modules have to be installed with PIP before the program can run. I recommend simply enter the module name in search engine and finding the documentation. The PIP command for installation is usually one of the first things mentioned. Also with Python it is common to have multiple modules with a similar names. So if errors are being raised about not having a certain module it is most likely the wrong module with a similar name to the one that is required was installed instead of the required module.
Enter Python downloads in a search engine and obtain version 3.8 from the official website. Run the installer and follow the default installation procedures. Also search for any required modules and install them with PIP in Command Prompt.
This program automates creating MySQL databases from attached custom modules. The databases included are sample data sets.
- Download a xampp online ()
- Open the xampp control panel and start the MySQL service
- Open up Command Prompt (CMD)
- Enter the directory containing the program and execute in shell (dbBuilder.py)
Note: Using a xampp might cause issues with creating users and permissions. If this occurs line 83 - 176 can be commented out or try to adjust xampp settings. Reguardless if will create databases & tables with the ability to alter & populate them.