This collection of scripts should be useful for those wishing to create a MySQL database connection and stream data using functions from the twitter API.
- Make sure that you have created an empty database
- Ensure that your local or remote server is running (can use the MySQL Notifier to make sure, or from MySQL Workbench)
- Run the SQL script to create the appropriate table for storing the data
- Change the necessary variables for personal credentials in the python script
- Run the script
Eric D. Brown, D.Sc. -- https://pythondata.com/collecting-storing-tweets-python-mysql/