I was trying to connect to a MySQL server at work and I got connection fail “Too many connections”. Here’s the screen shot that I took using Navicat Lite client and Sequel Pro.

I did Googling a bit and I found that most common problem is because MySQL has too many open client being connected [...]

There are times when we want to query a database structure for a particular table name. Or you want to find which tables a particular column name is defined. Or in my case, I wanted to find all tables that has column A and column B defined … how do I do it?
If you are [...]

Error can’t create table …
I was trying to add new table and alter another table to add new column and foreign key to the new table. Here’s basically what I had

CREATE TABLE `chapters` (
`chapter_id` int(10) unsigned NOT NULL auto_increment,
`chapter_title` varchar(255) NOT NULL,
PRIMARY KEY (`chapter_id`)
);

ALTER TABLE `articles`
[...]