test – FirstSearch Blue

Create new MySQL user and allow them to connect from any IP

If you are getting the error: user is not allowed to connect to this MySQL serverConnection closed by foreign host Or : Access denied for user ‘root’@’somehost.com’ (using password: YES)) Then you probably have not created your user properly in MySQL Here is how to create a new MySQL user and give him access to… Continue reading Create new MySQL user and allow them to connect from any IP

MySQL See all columns and tables that foreign key to a table or column

If you’re trying to understand how an existing database has been setup it can be very useful to see all of the tables/columns that foreign key into some other table/column. use INFORMATION_SCHEMA; select TABLE_NAME,COLUMN_NAME,CONSTRAINT_NAME, REFERENCED_TABLE_NAME,REFERENCED_COLUMN_NAME from KEY_COLUMN_USAGE where REFERENCED_TABLE_NAME = ‘your_table_name’ AND REFERENCED_COLUMN_NAME = ‘your_column_name’

Ruby MySQL Transaction Example

Here is a simple tutorial showing how to implement transactions in Ruby with MySQL. The code uses The MySQL2 Gem. We are showing the insert of 2 records into the customers table of a database. If either insert fails, both will be rolled back. require “mysql2” client_mysql = Mysql2::Client.new(:host =>; “localhost”, :username =>; “my_user”, :password… Continue reading Ruby MySQL Transaction Example

Setup a new GIT repository

Here is a quick reminder of how to setup a new git repository on your git server and check it out on your client machine. On The Server cd /opt/git mkdir newproject.git cd newproject.git git –bare init On the Client cd /home/user/projects git clone git@gitserver:/opt/git/newproject.git cd newproject vim README git add . git commit -m… Continue reading Setup a new GIT repository

Medical Alert Systems for 2013

As our loved ones age, their safety becomes of real concern to us, especially when they are living alone or have a disability or illness. These days, we all lead extremely busy lives and we don’t always have the time to call around and check in on our elderly friends and relatives as much as… Continue reading Medical Alert Systems for 2013

Atmel SAM-ICE Debug Error

Failed to launch program Error: reading arm chip id failed This error is caused when the JTAG interface is selected in the Tool section of the Project settings. To fix the the issue, select SWD from the drop down. We initially thought that the SAM-ICE was only a JTAG debugger and didn’t work with Serial Wire… Continue reading Atmel SAM-ICE Debug Error

How to Find a Good Roommate on Craigslist

Although it’s not ideal to live with a stranger, sometimes it’s necessary. If you’ve moved to a new city and don’t know anyone, for instance, you might need to share a living space with a stranger to cut costs. Or if your former roommate moved out, and you need someone to move in with you… Continue reading How to Find a Good Roommate on Craigslist

Patent Suggests that Apple is Considering a Flexible Screen Component

According to Mashable, Apple submitted a patent application revealing a possible integration of flexible OLEDs (organic light emitting diode) that could bend with the existing Apple Smart Cover. The Ultra-Cool Concept The patent sketches serve up possibilities that make Microsoft’s Surface Tablet seem dull. The Apple Smart cover is a flexible cover that protects the… Continue reading Patent Suggests that Apple is Considering a Flexible Screen Component

Top 10 Obstacles You Must Overcome to Create a Successful Internet Weight Loss Business

Obesity has become a major health issue over the last two decades and over fifty per cent of adults say they want to lose their spare pounds. However, if you want to establish an internet weight-loss business you need to be aware of the most common obstacles.Capital Setting up an internet weight-loss business does not… Continue reading Top 10 Obstacles You Must Overcome to Create a Successful Internet Weight Loss Business