Browsing articles tagged with

phpmyadmin

Login into phpmyadmin without username and password

Phpmyadmin auto login Phpmyadmin is a popular web based mysql database administration tool/frontend. It is used widely by php/mysql developers to manage database locally and remotely. When logging in to phpmyadmin, the user has to provide the mysql login credentials. However when working or developing on localhost , its better to make phpmyadmin login automatically without asking for username and password ...

Increase phpmyadmin session/login time in Ubuntu 9.10 Karmic

Phpmyadmin Login time To increase the loging time of phpmyadmin edit : /etc/phpmyadmin/config.inc.php Add the following line : $cfg = 3600 * 9; To make the login time 9 hours. Along with this also check session.gc_maxlifetime in php.in to be higher than or equal to this value. Otherwise session time will be the lower of the two values. ...

List foreign keys in mysql

information_schema The following query will list out the foreign keys in mysql. It finds it out from the information_schema database. select concat(table_name, '.', column_name) as 'foreign key', concat(referenced_table_name, '.', referenced_column_name) as 'references' from information_schema.key_column_usage where referenced_table_name is not null; The output is a clean table listing out all foreign keys ...

Create foreign key using Phpmyadmin

The innodb storage engine supports foreign keys in Mysql. To create foreign keys in phpmyadmin : 1. Convert both tables into innodb, if they are not already. 2. View the structure of the table which will have a foreign key. Make the referencing field an INDEX. 3. Now come back to structure view and click Relation view. In the Relation view page the field (which ...



Connect with us