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 phpMyAdmin, and can be solved by increasing the max_connections limit in 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, Here I assume that you have the full/root access with the sudoer
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 alter tables, columns, indexes, users and many more. Copy of a database
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 the SSH Commandline for that you should have the root access of
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 name for the post code is given below:
