PHPMyAdmin: deleting all rows from MySql table
+20 Basically, you can delete rows in MySQL table by using below two queries, which are explained as : Example: I have createded a “user” …
PhpMyAdmin: No activity within 1440 seconds, please log in again!!!
+3-3 If you do not do any activity in your PHPMyAdmin it will log out automatically after 1440 seconds or say 24 minutes and shows …
Mysql Event scheduler
+2-1 I have already posted a blog (Event Scheduler an alternative to cronjob) with different advantages of Even scheduler over cron job, here I am …
Generating ERD using PHPMyAdmin
Today I need to generate ERD for my Database. If you search on net you will get number of people suggest Workbench for it but as i am using PHPMyAdmin as an GUI for my Mysql database I just don’t want to install workbench only for generating ERD. And above all when PHPMyAdmin support it (from 3.4 version) than what more I need.
How to access remote mysql server using local phpmyadmin
It is very tough to connect your remote mysql box especially when you are working with VPN. Initially I used telnet to connect to mysql box than I try to use workbench. Workbench is good and better than using telnet but again it consume more memory and if VPN got disconnected it just hanged. It so irritating. Than I try to integrate my PHPMyAdmin to configure to access remote mysql server and it is really very easy to setup.