Add MySQL User | Give them Permissions On a Database

create mysql user
This simple guide demonstrates adding a new user to mysql and giving that user full access rights to a particular db within MySQL. This is really useful when you want to create a new database user for a new wordpress isntall.

You can do this from the command line of your server if you login with:
mysql -u root -p
Or you can do it from within phpmyadmin (phpmyadmin is probably the best option if you are using a web hosting account)

Before you create the new user, you will want to create a new database (you can do that from the main page of phpmyadmin)
Use the following 2 lines to create a new user named sammy with password strong_password and give him full access rights for the database called MY_DB
CREATE USER 'sammy'@'localhost' IDENTIFIED BY 'strong_password';
GRANT ALL PRIVILEGES ON MY_DB.* TO 'sammy'@'localhost' WITH GRANT OPTION;

Broadcast Video on Chat Roulette | How To

Sometimes when you’re browsing through chatroulette you notice some of your partner’s camera feeds are of recorded video or picture. You can do this too on your mac using Camtwist and Soundflower.

Setting up the video and audio channels

Camtwist can be found here and Soundflower here. Install and launch both applications. Soundflower should populate up on your global toolbar as a small flower icon like so.Thats all we need to do with Soundflower.

Go over to camtwist and under the step 1 heading, click on Movie to select it (1) then press the select button(2). Find the movie that you want to broadcast in your finder and drag it into your playlist(3). Finally click the play button to play it (4), at this point you will only hear sound.

Click to Enlarge

Press cmd+, to go to preferences and click on “General”.  In the drop-down menu for the audio output  device select “Soundflower(16ch)”.

Setting Up Chatroulette

Visit the chatroulette website and, once the website has loaded up, move your cursor over your (bottom) cam window and a few options should pop up. For cam, select “CamTwist” and for Mic select “Soundflower(16ch)” and press allow on any flash security prompts. A CamTwist screen should appear on your (bottom) cam window. Click the Start button and you are now broadcasting your movie or image to the other chatrouletter.

If you don’t see the CamTwist Icon appear on your cam window, try restarting the browser and configuring the chatroulette Cam and Mic options again.