Export excel in PHPMyADmin

Click Export,
Under Format,  from dropdown menu select
OpenDocument Spreadsheet
and click go button

Reset PHPMyAdmin

To reset PHPMyAdmin in Linux:

1. Stop the MySQL server
   sudo service mysql stop
2. Start mysqld
   sudo mysqld --skip-grant-tables &
3. Login to MySQL as root
   mysql -u root mysql
4. Change MYSECRET with your new root password
   UPDATE user SET Password=PASSWORD('MYSECRET') WHERE User='root'; FLUSH PRIVILEGES; exit;
5. Kill mysqld
   sudo pkill mysqld
6. Start mysql
   sudo service mysql start
7. Login to phpmyadmin as root with your new password
   
   

In Windows, for example my xampp installed in C:\xampp_php5.4\, PHPMyAdmin password is in
C:\xampp_php5.4\phpMyAdmin\config.inc.php

Rename a databse in PHPMYAdmin

I want to update my database wiki in localhost  from another server using PHPMyAdmin.
1. In PHPMyAdmin, select database you want to rename, click Operation at the top menu and rename the database, for example rename wiki to wikiold
2. Click Databases at top menu and  create database wiki.
3. Export wiki database  from another server in sql format using PHPMyAdmin.
4. Import wiki database to localhost in PHPMyAdmin.

localhost wiki database is updated.

Create triggers in PHPMyAdmin

To create triggers in PHPMyAdmin, click More at the top menu, click Triggers.
1) Click Add trigger
2) create a trigger name such as date trigger
3) input table name for your trigger in Table
4) Select Time from:  Before, After
5) Select INSERT, UPDATE, DELETE
6) In Definition: for example, I want  my CreateionDate column equal to current timing

BEGIN
    SET NEW.CreationDate = NOW();
END

7) Definer: enter your your email address