Install ruby's mysql gem on Windows 7

I have mysql database on my computer. I would like to use Ruby to access it.

First step is to install mysql gem. Run this at command prompt:

gem install mysql

Next step is to download the libmysql.dll
Here's the link to download the dll
http://dev.mysql.com/get/Downloads/Connector-C/mysql-connector-c-noinstall-6.0.2-win32.zip/from/pick
Extract the downloaded file, and go to the 'lib' directory and copy 'libmysql.dll'.

Now go to your ruby installation folder, open the "bin" folder, then paste the "libmysql.dll".

That's all.

How to test it? Create a ruby file, and type

require 'mysql'

Then run it. You won't see any error if the installation was successful.

Install Chrome for all users in Windows 7

I created a new user account in Windows 7. When I logged in using the new account, I could not find Chrome browser.

How to solve this problem?

1. Log in using administrator account
2. Uninstall Chrome (https://support.google.com/chrome/answer/95319?hl=en)
3. Download this alternate Chrome installer: https://www.google.com/intl/en_uk/chrome/browser/index.html?system=true&standalone=1#eula
4. Done

The alternate Chrome version will install Chrome for all user accounts (https://support.google.com/chrome/answer/118663?hl=en).

However, there's a problem with the Chrome for administrative account. There's an error saying "Your profile cannot be used because it is from newer version of Google Chrome".

To fix it, go to this folder:

C:\Users\YOURUSERNAME\AppData\Local\Google\Chrome\User Data\Default

(Note: if you can't see the AppData folder, you have to activate the "Show hidden files" option in the folder option)

Then delete the "Web data" file.

Then I tried to open the Chrome but nothing happened.

So, I log out from Windows, then log in again.

Now everything's allright.

Can't start CyberLink YouCam on Windows 7

CyberLink YouCam 3 can't be open on my Windows 7 laptop. There's nothing happen when I tried to open it.

I found 2 solutions for this problem.

Solution 1: Run it as administrator. Just right click on the program link, then choose "Run as administrator".

Solution 2: Right click on the program link, then choose "Troubleshoot compatibility".
Choose "Try recommended settings", then choose "Start the program". If YouCam is started, then you can just click "Next" and choose "Yes, save these settings for this program".