Tag phpmyadmin

PHPMyAdmin: deleting all rows from MySql table

Posted on October 20, 2017 by Suresh Kamrushi in Mysql

+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!!!

Posted on August 4, 2017 by Suresh Kamrushi in Mysql, PHP

+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

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.