Video of the week: Madlib - Beat Konducta in India

Micro-Recipe: Ubuntu Mysql Root Password Restoring

Here are the bare bone commands to restore your mysql root password ->

• /etc/init.d/mysql stop
• /usr/bin/mysqld_safe –skip-grant-tables &
• mysql -u root mysql
• mysql> UPDATE user SET Password=PASSWORD('newpassword') WHERE User='root';
• mysql> FLUSH PRIVILEGES;
• mysql> exit;

Testing if it works ->

• /etc/init.d/mysql restart
• mysql -u root -p
• Enter password:
• mysql> You win !

Then add a mysql user with all privileges ->

• mysql -u root -p
• mysql> GRANT ALL PRIVILEGES ON *.* TO 'login'@'localhost' IDENTIFIED BY 'pass' WITH GRANT OPTION;
• mysql> FLUSH PRIVILEGES;

My Online Personas Graph

Here is a graph of my multiple online personas, that is to say identities.

You can see that twitter is the most connected persona. Almost everyone can access it and it can penetrate a lot of the other personas.

Do you see the small OpenID persona on the bottom-right ? What I would really like for 2008 is to connect it to every other personas !

Facebook knows your friends without you having an account

Today I observed a friend going to the facebook site to create an account. Very usual process, but it was surprising that the first time she got through the facebook's walled garden, she already had almost 10 friends without asking anybody ! Indeed, many of her friends invited her months ago, so when she finally decided to create an account the system kept her contacts. Funny, scary or very smart ? You choose !