Day: October 15, 2008

Technology

MySQL Grants List Revealed

October 15, 2008 by 0 Comments

A colleague of mine just sent me this hugely useful MySQL command for seeing which users have privileges in a database, and from which host. It prints a list of other MySQL commands which can then be used to show more precisely what privileges that user has been granted.

SELECT DISTINCT CONCAT('SHOW GRANTS FOR ''',user,'''@''',host,''';') AS query FROM mysql.user;

Prior to this, I found myself having to connect to the database from the appropriate (remote) MySQL client and issue a SHOW GRANTS from there.

Thanks to Mate Racz for this one.

Life

Brain Surgery with a Banjo

October 15, 2008 by 2 Comments

We’ve all seen the documentary where the surgeon operates on a patient’s brain while the patient is still awake, placing electrodes at various points in and around the brain, observing the patient’s behaviour and responses to certain tasks they are asked to say and do, thus increasing the accuracy and effectiveness of their work.

Well, surgeons in the Nashville, Tennessee have just taken this to a new level with the legendary Blue Grass musician Eddie Addock. They actually asked Eddie to bring his Banjo with him to the operating theatre and had him play it while they operated on brain, ensuring that their efforts to cure his essential tremor symptoms didn’t adversely affect his livelihood and life-long passion for music.

So what would you bring to the operating theatre to aid the surgeons?

Source: SlashDot