Page Ranking Tool

MySql Archive

SQLSTATE[HY000] [1040] Too many connections Error in phpMyAdmin

I was working on a Magento store and suddenly got the error message a:4:{i:0;s:43:"SQLSTATE[HY000] [1040] Too many connections";i:1;s:2884:"#0 /lib/Zend/Db/Adapter/Pdo/Mysql.php(109): Zend_Db_Adapter_Pdo_Abstract->_connect(). After doing some research on the internet, I found that it is a common error of the

How to Start, Stop and Restart MySQL by using the SSH Command?

Suppose there is any problem or your MySQL has stopped working and you need to restart the MySQL by using the SSH Command for this it you need to connect your server by using the SSH Credentials,

Create a copy of a Database by using the phpMyAdmin

phpMyAdmin is very powerful free tool written in PHP to handle the administration of the MySQL. It provides very good GUI to manage the databases, database operations like create, delete, alter databases as well as create, delete

Create MySQL database with SSH command

Database in MySQL can be created by using the phpmyadmin interface but some times if there is no installation of the phpmyadmin on the server but MySQL is there, then you can create the database by using

Get Database Table Column Names In WordPress

Some times we need to get the column names for a MySQL database table in WordPress,Here in this post i am describing how to do this. It is very simple, suppose you want to get the column