MySQL and PHP on windows

The last few days I have been setting up a wiki at work using MediaWiki

MediaWiki needs PHP and some sort of database. I chose MySQL.

If I was on a linux server then all would probably have been fairly easy but sadly I am saddled with windows servers here.

If it was a fresh intall then I could probably have used WAMP but apache was already is use for other applications.

So I had to install MySQL & PHP manually. I installed MySQL with no problems, set up the required database and all looked good.

I installed PHP using the provided msi file and selected MySQL from the list of extensions.
When I ran a test php file to see phpinfo() there was no mention of MySQL. This appears to be a very common problem and no mention of the solution was easy at hand.

So the solution.
Copy the file libmySQL.dll from the bin directory of your MySQL install to your WINDOWS/system32 directory

Getting mysql gui tools working on ubuntu 7.10

I had three hurdles to get over to get mysql gui tools to work.

1. My first problem was that I got the error

 /bin/sh: bad interpreter: Permission denied

when I tried running mysql-administrator

This was because my mounted directory did not have exec permissions. Adding 'exec to the row in /etc/fstab, then umount & mount solved this.

 /dev/hdb1       /media/d_drive  auto    rw,user,exec  0       0

2. My next problem was the following error:

./mysql-administrator

(mysql-administrator-bin:7476): Gtk-WARNING **: Unable to locate theme engine in module_path:  "ubuntulooks",
Fontconfig warning: line 32: unknown element "cachedir"
Fontconfig warning: line 33: unknown element "cachedir"
Fontconfig warning: "/etc/fonts/conf.d/80-delicious.conf", line 18: invalid match target "scan"
./mysql-administrator-bin: symbol lookup error: /usr/lib/libbonoboui-2.so.0: undefined symbol: g_once_init_enter_impl

I eventually found this. The fix is right at the end.
To cut a long story short.

cd to where you have unpacked the gui tools
mv lib lib_
& if
/etc/mysql/conf.d does not exist
mkdir /etc/mysql/conf.d

3. My third and hopefully last problem was that I could not connect to localhost:3306
However I could connect to 127.0.0.1:3306
My /etc/hosts looked like this.

127.0.0.1       localhost
127.0.1.1       billspc

# The following lines are desirable for IPv6 capable hosts
::1     ip6-localhost ip6-loopback
fe00::0 ip6-localnet
ff00::0 ip6-mcastprefix
ff02::1 ip6-allnodes
ff02::2 ip6-allrouters
ff02::3 ip6-allhosts

I am not sure if this is a good fix but the cure was to comment out the line

#::1     ip6-localhost ip6-loopback