Press "Enter" to skip to content

Posts published in August 2011

Restrict PHPMyAdmin to IP Address

Would you like to restrict PHPMyAdmin from being accessible to the whole world? Firstly you need to SSH into your box if you are not on the local machine where PHPMyAdmin is installed along with Apache. [code] cd /etc/phpmyadmin/ vi apache.conf [/code] You will need to look for the following…

2014 – Commands out of sync; you can't run this command now

#2014 – Commands out of sync; you can’t run this command now Now that can be a really annoying error! It happens when querying stored procedures in phpMyAdmin as mysqli seems to return 2 sets of results opposed to the usual 1 that mysql returns. You cannot call anything else…