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
Month: March 2014
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