Create a MySQL Database, Username, Password, and Privileges from the command line

Step 1: Login to MySQL ( you will need an account )
[code]user@server:~$ mysql -u mysql_user -p
Enter password:[/code]

Step 2: Create the Database
[code]mysql > create database db_name;[/code]

Step 3: Verify that it’s there
[code]mysql > show databases;[/code]

Step 4: Create the User
[code]mysql > create user db_user;[/code]

Step 5: Grant privileges while assigning the password
[code]mysql > grant all on db_name.* to ‘db_user’@’localhost’ identified by ‘db_password’;[/code]
*Note: The localhost field usually doesn’t have to be edited, but you can set it to the specific address.

The above example grants all privileges, obviously. But you will likely want to limit privileges under many circumstances. These parameters include select, insert, and delete.
Choose all that apply and separate by comma:
[code]mysql > grant select, insert, delete, update on db_name.* to ‘db_user’@’localhost’ identified by ‘db_password’;[/code]

Google Reader Player

This simple Flash-based code from Google embeds the following player controls.
[code]<embed type=”application/x-shockwave-flash” width=”400″ height=”27″ src=”” flashvars=”audioUrl=″ quality=”best”></embed>[/code]

Features: Flash-based. Plays single track/file.
Positive: Great for the occasional sound clip & large files. Easy to swap in your own MP3 file paths.
Negative: Cannot modify colors/dimensions. Sticks out like a sore thumb.
Source: Google Reader Player

Yahoo! Media Player

UPDATE: July 01, 2013

It has come to my attention that this plugin has vanished from Yahoo without a trace. If you were wise enough to host your own local copy, my hat’s off to you. I was not so wise. However, it’s sudden disappearance forced me to build my own WordPress plugin, PressPlay Lite, which is now available on A full featured version is in development, btw.


This innovative script from Yahoo! has automatically detected the following textual MP3 links and embedded a simple play button next to each of them.

  1. Afterworld
  2. Frame Of Reference
  3. The Heart To Tell
  4. Watch Your Step
  5. Coma Fantasy
  6. Remiss

It also automatically organizes all recognized MP3 links within the page into a playlist, which appears when any play button is clicked. Furthermore, visitors can choose to keep the playlist running in a separate window while they continue to browse your site.
All you need to do is add the normal textual MP3 links you see above as the highlighted song titles, and place the following code somewhere above the first link (place it in the <head> tag to use exclusively throughout the site):
[code]<script type=”text/javascript” src=””></script>[/code]
About: JavaScript-based. Automatically embeds play button next to audio links. Creates playlist out of all audio links on page. Option to open playlist in new tab/window.
Positive: Easiest setup – by Far ! Create an MP3 link, and it’s there! The button design is neutral enough to blend in with any site.
Negative: Buffering could be smoother – I have noticed some clipping on larger files. You are stuck with a “master” playlist – cannot break it up into smaller groups. Also stuck with the built-in player design, including the floating button seen in the bottom-left of the screen.
Source: Yahoo! Media Player

Play Tagger by Delicious

UPDATE: July 1, 2013

Just like Yahoo! MediaPlayer, this plugin has also mysteriously disappeared. However, you can get something just like it (better, IMHO), called PressPlay Lite, which is now available on


Not shown. As easy to setup as Yahoo! Media Player…
[code]<script src=”” type=”text/javascript”></script>[/code]
… but doesn’t readily display as expected. Also, hitting play bumps the corresponding text to the right for no apparent reason.
Positive: Easy implementation.
Negative: Button doesn’t automatically align to text. Can’t change color.
Source: Play Tagger by Delicious

Audio Player (WordPress Plugin)

A WordPress Plugin that adds this sleek Flash controller to the MP3 files of your choice. Also available as a stand-alone [audio:|titles=The Heart To Tell]
Positive: Stylish. Can match your theme’s color scheme.
Negative: Requires additional CSS/HTML coding to control positioning on the page. Not easily managed by non-developers.