How to create a new MySQL database and user from the command prompt

1. Start mysql.exe, the MySQL monitor:

C:\Program Files\mysql\mysql-5.0.77-win32\bin> mysql.exe -h localhost --user=root -p

2. Create the user and set the password:

mysql> CREATE USER theusername@localhost IDENTIFIED BY 'thepassword';

3. Make sure the new user appear in the user table:

mysql> SELECT * FROM mysql.user;

4. Create the database:

mysql> CREATE DATABASE yourdatabase;

5. Make sure your database was created:

SHOW DATABASES;

6. Grant all privileges for your new database to your user:

mysql> GRANT ALL ON yourdatabase.* to theusername@localhost;

7. Done. Now you got a new database and a new user with all privileges.

MicroBuzz - Your Microblog Search Engine

I've been playing around with Google's custom search. And here's the result, a microblog search engine:



MicroBuzz searches tweets on Twitter, YouAre, Koornk, Rejaw, Jaiku, Bloggy, Kwippy, FriendFeed, BrightKite, Identi.ca and Plurk.

Hope you find it useful!

Google killing Internet Explorer 6.0 at google.se

This is what appears when browsing Google.se with Internet Explorer 6.0. Notice the ad for Google Chrome:






From Stefan at Bloggy.

Framing gone wild

Framing gone wild. Click on the screenshot if the link does not work:



Do you think it is ok to frame publishers' content, like Digg, Krumlr, HootSuite, Ow-Ly, Facebook and StumpleUpon are doing?

Adsense ads + framed content allowed?

Is it allowed to frame someone else content, and show Google AdSense ads, like this?



Digg and Facebook are also framing publisher's content.

New photo: Red apple core nine days

Gmail Autopilot

More available here:
http://mail.google.com/mail/help/autopilot/index.html

Youtube upside down

conflicker

no, it's conficker, not conflicker.

Removal tool available from Microsoft.