Hey all. I've been (trying) to work on learning python+django over my winter break, but I've run into a road block that is beyond my knowledge. In trying to get MySQL up and running correctly (and connected with Python by using MySQLdb) I have run into error after error. Not sure where I am stumbling on this, and online forums/documentation has been unhelpful so far.
So, my question is if anyone has (1) experience getting MySQL up and running and (2) the time to try to talk me through getting it up an running on my computer.
It's worth noting that I'm running the Tiger OS (Mac 10.4) on a powerpc chip.
mysqldb
For me, installing mysql by itself is easy. The problem I ran into was trying to get mysqldb to run with python 2.5. Mysqldb is program/library that allows python to connect to mysql. The problem is that mysqldb has not been updated for python 2.5 released this September. In the end I had to email someone and ask them for an mysqldb binary that works with python 2.5. Of course this was on windows xp. A couple weeks ago, Dan Reinbold, a Mac-user roommate of mine, decided to get django running on his computer. He had already installed python 2.5 for python class, but that was pretty much it. So, he installed django very easily, and mysql with ease, but he ran into the same problem I did. He could not find mysqldb binaries for mac os x and python 2.5. In the end I think he ended up downgrading python back to 2.3 (the version that comes with mac os x), and copying the mysqldb files to many folders on his computer until he finally got it to work.
So all I really say is:
Good Luck,
Collin
mysql
I also recomend getting phpmyadmin whether you use php or not. It is somewhat easy to install on mac os x (I dont think php comes preinstalled, but apache 1.3 does). I have been working with django over the last month or so, and I have found that many times the syncdb command does not correctly sync the database, and I end up going into phpmyadmin and emptying the database before running syncdb. Anyway, phpmyadmin helps you see what is going on on the database level, and it makes creating databases and users very easy. It may be able to show you if at least mysql is working if mysqldb is not.