MAMP Pro – Access MySQL from another machine

To access MySQL that has been installed as part of MAMP:

1.  Click on FileEdit Template and then MySQLmy.cnfScreen Shot 2014-03-18 at 14.55.06

2. On line 37 (normally) you will see the bind-address = 127.0.0.1 (localhost) by default. Change this to: 0.0.0.0

Screen Shot 2014-03-18 at 14.55.50

3. Open phpMyAdmin on the local machine, click on the Users tab and then Add user

Screen Shot 2014-03-18 at 14.58.19

4. Enter details of the username and password. On the Database for user section choose Grant all privileges on wildcard name. Check all privileges for the user. (Ensure that Grant is ticked under Administration)

Screen Shot 2014-03-18 at 14.59.30

Click on Add user.

5. Restart the MAMP servers.

NI Railways Wifi – not connecting – solved!

After nearly 1 hour of trying to decipher the problem why when trying to connect to the Wifi Service on the train and getting an error, I have finally found the issue.

The error you get is that the page re-directs to itself in a never-ending loop. This happens regardless of whether using Windows or MacOs.

If you have configured a different DNS server (e.g. 8.8.8.8) then you cannot connect to the NI Railways Wifi, you have to use their DNS servers, and set them to automatic.

Phew – finally online!

Mac Os – Convert .dmg files to .iso (ISO-9660 Filesystem)

To convert a .dmg file to .iso on Mac OS is really easy.

Open Terminal and type (if your file is on the desktop):

hdiutil makehybrid -o ~/Desktop/outputFile ~/Desktop/sourceFile.dmg

NB. The outputFile DOES NOT have a file extension, only the source file has the .dmg extension.

This converts the .dmg to an ISO-9660 compatible ISO.

Windows 95

As is always useful when making a virtual machine running Windows 95 to test your websites on (yes, there are still users out there running Windows 95!)

Download Windows 95b ISO (ISO-9660)

Some keys:

Windows 95 OEM Version : CD-Key:
12095-OEM-0004226-12233 or
15795-OEM-0001355-07757 or
16595-OEM-0001695-96524

Windows 95 OEM Version (02) :
16595-OEM-0001695-96527 or
30095-OEM-0006161-61513 or
17295-OEM-0001085-48667

Windows 95 OEM Version (03) :
17295-OEM-0001922-52683 or
15395-OEM-0001292-85449 or
11495-OEM-0000052-26220

Windows 95 OEM Version (04) :
10092-OEM-0002302-92097 or
10092-OEM-0002302-93345 or
11195-OEM-0000043-04590

Windows 95 OEM Version (05) :
11195-OEM-0000043-06390 or
27195-OEM-0003272-10122 or
11195-OEM-0000043-05620

Windows 95 OEM Version (06) :
15395-OEM-0001292-85467 or
15395-OEM-0001292-85402 or
15095-OEM-0001175-61439

Windows 95 OEM Version (07) :
11495-OEM-0000052-21091 or
11495-OEM-0000043-11092 or
11195-OEM-0000043-04872

Windows 95 OEM Version (08) :
13995-OEM-0000777-79637 or
15095-OEM-0001175-46652 or
15695-OEM-0001346-00881

Windows 95 OEM Version (09) :
11195-OEM-0000043-11111 or
11195-OEM-0000043-10217 or
24995-OEM-0004361-59221

Windows 95 OEM Version (10) :
13895-OEM-0000716-90166 or
11495-OEM-0000061-97573 or
34095-OEM-0007392-52487

Windows 95 OEM Version (11) :
20795-OEM-0002723-90591 or
16095-OEM-0001535-68203 or
15095-OEM-0001166-90867

Windows 95 OEM Version (12) :
33495-OEM-0007194-19592 or
11495-OEM-0000061-97215 or
35595-OEM-0008492-43325

Windows 95 OEM Version (13) :
11895-OEM-0000194-62506 or
15095-OEM-0001166-90867 or
34895-OEM-0007662-31988

Windows 95 OEM Version (14) :
35295-OEM-0008250-79497 or
31895-OEM-0006654-61329 or
16296-OEM-0012506-78573

Windows 95 OEM Version (15) :
13895-OEM-0000716-68627 or
30195-OEM-0005315-51142 or
12496-OEM-0011212-03586

Windows 95 OEM Version (16) :
13969-OEM-0010166-05693 or
13969-OEM-0010166-05779