Tag phpmyadmin

Mysql Event scheduler

Posted on September 18, 2016 by Suresh Kamrushi in Mysql

+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

Posted on March 5, 2014 by Suresh Kamrushi in Mysql, PHP

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

Posted on February 28, 2014 by Suresh Kamrushi in Mysql, PHP

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.