A common mistake that people make when trying to design something completely foolproof is to underestimate the ingenuity of complete fools.

Douglas Adams

Entries in the 'MySQL' category

  • Change MySQL password

    Unlike WAMPServer on Windows,MAMP on Mac OS X some with a password already set for the root user, ‘root‘. I found quite a few posts regarding changing this password usinf the following command in the terminal: /Applications/MAMP/Library/bin/mysqladmin -u root -p password What wasn’t clear from this is that in this instance password is not a placeholder for your password that you should replace but in fact an actual command. After typing or pasting this command, with replaced with the password you want to use you are then prompted for your existing password, ‘root‘. I tried several times with my Mac password because that is what I normally enter when terminal propmts me to ‘Enter Password‘. Felt a bit stupid for wasting half an hour or so but it is sorted now.

    Categories:Web Design|MySQL

  • Meteor Classification

    I have been running some queries to classify the meteor types in the meteor visualisation data. I’m running the smallest groups first so that I can run one final ‘set empty classes to chondrite’ query at the end as they are by far the group with the biggest range of type codes in the table. The third of these queries felt distinctly middle-earthy, with all it ‘-ites’. I imagined this group of meteorite to be somewhat like the dwarves from ‘The Hobbit’. UPDATE `type_lookup` SET `Class` = ‘Iron (Chemical Classification)’ WHERE `Type` LIKE ‘Iron%’ UPDATE `type_lookup` SET `Class` = ‘Carbonaceous Chondrite’ WHERE `Type` LIKE ‘C%’ UPDATE `type_lookup` SET `Class` = ‘Achondrite’ WHERE `Type` LIKE ‘Eucrite%’ OR `Type` LIKE ‘Howardite%’ OR `Type` LIKE ‘Diogenite%’ OR `Type` LIKE ‘Shergottite%’ OR `Type` LIKE ‘Nakhilites%’ OR `Type` LIKE ‘Chassigniteite%’ OR `Type` LIKE ‘Lunar%’ OR [...]

    Categories:Web Design|MySQL

  • MySQL User Password

    Quick reminder on how to start set up of MySQL on a WAMP installation

    Categories:Web Design|MySQL