Posts Under phpMyAdmin Category
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. cd /etc/phpmyadmin/ vi apache.conf You will need to look for the following text “<Directory /usr/share/phpmyadmin>” and add in the below code: Remember that you need to press “i” in order to start editting text…
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 until you have “flushed” or “cleared” the second result. You can try using COMMIT to resolve this.
phpMyAdmin – Invalid field count in csv input on line 1
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 csv file. Select CSV using LOAD DATA (rather than just CSV) Change “Fields terminated by”…
