I'm installing all my MySQL stuff in a Leopard 10.5.4 desktop and I made some mistakes along the way that I though about documenting here for future reference.
First, although the hardware and OS are 64-bit in a lot of places, the standard perl installed is not one of those. So stick with the i386 MySQL package (or try a 64bit server, but use the 32bit client...). I'm using the Proven Scaling MySQL packages mentioned earlier, and I'm happy so far.
Second, make sure your regular user has all privileges to the
test databases. I just do:
[email protected]:lib $ mysql -uroot -p Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 108 Server version: 5.0.62-enterprise-gpl MySQL Enterprise Server (GPL) Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql> grant all privileges on test.* to 'melo'@'localhost'; Query OK, 0 rows affected (0.00 sec) mysql> quit Bye
This will make your
DBD::mysql tests much happier.
Third, in case you see failing
DBD::mysql tests with:
Can't use dbi_imp_data of wrong size (127 not 124) at ...
DBI. I'm now with 1.605 and no
dbi_imp_data errors anymore. Clean