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. cd /etc/phpmyadmin/ vi apache.conf You will need to look for the following text “<Directory /usr/share/phpmyadmin>” and add in the
Read More…
#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 until you have “flushed” or
Read More…
I was trying to import a massive csv dataset into phpMyAdmin and it kept throwing error: Invalid field count in csv input on line 1 This was very annoying as it was all being done the way it always works for me! To solve this I had to do the following: Import Browse for your
Read More…
