Server　≫　Linux Server　≫　Fedora Core 6　≫　ＳＱＬサーバー

　
　 　
◆ ＭｙＳＱＬサーバーのインストール
　 　
　 Fedora Core 6 のインストール時 “ＭｙＳＱＬデータベース” を選択していれば mysql はインストールされています。

もし、Fedora Core 6 のインストール時 “ＭｙＳＱＬデータベース” を選択していない場合は下記要領でインストールして下さい。

下記のように入力します。青文字が入力文字です。
　 　
　  
 [root@linux]# yum install mysql-server    ← yum install mysql-server を入力
 Loading "installonlyn" plugin
 Setting up Install Process
 Setting up repositories
 core                           100% |=========================| 1.1 kB 00:00
 extras                         100% |=========================| 1.1 kB 00:00
 updates                        100% |=========================| 1.2 kB 00:00
 Reading repository metadata in from local files
 Parsing package install arguments
 Resolving Dependencies
 --> Populating transaction set with selected packages. Please wait.
 ---> Downloading header for mysql-server to pack into transaction set.
 mysql-server-5.0.22-2.1.i 100% |=========================| 33 kB 00:00
 ---> Package mysql-server.i386 0:5.0.22-2.1 set to be updated
 --> Running transaction check
 --> Processing Dependency: mysql = 5.0.22-2.1 for package: mysql-server
 --> Processing Dependency: perl-DBD-MySQL for package: mysql-server
 --> Processing Dependency: libmysqlclient.so.15(libmysqlclient_15) for package: mysql-server
 --> Processing Dependency: perl(DBI) for package: mysql-server
 --> Processing Dependency: perl-DBI for package: mysql-server
 --> Processing Dependency: libmysqlclient_r.so.15(libmysqlclient_15) for package: mysql-server
 --> Processing Dependency: libmysqlclient.so.15 for package: mysql-server
 --> Processing Dependency: libmysqlclient_r.so.15 for package: mysql-server
 --> Restarting Dependency Resolution with new changes.
 --> Populating transaction set with selected packages. Please wait.
 ---> Downloading header for mysql to pack into transaction set.
 mysql-5.0.22-2.1.i386.rpm       100% |=========================| 35 kB 00:00
 ---> Package mysql.i386 0:5.0.22-2.1 set to be updated
 ---> Downloading header for perl-DBI to pack into transaction set.
 perl-DBI-1.52-1.fc6.i386.       100% |=========================| 16 kB 00:00
 ---> Package perl-DBI.i386 0:1.52-1.fc6 set to be updated
 ---> Downloading header for perl-DBD-MySQL to pack into transaction set.
 perl-DBD-MySQL-3.0007-1.f       100% |=========================| 8.5 kB 00:00
 ---> Package perl-DBD-MySQL.i386 0:3.0007-1.fc6 set to be updated
 --> Running transaction check

 Dependencies Resolved

 =============================================================================
   Package              Arch         Version            Repository     Size
 =============================================================================
 Installing:
   mysql-server         i386         5.0.22-2.1         core             10 M
 Installing for dependencies:
   mysql                i386         5.0.22-2.1         core            3.0 M
   perl-DBD-MySQL       i386         3.0007-1.fc6       core            147 k
   perl-DBI             i386         1.52-1.fc6         core            605 k

 Transaction Summary
 =============================================================================
 Install   4 Package(s)
 Update    0 Package(s)
 Remove    0 Package(s)

 Total download size: 14 M
 Is this ok [y/N]:y   ← y を入力
 Downloading Packages:
 (1/4): mysql-5.0.22-2.1.i       100% |=========================| 3.0 MB 00:14
 (2/4): mysql-server-5.0.2       100% |=========================| 10 MB 00:45
 (3/4): perl-DBI-1.52-1.fc       100% |=========================| 605 kB 00:02
 (4/4): perl-DBD-MySQL-3.0       100% |=========================| 147 kB 00:00
 Running Transaction Test
 Finished Transaction Test
 Transaction Test Succeeded
 Running Transaction
 Installing: perl-DBI                   ######################### [1/4]
 Installing: mysql                      ######################### [2/4]
 Installing: perl-DBD-MySQL             ######################### [3/4]
 Installing: mysql-server               ######################### [4/4]

 Installed: mysql-server.i386 0:5.0.22-2.1
 Dependency Installed: mysql.i386 0:5.0.22-2.1 perl-DBD-MySQL.i386 0:3.0007-1.fc6 perl-DBI.i386 0:1.52-
 1.fc6
 Complete!    ← Complete! と表示されれば完了
　
　 　
　 　
◆ ＭｙＳＱＬサーバーの起動
　 　
　 下記のように入力します。青文字が入力文字です。
　 　
　
 [root@linux]# /etc/rc.d/init.d/mysqld start    ← /etc/rc.d/init.d/mysqld start を入力
 MySQL データベースを初期化中: Installing all prepared tables
 Fill help tables

 To start mysqld at boot time you have to copy support-files/mysql.server
 to the right place for your system

 PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !
 To do so, start the server, then issue the following commands:
 /usr/bin/mysqladmin -u root password 'new-password'
 /usr/bin/mysqladmin -u root -h host.server password 'new-password'
 See the manual for more instructions.

 You can start the MySQL daemon with:
 cd /usr ; /usr/bin/mysqld_safe &

 You can test the MySQL daemon with the benchmarks in the 'sql-bench' directory:
 cd sql-bench ; perl run-all-tests

 Please report any problems with the /usr/bin/mysqlbug script!

 The latest information about MySQL is available on the web at
 http://www.mysql.com
 Support MySQL by buying support/licenses at http://shop.mysql.com
                                                             [ OK ]
 MySQL を起動中:                                             [ OK ]
　
　 　
　 続いてＰＣの再起動に mysqld を自動的に起動するようにします。下記のように入力します。青文字が入力文字です。
　 　
　  
 [root@linux]# chkconfig mysqld on      ← chkconfig mysqld on を入力（dhcp の自動起動）
 
　 　
　 自動起動設定の確認。下記のように入力し 、下記のように表示されればＯＫです。青文字が入力文字です。
　 　
　  
 [root@linux]# chkconfig --list mysqld     ← chkconfig --list mysqld を入力（dhcp の自動起動確認）
 mysqld       0:off   1:off   2:on   3:on   4:on   5:on   6:off
　
　 　
　 再起動は下記のように入力します。青文字が入力文字です。
　 　
　  
 [root@linux]# /etc/rc.d/init.d/mysqld restart
 
　 　
　 　
◆ ＭｙＳＱＬサーバーの設定
　 　
　 ＭｙＳＱＬサーバーに root でログインします。

下記のように入力します。青文字が入力文字です。
　 　
　  
 [root@linux]# mysql -u root     ← mysql -u root を入力
 Welcome to the MySQL monitor. Commands end with ; or \g.
 Your MySQL connection id is 2 to server version: 5.0.22

 Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

 mysql>
　
　 　
　 まずは root のパスワード設定です。

下記のように入力します。青文字が入力文字です。
　 　
　  
 mysql> select user,host,password from mysql.user;     ← select user,host,password from mysql.user; を入力
 +------+--------------+----------+
 | user | host         | password |
 +------+--------------+----------+
 | root | localhost    |          |    ← パスワードが設定されていない ( localhost の root )
 | root | linux.server |          |    ← パスワードが設定されていない ( host 名の root )
 |      | linux.server |          |
 |      | localhost    |          |
 +------+--------------+----------+
 4 rows in set (0.00 sec)
　
　 　
　 上記のようにパスワードが設定されていません。

locaihost の root のパスワードを設定します。下記のように入力します。青文字が入力文字です。
　 　
　  
 mysql> set password for root@localhost=password('******');     ← ****** がパスワードです
 Query OK, 0 rows affected (0.00 sec)
　
　 　
　 host 名の root のパスワードを設定します。下記のように入力します。青文字が入力文字です。
　 　
　  
 mysql> set password for root@'linux.server'=password('******');     ← ****** がパスワードです
 Query OK, 0 rows affected (0.00 sec)
　
　 　
　 パスワードの設定確認をします。下記のように入力します。青文字が入力文字です。
　 　
　  
 mysql> select user,host,password from mysql.user;     ← select user,host,password from mysql.user; を入力
 +------+--------------+------------------+
 | user | host         | password         |
 +------+--------------+------------------+
 | root | localhost    | **************** |    ← パスワードが設定された ( localhost の root )
 | root | linux.server | **************** |    ← パスワードが設定された ( host 名の root )
 |      | linux.server |                  |
 |      | localhost    |                  |
 +------+--------------+------------------+
 4 rows in set (0.00 sec)
　
　 　
　 次に匿名ユーザーを削除します。上記の表の user の欄に空白の部分がありますが、これが匿名ユーザーです。セキュリティ上問題がありますので削除します。

下記のように入力します。青文字が入力文字です。
　 　
　  
 mysql> delete from mysql.user where user='';     ← delete from mysql.user where user=''; を入力
 Query OK, 2 rows affected (0.00 sec)
　
　 　
　 匿名ユーザーを削除できたか確認します。

下記のように入力します。青文字が入力文字です。
　 　
　  
 mysql> select user,host,password from mysql.user;     ← select user,host,password from mysql.user; を入力
 +------+--------------+------------------+
 | user | host         | password         |
 +------+--------------+------------------+
 | root | localhost    | **************** |    ← 匿名ユーザーが消え root だけになった
 | root | linux.server | **************** |   
 +------+--------------+------------------+
 2 rows in set (0.47 sec)
　
　 　
　 匿名ユーザーを削除できました。

次に不要なデータベースを削除します。

ＭｙＳＱＬサーバーには最初から test と言うデータベースが登録されています。これは不要なので削除します。

まずはデータベースの確認です。下記のように入力します。青文字が入力文字です。
　 　
　  
 mysql> show databases;     ←　　show databases; を入力
 +--------------------+
 | Database           |
 +--------------------+
 | information_schema |
 | mysql              |
 | test               |     ←　　不要なデータベース test
 +------+-------------+
 3 rows in set (0.00 sec)
　
　 　
　 次にデータベースを削除します。下記のように入力します。青文字が入力文字です。
　 　
　  
 mysql> drop database test;     ←　　drop database test; を入力
　
　 　
　 削除の確認です。下記のように入力します。青文字が入力文字です。
　 　
　  
 mysql> show databases;     ←　　show databases; を入力
 +--------------------+
 | Database           |
 +--------------------+
 | information_schema |
 | mysql              |
 +------+-------------+
 2 rows in set (0.00 sec)
　
　 　
　

ここでいったん MySQL サーバーよりログアウトします。

下記のように入力します。青文字が入力文字です。
　 　
　  
 mysql> exit     ← exit を入力
 Bye
　
　 　
　 再度 MySQL サーバーにログインします。　ここからは上記でパスワードを設定したのパスワードを入力しないとログインできません。

下記のように入力します。青文字が入力文字です。
　 　
　  
 [root@linux]# mysql -u root -p******     ← mysql -u root -p****** を入力 ( ****** はパスワード )
 Welcome to the MySQL monitor. Commands end with ; or \g.
 Your MySQL connection id is 4 to server version: 5.0.22

 Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

 mysql>
　
　 　
　 　
◆ php-mysql のインストール
　 　
　 MySQL を Web で操作できるように phpmyadmin をダウンロードしてインストールを行います。

その準備として phpmyadmin はＰＨＰ上で動作しますので php-mysql をインストールします。

下記のように入力します。青文字が入力文字です。
　 　
　
 [root@linux]# yum install php-mysql    ← 入力
 Loading "installonlyn" plugin
 Setting up Install Process
 Setting up repositories
 core                        100% |=========================| 1.1 kB 00:00
 extras                      100% |=========================| 1.1 kB 00:00
 updates                     100% |=========================| 1.2 kB 00:00
 Reading repository metadata in from local files
 Parsing package install arguments
 Resolving Dependencies
 --> Populating transaction set with selected packages. Please wait.
 ---> Downloading header for php-mysql to pack into transaction set.
 php-mysql-5.1.6-3.1.fc6.i   100% |=========================| 16 kB 00:00
 ---> Package php-mysql.i386 0:5.1.6-3.1.fc6 set to be updated
 --> Running transaction check
 --> Processing Dependency: php = 5.1.6-3.1.fc6 for package: php-mysql
 --> Processing Dependency: php-pdo for package: php-mysql
 --> Restarting Dependency Resolution with new changes.
 --> Populating transaction set with selected packages. Please wait.
 ---> Downloading header for php-pdo to pack into transaction set.
 php-pdo-5.1.6-3.1.fc6.i38   100% |=========================| 16 kB 00:00
 ---> Package php-pdo.i386 0:5.1.6-3.1.fc6 set to be updated
 ---> Downloading header for php to pack into transaction set.
 php-5.1.6-3.1.fc6.i386.rp   100% |=========================| 17 kB 00:00
 ---> Package php.i386 0:5.1.6-3.1.fc6 set to be updated
 --> Running transaction check
 --> Processing Dependency: php-common = 5.1.6-3.1.fc6 for package: php
 --> Processing Dependency: libgmp.so.3 for package: php
 --> Processing Dependency: php-cli = 5.1.6-3.1.fc6 for package: php
 --> Restarting Dependency Resolution with new changes.
 --> Populating transaction set with selected packages. Please wait.
 ---> Downloading header for php-common to pack into transaction set.
 php-common-5.1.6-3.1.fc6.   100% |=========================| 18 kB 00:00
 ---> Package php-common.i386 0:5.1.6-3.1.fc6 set to be updated
 ---> Downloading header for php-cli to pack into transaction set.
 php-cli-5.1.6-3.1.fc6.i38   100% |=========================| 16 kB 00:00
 ---> Package php-cli.i386 0:5.1.6-3.1.fc6 set to be updated
 ---> Downloading header for gmp to pack into transaction set.
 gmp-4.1.4-7.i386.rpm 100%        |=========================| 10 kB 00:00
 ---> Package gmp.i386 0:4.1.4-7 set to be updated
 --> Running transaction check

 Dependencies Resolved

 =============================================================================
   Package           Arch         Version               Repository      Size
 =============================================================================
 Installing:
   php-mysql         i386         5.1.6-3.1.fc6         updates          82 k
 Installing for dependencies:
   gmp               i386         4.1.4-7               core            630 k
   php               i386         5.1.6-3.1.fc6         updates         1.2 M
   php-cli           i386         5.1.6-3.1.fc6         updates         2.2 M
   php-common        i386         5.1.6-3.1.fc6         updates         138 k
   php-pdo           i386         5.1.6-3.1.fc6         updates          60 k

 Transaction Summary
 =============================================================================
 Install   6 Package(s)
 Update    0 Package(s)
 Remove    0 Package(s)

 Total download size: 4.4 M
 Is this ok [y/N]: y   ← y を入力
 Downloading Packages:
 (1/6): php-common-5.1.6-3   100% |=========================| 138 kB 00:00
 (2/6): php-cli-5.1.6-3.1.   100% |=========================| 2.2 MB 00:09
 (3/6): php-mysql-5.1.6-3.   100% |=========================| 82 kB 00:00
 (4/6): php-5.1.6-3.1.fc6.   100% |=========================| 1.2 MB 00:05
 (5/6): php-pdo-5.1.6-3.1.   100% |=========================| 60 kB 00:00
 (6/6): gmp-4.1.4-7.i386.r   100% |=========================| 630 kB 00:03
 Running Transaction Test
 Finished Transaction Test
 Transaction Test Succeeded
 Running Transaction
   Installing: gmp                      ######################### [1/6]
   Installing: php-common               ######################### [2/6]
   Installing: php-cli                  ######################### [3/6]
   Installing: php                      ######################### [4/6]
   Installing: php-pdo                  ######################### [5/6]
   Installing: php-mysql                ######################### [6/6]

 Installed: php-mysql.i386 0:5.1.6-3.1.fc6
 Dependency Installed: gmp.i386 0:4.1.4-7 php.i386 0:5.1.6-3.1.fc6 php-cli.i386 0:5.1.6-3.1.fc6 php- 
 common.i386 0:5.1.6-3.1.fc6 php-pdo.i386 0:5.1.6-3.1.fc6
 Complete!    ← Complete! と表示されれば完了
　
　 　
　 　
◆ phpmyadmin のインストール
　 　
　 phpmyadmin を phpMyAdmin のサイトよりダウンロードします。（２００６年１１月現在の最新版は phpMyAdmin-2.9.1.1 です）

下記のように入力します。青文字が入力文字です。
　 　
　  
 [root@linux]# wget -P /usr/local http://jaist.dl.sourceforge.net/sourceforge/phpmyadmin/phpMyAdmin-
 　　                                                         2.9.1.1-all-languages.tar.gz     ← １行で入力
 --21:35:10-- http://jaist.dl.sourceforge.net/sourceforge/phpmyadmin/phpMyAdmin-2.9.1.1-all- 
                                                                                          languages.tar.gz
 jaist.dl.sourceforge.net をDNSに問いあわせています... 150.65.7.130
 jaist.dl.sourceforge.net|150.65.7.130|:80 に接続しています... 接続しました。
 HTTP による接続要求を送信しました、応答を待っています... 200 OK
 長さ: 3500563 (3.3M) [application/x-gzip]
 Saving to: `/usr/local/phpMyAdmin-2.9.1.1-all-languages.tar.gz'

 100%[==========================================================================>] 3,500,563 222K/s in 15s

 21:35:27 (222 KB/s) - `/usr/local/phpMyAdmin-2.9.1.1-all-languages.tar.gz' を保存しました  
                                                                                         [3500563/3500563]
　
　 　
　 ダウンロードしたファイルを解凍します。
　 　
　  
 [root@linux]# cd /usr/local    ← 入力（ダウンロードしたディレクトリに移動）
 [root@linux]# tar xzf phpMyAdmin-2.9.1.1-all-languages.tar.gz -C /home/****/    ← 入力 
 　　　　　　　　　　　　　　　　　　　　　　　　　 （/home/****/ に解凍 **** はＨＰ公開ディレクトリ）
　
　 　
　 展開が完了すると /home/****/ に phpMyAdmin-2.9.1.1-all-languages と言うフォルダが出来上がります。
　 　
　 　
◆ phpMyAdmin の設定
　 　
　 上記で解凍したファイルの中より config.default.php を config.inc.php と言う名前にコピーして使います。

下記のように入力します。青文字が入力文字です。
　 　
　
 [root@linux]# cp /home/****/phpMyAdmin-2.9.1.1-all-languages/libraries/config.default.php
                                   /home/****/phpMyAdmin-2.9.1.1-all-languages/config.inc.php     ← １行で入力
　
　 　
　 config.inc.php のアクセス権の変更

下記のように入力します。青文字が入力文字です。
　 　
　
 [root@linux]# chmod 664 /home/****/phpMyAdmin-2.9.1.1-all-languages/config.inc.php    ← 入力
　
　 　
　 phpMyAdmin 設定ファイルの設定です。

下記のように緑色の部分を黄色に変更（書き換え・削除）して下さい。赤文字は説明です。青文字が入力文字です。
　 　
　
 [root@linux]# vi /home/****/phpMyAdmin-2.9.1.1-all-languages/config.inc.php
 <?php
 
 /* !!! DO NOT EDIT THIS FILE, EDIT config.inc.php INSTEAD !!! */
 
 /* $Id: config.default.php 9715 2006-11-17 09:52:52Z nijel $ */
 // vim: expandtab sw=4 ts=4 sts=4:
 
 /**
 * phpMyAdmin default configuration, you can copy values from here to your
 * config.inc.php
 *
 * All directives are explained in Documentation.html
 */
 
 
 /**
  * Your phpMyAdmin URL.
  *
  * Complete the variable below with the full url ie
  *    http://www.your_web.net/path_to_your_phpMyAdmin_directory/
  *
  * It must contain characters that are valid for a URL, and the path is
  * case sensitive on some Web servers, for example Unix-based servers.
  *
  * In most cases you can leave this variable empty, as the correct value
  * will be detected automatically. However, we recommend that you do
  * test to see that the auto-detection code works in your system. A good
  * test is to browse a table, then edit a row and save it. There will be
  * an error message if phpMyAdmin cannot auto-detect the correct value.
  */
 $cfg['PmaAbsoluteUri'] = '';
 
 /**
  * Disable the default warning that is displayed on the DB Details Structure page if
  * any of the required Tables for the relationfeatures could not be found
  */
 $cfg['PmaNoRelation_DisableWarning'] = FALSE;

 /**
  * The 'cookie' auth_type uses blowfish algorithm to encrypt the password. If
  * at least one server configuration uses 'cookie' auth_type, enter here a
  * passphrase that will be used by blowfish. The maximum length seems to be 46
  * characters.
  */
 $cfg['blowfish_secret'] = '';
                ↓
  $cfg['blowfish_secret'] = '**********';    ← 入力 (パスワードを入力)
 
 /**
  * Server(s) configuration
  */
 $i = 0;
 // The $cfg['Servers'] array starts with $cfg['Servers'][1]. Do not use
 // $cfg['Servers'][0]. You can disable a server config entry by setting host
 // to ''. If you want more than one server, just copy following section
 // (including $i incrementation) serveral times. There is no need to define
 // full server array, just define values you need to change.
 $i++;
 $cfg['Servers'][$i]['host']          = 'localhost'; // MySQL hostname or IP address
 $cfg['Servers'][$i]['port']          = '';          // MySQL port - leave blank for default port
 $cfg['Servers'][$i]['socket']        = '';          // Path to the socket - leave blank for default socket
 $cfg['Servers'][$i]['connect_type']  = 'tcp';       // How to connect to MySQL server ('tcp'or'socket')
 $cfg['Servers'][$i]['extension']     = 'mysql';     // The php MySQL extension to use ('mysql'or'mysqli')
 $cfg['Servers'][$i]['compress']      = FALSE;       // Use compressed protocol for the MySQL connection
                                                     // (requires PHP >= 4.3.0)
 $cfg['Servers'][$i]['controluser']   = '';          // MySQL control user settings
                                                     // (this user must have read-only
 $cfg['Servers'][$i]['controlpass']   = '';          // access to the "mysql/user"
                                                     // and "mysql/db" tables).
                                                     // The controluser is also
                                                     // used for all relational
                                                     // features (pmadb)
  $cfg['Servers'][$i]['auth_type']     = 'config';    // Authentication method (config,http or cookie
                ↓                                                                                based)?
  $cfg['Servers'][$i]['auth_type']     = 'cookie';    ← 入力 cookie に変更
 $cfg['Servers'][$i]['user']          = 'root';      // MySQL user
 $cfg['Servers'][$i]['password'] 　 　= '';          // MySQL password (only needed
                                                     // with 'config' auth_type)
 $cfg['Servers'][$i]['nopassword']    = FALSE;       // Whether to try to connect without password
 $cfg['Servers'][$i]['only_db']       = '';          // If set to a db-name, only
                                                     // this db is displayed in left frame
                                                     // It may also be an array of db-names, where sorting
 $cfg['Servers'][$i]['hide_db']       = '';          // Database name to be hidden from listings order
                                                                                              is relevant.
 $cfg['Servers'][$i]['verbose']       = '';          // Verbose name for this host - leave blank to show
                                                                                              the hostname
 $cfg['Servers'][$i]['pmadb']         = '';          // Database used for Relation, Bookmark and PDF
                                                                                                  Features
                                                     // (see scripts/create_tables.sql)
                                                     // - leave blank for no support
                                                     // DEFAULT: 'phpmyadmin'
 $cfg['Servers'][$i]['bookmarktable'] = '';          // Bookmark table
                                                     // - leave blank for no bookmark support
                                                     // DEFAULT: 'pma_bookmark'
 $cfg['Servers'][$i]['relation']      = '';          // table to describe the relation between links (see
                                                     // - leave blank for no relation-links support   doc)
                                                     // DEFAULT: 'pma_relation'
 $cfg['Servers'][$i]['table_info']    = '';          // table to describe the display fields
                                                     // - leave blank for no display fields support
                                                     // DEFAULT: 'pma_table_info'
 $cfg['Servers'][$i]['table_coords']  = '';          // table to describe the tables position for the PDF
                                                     // - leave blank for no PDF schema support     schema
                                                     // DEFAULT: 'pma_table_coords'
 $cfg['Servers'][$i]['pdf_pages']     = '';          // table to describe pages of relationpdf
                                                     // - leave blank if you don't want to use this
                                                     // DEFAULT: 'pma_pdf_pages'
 $cfg['Servers'][$i]['column_info']   = '';          // table to store column information
                                                     // - leave blank for no column comments/mime types
                                                     // DEFAULT: 'pma_column_info'
 $cfg['Servers'][$i]['history']       = '';          // table to store SQL history
                                                     // - leave blank for no SQL query history
                                                     // DEFAULT: 'pma_history'
 $cfg['Servers'][$i]['verbose_check'] = TRUE;        // set to FALSE if you know that your pma_* tables
                                                     // are up to date. This prevents compatibility
                                                     // checks and thereby increases performance.
 $cfg['Servers'][$i]['AllowRoot']     = TRUE;        // whether to allow root login
 $cfg['Servers'][$i]['AllowDeny']['order']           // Host authentication order, leave blank to not use
                                      = '';
 $cfg['Servers'][$i]['AllowDeny']['rules']           // Host authentication rules, leave blank for defaults
                                      = array();

 // If you have more than one server configured, you can set $cfg['ServerDefault']
 // to any one of them to autoconnect to that server when phpMyAdmin is started,
 // or set it to 0 to be given a list of servers without logging in
 // If you have only one server configured, $cfg['ServerDefault'] *MUST* be
 // set to that server.
 $cfg['ServerDefault']                = 1;           // Default server (0 = no default server)

 /**
  * Other core phpMyAdmin settings
  */
 $cfg['MaxDbList']                    = 100;         // maximum number of db's displayed in left frame and
                                                                                             databaes list
 $cfg['OBGzip']                       = 'auto';      // use GZIP output buffering if possible (TRUE|FALSE|
                                                                                                   'auto')
 $cfg['PersistentConnections']        = FALSE;       // use persistent connections to MySQL database
 $cfg['ForceSSL']                     = FALSE;       // whether to force using https
 $cfg['ExecTimeLimit']                = 300;         // maximum execution time in seconds (0 for no limit)
 $cfg['MemoryLimit']                  = 0;           // maximum allocated bytes (0 for no limit)
 $cfg['SkipLockedTables']             = FALSE;       // mark used tables, make possible to show
                                                     // locked tables (since MySQL 3.23.30)
 $cfg['ShowSQL']                      = TRUE;        // show SQL queries as run
 $cfg['AllowUserDropDatabase']        = FALSE;       // show a 'Drop database' link to normal users
 $cfg['Confirm']                      = TRUE;        // confirm 'DROP TABLE' & 'DROP DATABASE'
 $cfg['LoginCookieRecall']            = TRUE;        // recall previous login in cookie auth. mode or not
 $cfg['LoginCookieValidity']          = 1800;        // validity of cookie login (in seconds)
 $cfg['LoginCookieStore']             = 0;           // how long login cookie should be stored (in seconds)
 $cfg['LoginCookieDeleteAll']         = TRUE;        // whether to delete all login cookies on logout
 $cfg['UseDbSearch']                  = TRUE;        // whether to enable the "database search" feature
                                                     // or not
 $cfg['IgnoreMultiSubmitErrors']      = FALSE;       // if set to true, PMA continues computing multiple-
                                                                                         statement queries
                                                     // even if one of the queries failed
 $cfg['VerboseMultiSubmit']           = TRUE;        // if set to true, PMA will show the affected rows of
                                                                                         EACH statement on
                                                     // multiple-statement queries. See the
                                                                             libraries/import.php file for
                                                     // hardcoded defaults on how many queries a statement
                                                                                              may contain!
 $cfg['AllowArbitraryServer']         = FALSE;       // allow login to any user entered server in cookie
                                                                                                based auth

 // Left frame setup
 $cfg['LeftFrameLight']               = TRUE;        // use a select-based menu and display only the
                                                     // current tables in the left frame.
 $cfg['LeftFrameDBTree']              = TRUE;        // turn the select-based light menu into a tree
 $cfg['LeftFrameDBSeparator']         = '_';         // the separator to sub-tree the select-based light
                                                                                                 menu tree
 $cfg['LeftFrameTableSeparator']      = '__';        // Which string will be used to generate table
                                                                                                  prefixes
                                                     // to split/nest tables into multiple categories
 $cfg['LeftFrameTableLevel']          = '1';         // How many sublevels should be displayed when
                                                                                                 splitting
                                                     // up tables by the above Separator
 $cfg['ShowTooltip']                  = TRUE;        // display table comment as tooltip in left frame
 $cfg['ShowTooltipAliasDB']           = FALSE;       // if ShowToolTip is enabled, this defines that
                                                                                         table/db comments
 $cfg['ShowTooltipAliasTB']           = FALSE;       // are shown (in the left menu and
                                                                          db_details_structure) instead of
                                                     // table/db names. Setting ShowTooltipAliasTB to
                                                                                        'nested' will only
                                                     // use the Aliases for nested descriptors, not the
                                                                                             table itself.

 $cfg['LeftDisplayLogo']              = TRUE;        // display logo at top of left frame
 $cfg['LeftLogoLink']                 = 'http://www.phpmyadmin.net/';   // where should logo link point to
 $cfg['LeftDisplayServers']           = FALSE;       // display server choice at top of left frame
 $cfg['DisplayServersList']           = FALSE;       // server choice as links

 // In the main frame, at startup...
 $cfg['ShowStats']                    = TRUE;        // allow to display statistics and space usage in
                                                     // the pages about database details and table
                                                     // properties
 $cfg['ShowPhpInfo']                  = FALSE;       // show php info link
 $cfg['ShowChgPassword']              = FALSE;       // show change password link
 $cfg['ShowCreateDb']                 = TRUE;        // show create database form
 $cfg['SuggestDBName']                = TRUE;        // suggest a new DB name if possible (false = keep
                                                                                                    empty)

 // In browse mode...
 $cfg['ShowBlob']                     = FALSE;       // display blob field contents
 $cfg['NavigationBarIconic']          = 'both';      // Use icons instead of text for the navigation bar
                                                                                                   buttons
                                                     // and on right panel top menu (server db table)
                                                                                       (TRUE|FALSE|'both')
 $cfg['ShowAll']                      = FALSE;       // allows to display all the rows
 $cfg['MaxRows']                      = 30;          // maximum number of rows to display
 $cfg['Order']                        = 'ASC';       // default for 'ORDER BY' clause (valid
                                                     // values are 'ASC', 'DESC' or 'SMART' -ie
                                                     // descending order for fields of type
                                                     // TIME, DATE, DATETIME & TIMESTAMP,
                                                     // ascending order else-)

 // In edit mode...
 $cfg['ProtectBinary']                = 'blob';      // disallow editing of binary fields
                                                     // valid values are:
                                                     // FALSE allow editing
                                                     // 'blob' allow editing except for BLOB fields
                                                     // 'all' disallow editing
 $cfg['ShowFunctionFields']           = TRUE;        // Display the function fields in edit/insert mode
 $cfg['CharEditing']                  = 'input';
                                                     // Which editor should be used for CHAR/VARCHAR
                                                                                                   fields:
                                                     // input - allows limiting of input length
                                                     // textarea - allows newlines in fields
 $cfg['InsertRows']                   = 2;           // How many rows can be inserted at one time

 $cfg['ForeignKeyDropdownOrder']      =              // Sort order for items in a foreign-key dropdown box.
     array( 'content-id', 'id-content');             // 'content' is the referenced data, 'id' is the key
                                                                                                     value.
 $cfg['ForeignKeyMaxLimit']           = 100;         // A dropdown will be used if fewer items are present


 // For the export features...
 $cfg['ZipDump']                      = TRUE;        // Allow the use of zip/gzip/bzip
 $cfg['GZipDump']                     = TRUE;        // compression for
 $cfg['BZipDump']                     = TRUE;        // dump files
 $cfg['CompressOnFly']                = TRUE;        // Will compress gzip/bzip2 exports on
                                                     // fly without need for much memory.
                                                     // If you encounter problems with
                                                     // created gzip/bzip2 files disable
                                                     // this feature.

 // Tabs display settings
 $cfg['LightTabs']                    = FALSE;       // use graphically less intense menu tabs
 $cfg['PropertiesIconic']             = TRUE;        // Use icons instead of text for the table display of
                                                                            a database (TRUE|FALSE|'both')
 $cfg['PropertiesNumColumns']         = 1;           // How many columns should be used for table display
                                                                                            of a database?
                                                     // (a value larger than 1 results in some information
                                                                                             being hidden)

 $cfg['DefaultTabServer']             = 'main.php';
                                                     // Possible values:
                                                     // 'main.php' = the welcome page
                                                     // (recommended for multiuser setups)
                                                     // 'server_databases.php' = list of databases
                                                     // 'server_status.php' = runtime information
                                                     // 'server_variables.php' = MySQL server variables
                                                     // 'server_privileges.php' = user management
                                                     // 'server_processlist.php' = process list
 $cfg['DefaultTabDatabase']           = 'db_details_structure.php';
                                                     // Possible values:
                                                     // 'db_details_structure.php' = tables list
                                                     // 'db_details.php' = sql form
                                                     // 'db_search.php' = search query
                                                     // 'db_operations.php' = operations on database
 $cfg['DefaultTabTable']              = 'tbl_properties_structure.php';
                                                     // Possible values:
                                                     // 'tbl_properties_structure.php' = fields list
                                                     // 'tbl_properties.php' = sql form
                                                     // 'tbl_select.php' = select page
                                                     // 'tbl_change.php' = insert row page
                                                     // 'sql.php' = browse page

 /**
  * Export defaults
  */

 $cfg['Export']['format']             = 'sql';      // sql/latex/excel/csv/xml/xls/htmlexcel/htmlword
                                                                                                  /ods/odt
 $cfg['Export']['compression']        = 'none';     // none/zip/gzip/bzip2

 $cfg['Export']['asfile']             = FALSE;
 $cfg['Export']['charset']            = '';
 $cfg['Export']['onserver']           = FALSE;
 $cfg['Export']['onserver_overwrite'] = FALSE;
 $cfg['Export']['remember_file_template'] = TRUE;
 $cfg['Export']['file_template_table'] = '__TABLE__';
 $cfg['Export']['file_template_database'] = '__DB__';
 $cfg['Export']['file_template_server'] = '__SERVER__';

 $cfg['Export']['ods_columns']        = FALSE;
 $cfg['Export']['ods_null']           = 'NULL';

 $cfg['Export']['odt_structure']      = TRUE;
 $cfg['Export']['odt_data']           = TRUE;
 $cfg['Export']['odt_columns']        = TRUE;
 $cfg['Export']['odt_relation']       = TRUE;
 $cfg['Export']['odt_comments']       = TRUE;
 $cfg['Export']['odt_mime']           = TRUE;
 $cfg['Export']['odt_null']           = 'NULL';

 $cfg['Export']['htmlexcel_columns']  = FALSE;
 $cfg['Export']['htmlexcel_null']     = 'NULL';

 $cfg['Export']['htmlword_structure'] = TRUE;
 $cfg['Export']['htmlword_data']      = TRUE;
 $cfg['Export']['htmlword_columns']   = FALSE;
 $cfg['Export']['htmlword_null']      = 'NULL';

 $cfg['Export']['xls_columns']        = FALSE;
 $cfg['Export']['xls_null']           = 'NULL';

 $cfg['Export']['csv_columns']        = FALSE;
 $cfg['Export']['csv_null']           = 'NULL';
 $cfg['Export']['csv_separator']      = ';';
 $cfg['Export']['csv_enclosed']       = '"';
 $cfg['Export']['csv_escaped']        = '\\';
 $cfg['Export']['csv_terminated']     = 'AUTO';
 $cfg['Export']['excel_columns']      = FALSE;
 $cfg['Export']['excel_null']         = 'NULL';
 $cfg['Export']['excel_edition']      = 'win'; // win/mac

 $cfg['Export']['latex_structure']    = TRUE;
 $cfg['Export']['latex_data']         = TRUE;
 $cfg['Export']['latex_columns']      = TRUE;
 $cfg['Export']['latex_relation']     = TRUE;
 $cfg['Export']['latex_comments']     = TRUE;
 $cfg['Export']['latex_mime']         = TRUE;
 $cfg['Export']['latex_null']         = '\textit{NULL}';
 $cfg['Export']['latex_caption']      = TRUE;
 $cfg['Export']['latex_data_caption'] = 'strLatexContent';
 $cfg['Export']['latex_data_continued_caption'] = 'strLatexContent strLatexContinued';
 $cfg['Export']['latex_data_label']   = 'tab:__TABLE__-data';
 $cfg['Export']['latex_structure_label'] = 'tab:__TABLE__-structure';

 $cfg['Export']['sql_structure']      = TRUE;
 $cfg['Export']['sql_data']           = TRUE;
 $cfg['Export']['sql_compatibility']  = 'NONE';
 $cfg['Export']['sql_disable_fk']     = FALSE;
 $cfg['Export']['sql_use_transaction'] = FALSE;
 $cfg['Export']['sql_drop_database']  = FALSE;
 $cfg['Export']['sql_drop_table']     = FALSE;
 $cfg['Export']['sql_if_not_exists']  = FALSE;
 $cfg['Export']['sql_auto_increment'] = TRUE;
 $cfg['Export']['sql_backquotes']     = TRUE;
 $cfg['Export']['sql_dates']          = FALSE;
 $cfg['Export']['sql_relation']       = FALSE;
 $cfg['Export']['sql_columns']        = TRUE;
 $cfg['Export']['sql_delayed']        = FALSE;
 $cfg['Export']['sql_ignore']         = FALSE;
 $cfg['Export']['sql_hex_for_binary'] = TRUE;
 $cfg['Export']['sql_type']           = 'insert'; // insert/update/replace
 $cfg['Export']['sql_extended']       = TRUE;
 $cfg['Export']['sql_max_query_size'] = 50000;
 $cfg['Export']['sql_comments']       = FALSE;
 $cfg['Export']['sql_mime']           = FALSE;
 $cfg['Export']['sql_header_comment'] = ''; // \n is replaced by new line

 $cfg['Export']['pdf_structure']      = FALSE;
 $cfg['Export']['pdf_data']           = TRUE;
 $cfg['Export']['pdf_report_title']   = '';

 /**
  * Import defaults
  */
 $cfg['Import']['format'] = 'sql';
 $cfg['Import']['allow_interrupt'] = TRUE;
 $cfg['Import']['skip_queries'] = '0';
 $cfg['Import']['sql_compatibility'] = 'NONE';
 $cfg['Import']['csv_replace'] = FALSE;
 $cfg['Import']['csv_terminated'] = ';';
 $cfg['Import']['csv_enclosed'] = '"';
 $cfg['Import']['csv_escaped'] = '\\';
 $cfg['Import']['csv_new_line'] = 'auto';
 $cfg['Import']['csv_columns'] = '';
 $cfg['Import']['ldi_replace'] = FALSE;
 $cfg['Import']['ldi_terminated'] = ';';
 $cfg['Import']['ldi_enclosed'] = '"';
 $cfg['Import']['ldi_escaped'] = '\\';
 $cfg['Import']['ldi_new_line'] = 'auto';
 $cfg['Import']['ldi_columns'] = '';
 $cfg['Import']['ldi_local_option'] = 'auto'; // 'auto' for autodetection, TRUE or FALSE for forcing


 /**
  * Link to the official MySQL documentation.
  * Be sure to include no trailing slash on the path.
  * See http://dev.mysql.com/doc/ for more information
  * about MySQL manuals and their types.
  */
 $cfg['MySQLManualBase'] = 'http://dev.mysql.com/doc/refman';

 /**
  * Type of MySQL documentation:
  * viewable - "viewable online", current one used on MySQL website
  * searchable - "Searchable, with user comments"
  * chapters - "HTML, one page per chapter"
  * chapters_old - "HTML, one page per chapter", format used prior to MySQL 5.0 release
  * big - "HTML, all on one page"
  * old - old style used in phpMyAdmin 2.3.0 and sooner
  * none - do not show documentation links
  */
 $cfg['MySQLManualType'] = 'viewable';


 /**
  * PDF options
  */
 $cfg['PDFPageSizes']         = array('A3', 'A4', 'A5', 'letter', 'legal');
 $cfg['PDFDefaultPageSize']   = 'A4';


 /**