RDS : ERROR 2003 (HY000): Can’t connect to MySQL server (10060)

When a MySQL-client tries to connect to mysql server over AWS cloud, mysql-server sends back an error  “RDS : ERROR 2003 (HY000): Can’t connect to MySQL server (10060)” . This error states that the inbound/outbound traffic from AWS instance is not reachable to the current host where you are running your MySQL-client. So first a user need to register his public IP address in the RDS security groups to get access over the RDS MySQL instance. [Read more…]

SQLyog- Importing MS Excel table into MySQL Database

SQLyog Importing MS Excel table into MySQL Database Importing MS Excel tables into MySQL database takes more time and efforts while playing around the application development or any college assignments. This article explains how you can import large excel tables into MySQL database within few minutes without writing a code in any language like Java or C++. Here in this example, we are not going to write any SQL query to import tables. Although prerequisites for this exercise is MySQLyog.   [Read more…]