Im about to start using mysql for databases and Im trying to figure out what is some good software to use for database creation and management outside of my actual program. It only has to be on my local machine not online on a server. Im using it with python aswell if that factors into it.

I've been using DbSchema for creating tables, relations and such. I believe MySQL has its own specific software to do that, Workbench. You should try with that first to see if it suits your needs.

You could also try HeidiSQL.

http://www.heidisql.com/

Only problem is that you don't have a visual editor for creating the whole schema. But I still prefer it for creating most of my SQL stuff.

Thanks for the help but unfortunately it doesnt work. I must be doing something wrong with the installation of mysql. I get past the installation part and on to the configure product part. But then it just hangs. I left it for over an hour and the progress bar didnt move. I assume this is the issue as when I launch any of the above programs they say cant connect to mysql. Anyone know what the issue is?