Server　≫　Linux Server　≫　Fedora 8　≫　ＳＱＬサーバー

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

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

下記のように入力します。青文字が入力文字です。
　 　
　  
 [root@linux]# yum install mysql-server    ← 入力
 fedora                    100% |=========================| 2.1 kB    00:00
 updates                   100% |=========================| 2.3 kB    00:00
 Setting up Install Process
 Parsing package install arguments
 Resolving Dependencies
 --> Running transaction check
 ---> Package mysql-server.i386 0:5.0.45-6.fc8 set to be updated
 --> Processing Dependency: perl(DBI) for package: mysql-server
 --> Processing Dependency: mysql = 5.0.45-6.fc8 for package: mysql-server
 --> Processing Dependency: perl-DBI for package: mysql-server
 --> Processing Dependency: libmysqlclient.so.15(libmysqlclient_15) for package: mysql-server
 --> Processing Dependency: perl-DBD-MySQL 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
 --> Running transaction check
 ---> Package perl-DBD-MySQL.i386 0:4.005-2.fc8.1 set to be updated
 ---> Package perl-DBI.i386 0:1.58-2.fc8 set to be updated
 ---> Package mysql.i386 0:5.0.45-6.fc8 set to be updated
 ---> Package mysql-libs.i386 0:5.0.45-6.fc8 set to be updated
 --> Finished Dependency Resolution

 Dependencies Resolved

 =============================================================================
  Package                    Arch       Version            Repository   Size
 =============================================================================
 Installing:
  mysql-server               i386       5.0.45-6.fc8       updates      9.8 M
 Installing for dependencies:
  mysql                      i386       5.0.45-6.fc8       updates      2.7 M
  mysql-libs i386 5.0.45-6.fc8 updates 1.5 M
  perl-DBD-MySQL             i386       4.005-2.fc8.1      fedora       143 k
  perl-DBI                   i386       1.58-2.fc8         fedora       715 k

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

 Total download size: 15 M
 Is this ok [y/N]: y   ← y を入力
 Downloading Packages:
 (1/5): mysql-libs-5.0.45- 100% |=========================| 1.5 MB    00:01
 (2/5): mysql-5.0.45-6.fc8 100% |=========================| 2.7 MB    00:01
 (3/5): mysql-server-5.0.4 100% |=========================| 9.8 MB    00:04
 (4/5): perl-DBI-1.58-2.fc 100% |=========================| 715 kB    00:00
 (5/5): perl-DBD-MySQL-4.0 100% |=========================| 143 kB    00:00
 Running rpm_check_debug
 Running Transaction Test
 Finished Transaction Test
 Transaction Test Succeeded
 Running Transaction
   Installing: mysql-libs                   ######################### [1/5]
   Installing: perl-DBI                     ######################### [2/5]
   Installing: perl-DBD-MySQL               ######################### [3/5]
   Installing: mysql                        ######################### [4/5]
   Installing: mysql-server                 ######################### [5/5]

 Installed: mysql-server.i386 0:5.0.45-6.fc8
 Dependency Installed: mysql.i386 0:5.0.45-6.fc8 mysql-libs.i386 0:5.0.45-6.fc8 perl-DBD-MySQL.i386
 0:4.005-2.fc8.1 perl-DBI.i386 0:1.58-2.fc8
 Complete!    ← Complete! と表示されれば完了
　
　 　
　 　
◆ ＭｙＳＱＬサーバーの起動
　 　
　 下記のように入力します。青文字が入力文字です。
　 　
　
 [root@linux]# /etc/rc.d/init.d/mysqld start    ← 入力
 MySQL データベースを初期化中: WARNING: The host 'fedira-server.papa-et.info' could not be looked up with
 resolveip.
 This probably means that your libc libraries are not 100 % compatible
 with this binary MySQL version. The MySQL daemon, mysqld, should work
 normally with the exception that host name resolving will not work.
 This means that you should use IP addresses instead of hostnames
 when specifying MySQL privileges !
 Installing MySQL system tables...
 OK
 Filling help tables...
 OK

 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 fedora7-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 mysql-test-run.pl
 cd mysql-test ; perl mysql-test-run.pl

 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      ← 入力
 
　 　
　 自動起動設定の確認。下記のように入力し 、下記のように表示されればＯＫです。青文字が入力文字です。
　 　
　  
 [root@linux]# chkconfig --list mysqld     ← 入力
 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     ← 入力
 Welcome to the MySQL monitor. Commands end with ; or \g.
 Your MySQL connection id is 2
 Server version: 5.0.45 Source distribution

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

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

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

locaihost の root のパスワードを設定します。下記のように入力します。青文字が入力文字です。
　 　
　  
 mysql> set password for root@localhost=password('******');     ← ****** がパスワードです
 Query OK, 0 rows affected (0.00 sec)
　
　 　
　 fedora8-server の root のパスワードを設定します。下記のように入力します。青文字が入力文字です。
　 　
　  
 mysql> set password for root@'fedora-server'=password('******');     ← ****** がパスワードです
 Query OK, 0 rows affected (0.00 sec)
　
　 　
　 127.0.0.1 の root のパスワードを設定します。下記のように入力します。青文字が入力文字です。
　 　
　  
 mysql> set password for root@'127.0.0.1'=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 | fedora7-server | **************** |    ← パスワードが設定された ( fedora7-server の root )
 | root | 127.0.0.1      | **************** |    ← パスワードが設定された ( 127.0.0.1 の root )
 +------+----------------+------------------+
 3 rows in set (0.00 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; を入力
 Query OK, 0 rows affected (0.05 sec)
　
　 　
　 削除の確認です。下記のように入力します。青文字が入力文字です。
　 　
　  
 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 3
 Server version: 5.0.45 Source distribution

 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    ← 入力
 fedora                    100% |=========================| 2.1 kB 00:00
 updates                   100% |=========================| 2.3 kB 00:00
 Setting up Install Process
 Parsing package install arguments
 Resolving Dependencies
 --> Running transaction check
 ---> Package php-mysql.i386 0:5.2.4-3 set to be updated
 --> Processing Dependency: php-pdo for package: php-mysql
 --> Processing Dependency: php-common = 5.2.4-3 for package: php-mysql
 --> Running transaction check
 ---> Package php-common.i386 0:5.2.4-3 set to be updated
 ---> Package php-pdo.i386 0:5.2.4-3 set to be updated
 --> Finished Dependency Resolution

 Dependencies Resolved

 =============================================================================
  Package                    Arch       Version           Repository    Size
 =============================================================================
 Installing:
  php-mysql                  i386       5.2.4-3           fedora         80 k
 Installing for dependencies:
  php-common                 i386       5.2.4-3           fedora        221 k
  php-pdo                    i386       5.2.4-3           fedora         60 k

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

 Total download size: 358 k
 Is this ok [y/N]: y   ← y を入力
 Downloading Packages:
 (1/3): php-pdo-5.2.4-3.i3 100% |=========================|  60 kB    00:00
 (2/3): php-common-5.2.4-3 100% |=========================| 221 kB    00:00
 (3/3): php-mysql-5.2.4-3. 100% |=========================|  80 kB    00:00
 Running rpm_check_debug
 Running Transaction Test
 Finished Transaction Test
 Transaction Test Succeeded
 Running Transaction
   Installing: php-common                   ######################### [1/3]
   Installing: php-pdo                      ######################### [2/3]
   Installing: php-mysql                    ######################### [3/3]

 Installed: php-mysql.i386 0:5.2.4-3
 Dependency Installed: php-common.i386 0:5.2.4-3 php-pdo.i386 0:5.2.4-3
 Complete!    ← Complete! と表示されれば完了
　
　 　
　 次に phpmyadmin に必要な PHP をインストールします。

下記のように入力します。青文字が入力文字です。
　 　
　
 [root@linux]# yum install php    ← 入力
 fedora                    100% |=========================| 2.1 kB 00:00
 updates                   100% |=========================| 2.3 kB 00:00
 Setting up Install Process
 Parsing package install arguments
 Resolving Dependencies
 --> Running transaction check
 ---> Package php.i386 0:5.2.4-3 set to be updated
 --> Processing Dependency: php-cli = 5.2.4-3 for package: php
 --> Running transaction check
 ---> Package php-cli.i386 0:5.2.4-3 set to be updated
 --> Finished Dependency Resolution

 Dependencies Resolved

 =============================================================================
  Package                    Arch       Version           Repository    Size
 =============================================================================
 Installing:
  php                        i386       5.2.4-3           fedora        1.3 M

 Installing for dependencies:
  php-cli                    i386       5.2.4-3           fedora        2.5 M

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

 Total download size: 3.8 M
 Is this ok [y/N]: y   ← y を入力
 Downloading Packages:
 (1/2): php-5.2.4-3.i386.r 100% |=========================| 1.3 MB    00:09
 (2/2): php-cli-5.2.4-3.i3 100% |=========================| 2.5 MB    00:12
 Running rpm_check_debug
 Running Transaction Test
 Finished Transaction Test
 Transaction Test Succeeded
 Running Transaction
   Installing: php-cli                      ######################### [1/2]
   Installing: php                          ######################### [2/2]

 Installed: php.i386 0:5.2.4-3
 Dependency Installed: php-cli.i386 0:5.2.4-3
 Complete!    ← Complete! と表示されれば完了
　
　 　
　 次に php-mbstring をインストールします。

下記のように入力します。青文字が入力文字です。
　 　
　
 [root@linux]# yum install php-mbstring    ← 入力
 fedora                    100% |=========================| 2.1 kB 00:00
 updates                   100% |=========================| 2.3 kB 00:00
 Setting up Install Process
 Parsing package install arguments
 Resolving Dependencies
 --> Running transaction check
 ---> Package php-mbstring.i386 0:5.2.4-3 set to be updated
 --> Finished Dependency Resolution

 Dependencies Resolved

 =============================================================================
  Package                    Arch       Version           Repository    Size
 =============================================================================
 Installing:
  php-mbstring               i386       5.2.4-3           fedora        1.1 M

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

 Total download size: 1.1 M
 Is this ok [y/N]: y   ← y を入力
 Downloading Packages:
 (1/1): php-mbstring-5.2.4 100% |=========================| 1.1 MB    00:30
 Running rpm_check_debug
 Running Transaction Test
 Finished Transaction Test
 Transaction Test Succeeded
 Running Transaction
   Installing: php-mbstring                 ######################### [1/1]

 Installed: php-mbstring.i386 0:5.2.4-3
 Complete!    ← Complete! と表示されれば完了
　
　 　
　 　
◆ phpmyadmin のインストール
　 　
　 phpmyadmin を phpMyAdmin のサイトよりダウンロードします。（２００８年５月現在の最新版は phpMyAdmin-2.11.6 です）

下記のように入力します。青文字が入力文字です。
　 　
　  
 [root@linux]# wget -P /usr/local http://jaist.dl.sourceforge.net/sourceforge/phpmyadmin/phpMyAdmin-2.11.
 　　                                                               6-all-languages.tar.gz     ← １行で入力
 --18:24:24-- http://jaist.dl.sourceforge.net/sourceforge/phpmyadmin/phpMyAdmin-2.11.6-all-
 languages.tar.gz
            => `/usr/local/phpMyAdmin-2.11.6-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
 長さ: 4,315,020 (4.1M) [application/x-gzip]

 100%[====================================================>] 4,317,666 499.33K/s ETA 00:00

 18:24:37 (334.26 KB/s) - `/usr/local/phpMyAdmin-2.11.6-all-languages.tar.gz' を保存しました
 [4317666/4317666]
　
　 　
　 ダウンロードしたファイルを解凍します。下記のように入力します。青文字が入力文字です。
　 　
　  
 [root@linux]# tar xzf /usr/local/phpMyAdmin-2.11.6-all-languages.tar.gz -C /home/****/    ← 入力 
 　　　　　　　　　　　　　　　　　　　　　　　　　 （/home/****/ に解凍 **** はＨＰ公開ディレクトリ）
　
　 　
　 展開が完了すると /home/****/ に phpMyAdmin-2.11.6-all-languages と言うフォルダが出来上がります。

この phpMyAdmin-2.11.6-all-languages と言うフォルダを phpmyadmin に名前を変更します。
　 　
　  
 [root@linux]# mv /home/****/phpMyAdmin-2.11.6-all-languages /home/****/phpmyadmin    ← 入力 
 　　　　　　　　　　　　　　　　　　　　　　　　　                  （ **** はＨＰ公開ディレクトリ）
　
　 　
　 最後にダウンロードした不要なファイルを削除します。下記のように入力します。青文字が入力文字です。
　 　
　  
 [root@linux]# rm -rf /usr/local/phpMyAdmin-2.11.6-all-languages.tar.gz    ← 入力 
　
　 　
　 　
◆ phpMyAdmin の設定
　 　
　 上記で解凍したファイルの中より config.default.php を config.inc.php と言う名前にコピーして使います。

下記のように入力します。青文字が入力文字です。
　 　
　
 [root@linux]# cp /home/****/phpmyadmin/libraries/config.default.php /home/****/phpmyadmin/config.inc.php
                                                                      ← 入力（ **** はＨＰ公開ディレクトリ）
　
　 　
　 config.inc.php のアクセス権の変更

下記のように入力します。青文字が入力文字です。
　 　
　
 [root@linux]# chmod 660 /home/****/phpmyadmin/config.inc.php    ← 入力（ **** はＨＰ公開ディレクトリ）
　
　 　
　 phpMyAdmin 設定ファイルの設定です。

下記のように緑色の部分を黄色に変更（書き換え・削除）して下さい。赤文字は説明です。青文字が入力文字です。
　 　
　
 [root@linux]# vi /home/****/phpmyadmin/config.inc.php    ← 入力（ **** はＨＰ公開ディレクトリ）
 <?php
 /* vim: set expandtab sw=4 ts=4 sts=4: */
 /**
 * <code>
 * N   N  OOO  !!   DDDD   OOO    N   N  OOO  TTTTT   EEEE DDDD  I TTTTT !!
 * NN  N O   O !!   D   D O   O   NN  N O   O   T     E    D   D I   T   !!
 * N N N O   O !!   D   D O   O   N N N O   O   T     EEEE D   D I   T   !!
 * N  NN O   O      D   D O   O   N  NN O   O   T     E    D   D I   T
 * N   N  OOO  !!   DDDD   OOO    N   N  OOO    T     EEEE DDDD  I   T   !!
 * </code>
 *
 * DO NOT EDIT THIS FILE, EDIT config.inc.php INSTEAD !!!
 *
 * phpMyAdmin default configuration, you can copy values from here to your
 * config.inc.php
 *
 * All directives are explained in Documentation.html
 *
 * @version $Id: config.default.php 10556 2007-08-11 13:11:31Z lem9 $
 */
 
 
 /**
  * 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.
  *
 * @global string $cfg['PmaAbsoluteUri']
 */
 $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
  *
 * @global boolean $cfg['PmaNoRelation_DisableWarning']
 */
 $cfg['PmaNoRelation_DisableWarning'] = false;

 /**
  * Disable the default warning that is displayed if Suhosin is detected
  *
  * @global boolean $cfg['SuhosinDisableWarning']
  */
 $cfg['SuhosinDisableWarning'] = 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.
  *
 * @global string $cfg['blowfish_secret']
 */
 $cfg['blowfish_secret'] = '';
                ↓
  $cfg['blowfish_secret'] = '**********';    ← 入力 (48文字以内の適当な文字列を入力　この文字列は内部的に
 　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　使うものなので覚えておく必要は無い)
 
 /*******************************************************************************
  * Server(s) configuration
  *
  * The $cfg['Servers'] array starts with $cfg['Servers'][1]. Do not use
  * $cfg['Servers'][0]. You can disable a server configuration entry by setting host
  * to ''. If you want more than one server, just copy following section
  * (including $i incrementation) several times. There is no need to define
  * full server array, just define values you need to change.
  *
  * @global array $cfg['Servers']
  */
 $cfg['Servers'] = array();

 $i = 1;
 /**
  * MySQL hostname or IP address
  *
  * @global string $cfg['Servers'][$i]['host']
  */
 $cfg['Servers'][$i]['host'] = 'localhost';

 /**
  * MySQL port - leave blank for default port
  *
  * @global string $cfg['Servers'][$i]['port']
  */
 $cfg['Servers'][$i]['port'] = '';

 /**
  * Path to the socket - leave blank for default socket
  *
  * @global string $cfg['Servers'][$i]['socket']
  */
 $cfg['Servers'][$i]['socket'] = '';

 /**
  * Use SSL for connecting to MySQL server?
  *
  * @global boolean $cfg['Servers'][$i]['ssl']
  */
 $cfg['Servers'][$i]['ssl'] = false;

 /**
  * How to connect to MySQL server ('tcp' or 'socket')
  *
  * @global string $cfg['Servers'][$i]['connect_type']
  */
 $cfg['Servers'][$i]['connect_type'] = 'tcp';

 /**
  * The PHP MySQL extension to use ('mysql' or 'mysqli')
  *
  * @global string $cfg['Servers'][$i]['extension']
  */
 $cfg['Servers'][$i]['extension'] = 'mysql';

 /**
  * Use compressed protocol for the MySQL connection (requires PHP >= 4.3.0)
  *
  * @global boolean $cfg['Servers'][$i]['compress']
  */
 $cfg['Servers'][$i]['compress'] = false;

 /**
  * MySQL control user settings (this user must have read-only
  *
  * @global string $cfg['Servers'][$i]['controluser']
  */
 $cfg['Servers'][$i]['controluser'] = '';

 /**
  * access to the "mysql/user" and "mysql/db" tables). The controluser is also
  * used for all relational features (pmadb)
  *
  * @global string $cfg['Servers'][$i]['controlpass']
  */
 $cfg['Servers'][$i]['controlpass'] = '';

 /**
  * Authentication method (valid choices: config, http, signon or cookie)
  *
  * @global string $cfg['Servers'][$i]['auth_type']
  */
 $cfg['Servers'][$i]['auth_type'] = 'config';
                 ↓                                                                                based)?
  $cfg['Servers'][$i]['auth_type'] = 'cookie';    ← 入力（cookie に変更）
 
 /**
  * MySQL user
  *
  * @global string $cfg['Servers'][$i]['user']
  */
 $cfg['Servers'][$i]['user'] = 'root';

 /**
  * MySQL password (only needed with 'config' auth_type)
  *
  * @global string $cfg['Servers'][$i]['password']
  */
 $cfg['Servers'][$i]['password'] = '';

 /**
  * Session to use for 'signon' authentication method
  *
  * @global string $cfg['Servers'][$i]['SignonSession']
  */
 $cfg['Servers'][$i]['SignonSession'] = '';

 /**
  * URL where to redirect user to login for 'signon' authentication method
  *
  * @global string $cfg['Servers'][$i]['SignonURL']
  */
 $cfg['Servers'][$i]['SignonURL'] = '';

 /**
  * URL where to redirect user after logout
  *
  * @global string $cfg['Servers'][$i]['LogoutURL']
  */
 $cfg['Servers'][$i]['LogoutURL'] = '';

 /**
  * Whether to try to connect without password
  *
  * @global boolean $cfg['Servers'][$i]['nopassword']
  */
 $cfg['Servers'][$i]['nopassword'] = false;

 /**
  * 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 order is relevant.
  *
  * @global string $cfg['Servers'][$i]['only_db']
  */
 $cfg['Servers'][$i]['only_db'] = '';

 /**
  * Database name to be hidden from listings
  *
  * @global string $cfg['Servers'][$i]['hide_db']
  */
 $cfg['Servers'][$i]['hide_db'] = '';

 /**
  * Verbose name for this host - leave blank to show the hostname
  * (for HTTP authentication, all non-US-ASCII characters will be stripped)
  *
  * @global string $cfg['Servers'][$i]['verbose']
  */
 $cfg['Servers'][$i]['verbose'] = '';

 /**
  * Database used for Relation, Bookmark and PDF Features
  * (see scripts/create_tables.sql)
  *   - leave blank for no support
  *     DEFAULT: 'phpmyadmin'
  *
  * @global string $cfg['Servers'][$i]['pmadb']
  */
 $cfg['Servers'][$i]['pmadb'] = '';

 /**
  * Bookmark table
  *   - leave blank for no bookmark support
  *     DEFAULT: 'pma_bookmark'
  *
  * @global string $cfg['Servers'][$i]['bookmarktable']
  */
 $cfg['Servers'][$i]['bookmarktable'] = '';

 /**
  * table to describe the relation between links (see doc)
  *   - leave blank for no relation-links support
  *     DEFAULT: 'pma_relation'
  *
  * @global string $cfg['Servers'][$i]['relation']
  */
 $cfg['Servers'][$i]['relation'] = '';

 /**
  * table to describe the display fields
  *   - leave blank for no display fields support
  *     DEFAULT: 'pma_table_info'
  *
  * @global string $cfg['Servers'][$i]['table_info']
  */
 $cfg['Servers'][$i]['table_info'] = '';

 /**
  * table to describe the tables position for the PDF schema
  *   - leave blank for no PDF schema support
  *     DEFAULT: 'pma_table_coords'
  *
  * @global string $cfg['Servers'][$i]['table_coords']
  */
 $cfg['Servers'][$i]['table_coords'] = '';

 /**
  * table to describe pages of relationpdf
  *   - leave blank if you don't want to use this
  *     DEFAULT: 'pma_pdf_pages'
  *
  * @global string $cfg['Servers'][$i]['pdf_pages']
  */
 $cfg['Servers'][$i]['pdf_pages'] = '';

 /**
  * table to store column information
  *   - leave blank for no column comments/mime types
  *     DEFAULT: 'pma_column_info'
  *
  * @global string $cfg['Servers'][$i]['column_info']
  */
 $cfg['Servers'][$i]['column_info'] = '';

 /**
  * table to store SQL history
  *   - leave blank for no SQL query history
  *     DEFAULT: 'pma_history'
  *
  * @global string $cfg['Servers'][$i]['history']
  */
 $cfg['Servers'][$i]['history'] = '';

 /**
  * table to store the coordinates for Designer
  *   - leave blank for no Designer feature
  *     DEFAULT: 'pma_designer_coords'
  *
  * @global string $cfg['Servers'][$i]['designer_coords']
  */
 $cfg['Servers'][$i]['designer_coords'] = '';

 /**
  * set to false if you know that your pma_* tables are up to date.
  * This prevents compatibility checks and thereby increases performance.
  *
  * @global boolean $cfg['Servers'][$i]['verbose_check']
  */
 $cfg['Servers'][$i]['verbose_check'] = true;

 /**
  * whether to allow root login
  *
  * @global boolean $cfg['Servers'][$i]['AllowRoot']
  */
 $cfg['Servers'][$i]['AllowRoot'] = true;

 /**
  * Host authentication order, leave blank to not use
  *
  * @global string $cfg['Servers'][$i]['AllowDeny']['order']
  */
 $cfg['Servers'][$i]['AllowDeny']['order'] = '';

 /**
  * Host authentication rules, leave blank for defaults
  *
  * @global array $cfg['Servers'][$i]['AllowDeny']['rules']
  */
 $cfg['Servers'][$i]['AllowDeny']['rules'] = array();

 /**
  * Default server (0 = no default server)
  *
  * If you have more than one server configured, you can set $cfg['ServerDefault']
  * to any one of them to auto-connect 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.
  *
  * @global integer $cfg['ServerDefault']
  */
 $cfg['ServerDefault'] = 1;

 /*
  * Other core phpMyAdmin settings
  */
 /**
  * maximum number of db's displayed in left frame and database list
  *
  * @global integer $cfg['MaxDbList']
  */
 $cfg['MaxDbList'] = 100;

 /**
  * maximum number of tables displayed in table list
  *
  * @global integer $cfg['MaxTableList']
  */
 $cfg['MaxTableList'] = 250;

 /**
  * maximum number of characters when a SQL query is displayed
  *
  * @global integer $cfg['MaxCharactersInDisplayedSQL']
  */
 $cfg['MaxCharactersInDisplayedSQL'] = 1000;

 /**
  * use GZIP output buffering if possible (true|false|'auto')
  *
  * @global string $cfg['OBGzip']
  */
 $cfg['OBGzip'] = 'auto';

 /**
  * use persistent connections to MySQL database
  *
  * @global boolean $cfg['PersistentConnections']
  */
 $cfg['PersistentConnections'] = false;

 /**
  * whether to force using HTTPS
  *
  * @global boolean $cfg['ForceSSL']
  */
 $cfg['ForceSSL'] = false;

 /**
  * maximum execution time in seconds (0 for no limit)
  *
  * @global integer $cfg['ExecTimeLimit']
  */
 $cfg['ExecTimeLimit'] = 300;

 /**
  * maximum allocated bytes (0 for no limit)
  *
  * @global integer $cfg['MemoryLimit']
  */
 $cfg['MemoryLimit'] = 0;

 /**
  * mark used tables, make possible to show locked tables (since MySQL 3.23.30)
  *
  * @global boolean $cfg['SkipLockedTables']
  */
 $cfg['SkipLockedTables'] = false;

 /**
  * show SQL queries as run
  *
  * @global boolean $cfg['ShowSQL']
  */
 $cfg['ShowSQL'] = true;

 /**
  * show a 'Drop database' link to normal users
  *
  * @global boolean $cfg['AllowUserDropDatabase']
  */
 $cfg['AllowUserDropDatabase'] = false;

 /**
  * confirm 'DROP TABLE' & 'DROP DATABASE'
  *
  * @global boolean $cfg['Confirm']
  */
 $cfg['Confirm'] = true;

 /**
  * recall previous login in cookie authentication mode or not
  *
  * @global boolean $cfg['LoginCookieRecall']
  */
 $cfg['LoginCookieRecall'] = true;

 /**
  * validity of cookie login (in seconds)
  *
  * @global integer $cfg['LoginCookieValidity']
  */
 $cfg['LoginCookieValidity'] = 1800;

 /**
  * how long login cookie should be stored (in seconds)
  *
  * @global integer $cfg['LoginCookieStore']
  */
 $cfg['LoginCookieStore'] = 0;

 /**
  * whether to delete all login cookies on logout
  *
  * @global boolean $cfg['LoginCookieDeleteAll']
  */
 $cfg['LoginCookieDeleteAll'] = true;

 /**
  * whether to enable the "database search" feature or not
  *
  * @global boolean $cfg['UseDbSearch']
  */
 $cfg['UseDbSearch'] = true;

 /**
  * if set to true, PMA continues computing multiple-statement queries
  * even if one of the queries failed
  *
  * @global boolean $cfg['IgnoreMultiSubmitErrors']
  */
 $cfg['IgnoreMultiSubmitErrors'] = false;

 /**
  * if set to true, PMA will show the affected rows of EACH statement on
  * multiple-statement queries. See the libraries/import.php file for
  * hard coded defaults on how many queries a statement may contain!
  *
  * @global boolean $cfg['VerboseMultiSubmit']
  */
 $cfg['VerboseMultiSubmit'] = true;

 /**
  * allow login to any user entered server in cookie based authentication
  *
  * @global boolean $cfg['AllowArbitraryServer']
  */
 $cfg['AllowArbitraryServer'] = false;


 /*******************************************************************************
  * Left frame setup
  */

 /**
  * use a select-based menu and display only the current tables in the left frame.
  *
  * @global boolean $cfg['LeftFrameLight']
  */
 $cfg['LeftFrameLight'] = true;

 /**
  * turn the select-based light menu into a tree
  *
  * @global boolean $cfg['LeftFrameDBTree']
  */
 $cfg['LeftFrameDBTree'] = true;

 /**
  * the separator to sub-tree the select-based light menu tree
  *
  * @global string $cfg['LeftFrameDBSeparator']
  */
 $cfg['LeftFrameDBSeparator'] = '_';

 /**
  * Which string will be used to generate table prefixes
  * to split/nest tables into multiple categories
  *
  * @global string $cfg['LeftFrameTableSeparator']
  */
 $cfg['LeftFrameTableSeparator']= '__';

 /**
  * How many sublevels should be displayed when splitting up tables by the above Separator
  *
  * @global integer $cfg['LeftFrameTableLevel']
  */
 $cfg['LeftFrameTableLevel'] = '1';

 /**
  * display table comment as tooltip in left frame
  *
  * @global boolean $cfg['ShowTooltip']
  */
 $cfg['ShowTooltip'] = true;

 /**
  * if ShowToolTip is enabled, this defines that table/db comments
  *
  * @global boolean $cfg['ShowTooltipAliasDB']
  */
 $cfg['ShowTooltipAliasDB'] = false;

 /**
  * are shown (in the left menu and db_structure) instead of table/db names.
  * Setting ShowTooltipAliasTB to 'nested' will only use the Aliases for nested
  * descriptors, not the table itself.
  *
  * @global boolean $cfg['ShowTooltipAliasTB']
  */
 $cfg['ShowTooltipAliasTB'] = false;

 /**
  * display logo at top of left frame
  *
  * @global boolean $cfg['LeftDisplayLogo']
  */
 $cfg['LeftDisplayLogo'] = true;

 /**
  * where should logo link point to (can also contain an external URL)
  *
  * @global string $cfg['LeftLogoLink']
  */
 $cfg['LeftLogoLink'] = 'main.php';

 /**
  * whether to open the linked page in the main window ('main') or
  * in a new window ('new')
  *
  * @global string $cfg['LeftLogoLinkWindow']
  */
 $cfg['LeftLogoLinkWindow'] = 'main';

 /**
  * display server choice at top of left frame
  *
  * @global boolean $cfg['LeftDisplayServers']
  */
 $cfg['LeftDisplayServers'] = false;

 /**
  * server choice as links
  *
  * @global boolean $cfg['DisplayServersList']
  */
 $cfg['DisplayServersList'] = false;

 /**
  * database choice in light as links
  *
  * @global boolean $cfg['DisplayDatabasesList']
  */
 $cfg['DisplayDatabasesList'] = 'auto';


 /*******************************************************************************
  * In the main frame, at startup...
  */

 /**
  * allow to display statistics and space usage in the pages about database
  * details and table properties
  *
  * @global boolean $cfg['ShowStats']
  */
 $cfg['ShowStats'] = true;

 /**
  * show PHP info link
  *
  * @global boolean $cfg['ShowPhpInfo']
  */
 $cfg['ShowPhpInfo'] = false;

 /**
  * show MySQL server information
  *
  * @global boolean $cfg['ShowServerInfo']
  */
 $cfg['ShowServerInfo'] = true;

 /**
  * show change password link
  *
  * @global boolean $cfg['ShowChgPassword']
  */
 $cfg['ShowChgPassword'] = false;

 /**
  * show create database form
  *
  * @global boolean $cfg['ShowCreateDb']
  */
 $cfg['ShowCreateDb'] = true;

 /**
  * suggest a new DB name if possible (false = keep empty)
  *
  * @global boolean $cfg['SuggestDBName']
  */
 $cfg['SuggestDBName'] = true;


 /*******************************************************************************
  * In browse mode...
  */

 /**
  * display blob field contents
  *
  * @global boolean $cfg['ShowBlob']
  */
 $cfg['ShowBlob'] = false;

 /**
  * Use icons instead of text for the navigation bar buttons
  * and on right panel top menu (server db table) (true|false|'both')
  *
  * @global string $cfg['NavigationBarIconic']
  */
 $cfg['NavigationBarIconic'] = 'both';

 /**
  * allows to display all the rows
  *
  * @global boolean $cfg['ShowAll']
  */
 $cfg['ShowAll'] = false;

 /**
  * maximum number of rows to display
  *
  * @global integer $cfg['MaxRows']
  */
 $cfg['MaxRows'] = 30;

 /**
  * 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-)
  *
  * @global string $cfg['Order']
  */
 $cfg['Order'] = 'ASC';


 /*******************************************************************************
  * In edit mode...
  */

 /**
  * disallow editing of binary fields
  * valid values are:
  * false allow editing
  * 'blob' allow editing except for BLOB fields
  * 'all' disallow editing
  *
  * @global string $cfg['ProtectBinary']
  */
 $cfg['ProtectBinary'] = 'blob';

 /**
  * Display the function fields in edit/insert mode
  *
  * @global boolean $cfg['ShowFunctionFields']
  */
 $cfg['ShowFunctionFields'] = true;

 /**
  * Which editor should be used for CHAR/VARCHAR fields:
  *  input - allows limiting of input length
  *  textarea - allows newlines in fields
  *
  * @global string $cfg['CharEditing']
  */
 $cfg['CharEditing'] = 'input';

 /**
  * How many rows can be inserted at one time
  *
  * @global integer $cfg['InsertRows']
  */
 $cfg['InsertRows'] = 2;

 /**
  * Sort order for items in a foreign-key drop-down list.
  * 'content' is the referenced data, 'id' is the key value.
  *
  * @global array $cfg['ForeignKeyDropdownOrder']
  */
 $cfg['ForeignKeyDropdownOrder'] = array('content-id', 'id-content');

 /**
  * A drop-down list will be used if fewer items are present
  *
  * @global integer $cfg['ForeignKeyMaxLimit']
  */
 $cfg['ForeignKeyMaxLimit'] = 100;


 /*******************************************************************************
  * For the export features...
  */

 /**
  * Allow the use of zip/gzip/bzip
  *
  * @global boolean $cfg['ZipDump']
  */
 $cfg['ZipDump'] = true;

 /**
  * compression for
  *
  * @global boolean $cfg['GZipDump']
  */
 $cfg['GZipDump'] = true;

 /**
  * dump files
  *
  * @global boolean $cfg['BZipDump']
  */
 $cfg['BZipDump'] = 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.
  *
  * @global boolean $cfg['CompressOnFly']
  */
 $cfg['CompressOnFly'] = true;


 /*******************************************************************************
  * Tabs display settings
  */

 /**
  * use graphically less intense menu tabs
  *
  * @global boolean $cfg['LightTabs']
  */
 $cfg['LightTabs'] = false;

 /**
  * Use icons instead of text for the table display of a database (true|false|'both')
  *
  * @global boolean $cfg['PropertiesIconic']
  */
 $cfg['PropertiesIconic'] = true;

 /**
  * How many columns should be used for table display of a database?
  * (a value larger than 1 results in some information being hidden)
  *
  * @global integer $cfg['PropertiesNumColumns']
  */
 $cfg['PropertiesNumColumns'] = 1;

 /**
  * 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
  *
  * @global string $cfg['DefaultTabServer']
  */
 $cfg['DefaultTabServer'] = 'main.php';

 /**
  * Possible values:
  * 'db_structure.php' = tables list
  * 'db_sql.php' = SQL form
  * 'db_search.php' = search query
  * 'db_operations.php' = operations on database
  *
  * @global string $cfg['DefaultTabDatabase']
  */
 $cfg['DefaultTabDatabase'] = 'db_structure.php';

 /**
  * Possible values:
  * 'tbl_structure.php' = fields list
  * 'tbl_sql.php' = SQL form
  * 'tbl_select.php' = select page
  * 'tbl_change.php' = insert row page
  * 'sql.php' = browse page
  *
  * @global string $cfg['DefaultTabTable']
  */
 $cfg['DefaultTabTable'] = 'tbl_structure.php';


 /*******************************************************************************
  * Export defaults
  */
 $cfg['Export'] = array();

 /**
  * sql/latex/excel/csv/xml/xls/htmlexcel/htmlword/ods/odt
  *
  * @global string $cfg['Export']['format']
  */
 $cfg['Export']['format'] = 'sql';

 /**
  * none/zip/gzip/bzip2
  *
  * @global string $cfg['Export']['compression']
  */
 $cfg['Export']['compression'] = 'none';

 /**
  *
  *
  * @global boolean $cfg['Export']['asfile']
  */
 $cfg['Export']['asfile'] = false;

 /**
  *
  *
  * @global string $cfg['Export']['charset']
  */
 $cfg['Export']['charset'] = '';

 /**
  *
  *
  * @global boolean $cfg['Export']['onserver']
  */
 $cfg['Export']['onserver'] = false;

 /**
  *
  *
  * @global boolean $cfg['Export']['onserver_overwrite']
  */
 $cfg['Export']['onserver_overwrite'] = false;

 /**
  *
  *
  * @global boolean $cfg['Export']['remember_file_template']
  */
 $cfg['Export']['remember_file_template'] = true;

 /**
  *
  *
  * @global string $cfg['Export']['file_template_table']
  */
 $cfg['Export']['file_template_table'] = '__TABLE__';

 /**
  *
  *
  * @global string $cfg['Export']['file_template_database']
  */
 $cfg['Export']['file_template_database'] = '__DB__';

 /**
  *
  *
  * @global string $cfg['Export']['file_template_server']
  */
 $cfg['Export']['file_template_server'] = '__SERVER__';

 /**
  *
  *
  * @global boolean $cfg['Export']['ods_columns']
  */
 $cfg['Export']['ods_columns'] = false;

 /**
  *
  *
  * @global string $cfg['Export']['ods_null']
  */
 $cfg['Export']['ods_null'] = 'NULL';

 /**
  *
  *
  * @global boolean $cfg['Export']['odt_structure']
  */
 $cfg['Export']['odt_structure'] = true;

 /**
  *
  *
  * @global boolean $cfg['Export']['odt_data']
  */
 $cfg['Export']['odt_data'] = true;

 /**
  *
  *
  * @global boolean $cfg['Export']['odt_columns']
  */
 $cfg['Export']['odt_columns'] = true;

 /**
  *
  *
  * @global boolean $cfg['Export']['odt_relation']
  */
 $cfg['Export']['odt_relation'] = true;

 /**
  *
  *
  * @global boolean $cfg['Export']['odt_comments']
  */
 $cfg['Export']['odt_comments'] = true;

 /**
  *
  *
  * @global boolean $cfg['Export']['odt_mime']
  */
 $cfg['Export']['odt_mime'] = true;

 /**
  *
  *
  * @global string $cfg['Export']['odt_null']
  */
 $cfg['Export']['odt_null'] = 'NULL';

 /**
  *
  *
  * @global boolean $cfg['Export']['htmlexcel_columns']
  */
 $cfg['Export']['htmlexcel_columns'] = false;

 /**
  *
  *
  * @global string $cfg['Export']['htmlexcel_null']
  */
 $cfg['Export']['htmlexcel_null'] = 'NULL';

 /**
  *
  *
  * @global boolean $cfg['Export']['htmlword_structure']
  */
 $cfg['Export']['htmlword_structure'] = true;

 /**
  *
  *
  * @global boolean $cfg['Export']['htmlword_data']
  */
 $cfg['Export']['htmlword_data'] = true;

 /**
  *
  *
  * @global boolean $cfg['Export']['htmlword_columns']
  */
 $cfg['Export']['htmlword_columns'] = false;

 /**
  *
  *
  * @global string $cfg['Export']['htmlword_null']
  */
 $cfg['Export']['htmlword_null'] = 'NULL';

 /**
  *
  *
  * @global boolean $cfg['Export']['xls_columns']
  */
 $cfg['Export']['xls_columns'] = false;

 /**
  *
  *
  * @global string $cfg['Export']['xls_null']
  */
 $cfg['Export']['xls_null'] = 'NULL';

 /**
  *
  *
  * @global boolean $cfg['Export']['csv_columns']
  */
 $cfg['Export']['csv_columns'] = false;

 /**
  *
  *
  * @global string $cfg['Export']['csv_null']
  */
 $cfg['Export']['csv_null'] = 'NULL';

 /**
  *
  *
  * @global string $cfg['Export']['csv_separator']
  */
 $cfg['Export']['csv_separator'] = ';';

 /**
  *
  *
  * @global string $cfg['Export']['csv_enclosed']
  */
 $cfg['Export']['csv_enclosed'] = '"';

 /**
  *
  *
  * @global string $cfg['Export']['csv_escaped']
  */
 $cfg['Export']['csv_escaped'] = '\\';

 /**
  *
  *
  * @global string $cfg['Export']['csv_terminated']
  */
 $cfg['Export']['csv_terminated'] = 'AUTO';

 /**
  *
  *
  * @global boolean $cfg['Export']['excel_columns']
  */
 $cfg['Export']['excel_columns'] = false;

 /**
  *
  *
  * @global string $cfg['Export']['excel_null']
  */
 $cfg['Export']['excel_null'] = 'NULL';

 /**
  * win/mac
  *
  * @global string $cfg['Export']['excel_edition']
  */
 $cfg['Export']['excel_edition'] = 'win';

 /**
  *
  *
  * @global boolean $cfg['Export']['latex_structure']
  */
 $cfg['Export']['latex_structure'] = true;

 /**
  *
  *
  * @global boolean $cfg['Export']['latex_data']
  */
 $cfg['Export']['latex_data'] = true;

 /**
  *
  *
  * @global boolean $cfg['Export']['latex_columns']
  */
 $cfg['Export']['latex_columns'] = true;

 /**
  *
  *
  * @global boolean $cfg['Export']['latex_relation']
  */
 $cfg['Export']['latex_relation'] = true;

 /**
  *
  *
  * @global boolean $cfg['Export']['latex_comments']
  */
 $cfg['Export']['latex_comments'] = true;

 /**
  *
  *
  * @global boolean $cfg['Export']['latex_mime']
  */
 $cfg['Export']['latex_mime'] = true;

 /**
  *
  *
  * @global string $cfg['Export']['latex_null']
  */
 $cfg['Export']['latex_null'] = '\textit{NULL}';

 /**
  *
  *
  * @global boolean $cfg['Export']['latex_caption']
  */
 $cfg['Export']['latex_caption'] = true;

 /**
  *
  *
  * @global string $cfg['Export']['latex_structure_caption']
  */
 $cfg['Export']['latex_structure_caption'] = 'strLatexStructure';

 /**
  *
  *
  * @global string $cfg['Export']['latex_structure_continued_caption']
  */
 $cfg['Export']['latex_structure_continued_caption'] = 'strLatexStructure strLatexContinued';

 /**
  *
  *
  * @global string $cfg['Export']['latex_data_caption']
  */
 $cfg['Export']['latex_data_caption'] = 'strLatexContent';

 /**
  *
  *
  * @global string $cfg['Export']['latex_data_continued_caption']
  */
 $cfg['Export']['latex_data_continued_caption'] = 'strLatexContent strLatexContinued';

 /**
  *
  *
  * @global string $cfg['Export']['latex_data_label']
  */
 $cfg['Export']['latex_data_label'] = 'tab:__TABLE__-data';

 /**
  *
  *
  * @global string $cfg['Export']['latex_structure_label']
  */
 $cfg['Export']['latex_structure_label'] = 'tab:__TABLE__-structure';

 /**
  *
  *
  * @global boolean $cfg['Export']['sql_structure']
  */
 $cfg['Export']['sql_structure'] = true;

 /**
  *
  *
  * @global boolean $cfg['Export']['sql_data']
  */
 $cfg['Export']['sql_data'] = true;

 /**
  *
  *
  * @global string $cfg['Export']['sql_compatibility']
  */
 $cfg['Export']['sql_compatibility'] = 'NONE';

 /**
  *
  *
  * @global boolean $cfg['Export']['sql_disable_fk']
  */
 $cfg['Export']['sql_disable_fk'] = false;

 /**
  *
  *
  * @global boolean $cfg['Export']['sql_use_transaction']
  */
 $cfg['Export']['sql_use_transaction'] = false;

 /**
  *
  *
  * @global boolean $cfg['Export']['sql_drop_database']
  */
 $cfg['Export']['sql_drop_database'] = false;

 /**
  *
  *
  * @global boolean $cfg['Export']['sql_drop_table']
  */
 $cfg['Export']['sql_drop_table'] = false;

 /**
  *
  *
  * @global boolean $cfg['Export']['sql_if_not_exists']
  * true by default for correct behavior when dealing with exporting
  * of VIEWs and the stand-in table
  */
 $cfg['Export']['sql_if_not_exists'] = true;

 /**
  *
  *
  * @global boolean $cfg['Export']['sql_procedure_function']
  */
 $cfg['Export']['sql_procedure_function'] = false;

 /**
  *
  *
  * @global boolean $cfg['Export']['sql_auto_increment']
  */
 $cfg['Export']['sql_auto_increment'] = true;

 /**
  *
  *
  * @global boolean $cfg['Export']['sql_backquotes']
  */
 $cfg['Export']['sql_backquotes'] = true;

 /**
  *
  *
  * @global boolean $cfg['Export']['sql_dates']
  */
 $cfg['Export']['sql_dates'] = false;

 /**
  *
  *
  * @global boolean $cfg['Export']['sql_relation']
  */
 $cfg['Export']['sql_relation'] = false;

 /**
  *
  *
  * @global boolean $cfg['Export']['sql_columns']
  */
 $cfg['Export']['sql_columns'] = true;

 /**
  *
  *
  * @global boolean $cfg['Export']['sql_delayed']
  */
 $cfg['Export']['sql_delayed'] = false;

 /**
  *
  *
  * @global boolean $cfg['Export']['sql_ignore']
  */
 $cfg['Export']['sql_ignore'] = false;

 /**
  *
  *
  * @global boolean $cfg['Export']['sql_hex_for_blob']
  */
 $cfg['Export']['sql_hex_for_blob'] = true;

 /**
  * insert/update/replace
  *
  * @global string $cfg['Export']['sql_type']
  */
 $cfg['Export']['sql_type'] = 'insert';

 /**
  *
  *
  * @global boolean $cfg['Export']['sql_extended']
  */
 $cfg['Export']['sql_extended'] = true;

 /**
  *
  *
  * @global integer $cfg['Export']['sql_max_query_size']
  */
 $cfg['Export']['sql_max_query_size'] = 50000;

 /**
  *
  *
  * @global boolean $cfg['Export']['sql_comments']
  */
 $cfg['Export']['sql_comments'] = false;

 /**
  *
  *
  * @global boolean $cfg['Export']['sql_mime']
  */
 $cfg['Export']['sql_mime'] = false;

 /**
  * \n is replaced by new line
  *
  * @global string $cfg['Export']['sql_header_comment']
  */
 $cfg['Export']['sql_header_comment'] = '';

 /**
  *
  *
  * @global boolean $cfg['Export']['pdf_structure']
  */
 $cfg['Export']['pdf_structure'] = false;

 /**
  *
  *
  * @global boolean $cfg['Export']['pdf_data']
  */
 $cfg['Export']['pdf_data'] = true;

 /**
  *
  *
  * @global string $cfg['Export']['pdf_report_title']
  */
 $cfg['Export']['pdf_report_title'] = '';


 /*******************************************************************************
  * Import defaults
  */
 $cfg['Import'] = array();

 /**
  *
  *
  * @global string $cfg['Import']['format']
  */
 $cfg['Import']['format'] = 'sql';

 /**
  *
  *
  * @global boolean $cfg['Import']['allow_interrupt']
  */
 $cfg['Import']['allow_interrupt'] = true;

 /**
  *
  *
  * @global integer $cfg['Import']['skip_queries']
  */
 $cfg['Import']['skip_queries'] = '0';

 /**
  *
  *
  * @global string $cfg['Import']['sql_compatibility']
  */
 $cfg['Import']['sql_compatibility'] = 'NONE';

 /**
  *
  *
  * @global boolean $cfg['Import']['csv_replace']
  */
 $cfg['Import']['csv_replace'] = false;

 /**
  *
  *
  * @global string $cfg['Import']['csv_terminated']
  */
 $cfg['Import']['csv_terminated'] = ';';

 /**
  *
  *
  * @global string $cfg['Import']['csv_enclosed']
  */
 $cfg['Import']['csv_enclosed'] = '"';

 /**
  *
  *
  * @global string $cfg['Import']['csv_escaped']
  */
 $cfg['Import']['csv_escaped'] = '\\';

 /**
  *
  *
  * @global string $cfg['Import']['csv_new_line']
  */
 $cfg['Import']['csv_new_line'] = 'auto';

 /**
  *
  *
  * @global string $cfg['Import']['csv_columns']
  */
 $cfg['Import']['csv_columns'] = '';

 /**
  *
  *
  * @global boolean $cfg['Import']['ldi_replace']
  */
 $cfg['Import']['ldi_replace'] = false;

 /**
  *
  *
  * @global string $cfg['Import']['ldi_terminated']
  */
 $cfg['Import']['ldi_terminated'] = ';';

 /**
  *
  *
  * @global string $cfg['Import']['ldi_enclosed']
  */
 $cfg['Import']['ldi_enclosed'] = '"';

 /**
  *
  *
  * @global string $cfg['Import']['ldi_escaped']
  */
 $cfg['Import']['ldi_escaped'] = '\\';

 /**
  *
  *
  * @global string $cfg['Import']['ldi_new_line']
  */
 $cfg['Import']['ldi_new_line'] = 'auto';

 /**
  *
  *
  * @global string $cfg['Import']['ldi_columns']
  */
 $cfg['Import']['ldi_columns'] = '';

 /**
  * 'auto' for auto-detection, true or false for forcing
  *
  * @global string $cfg['Import']['ldi_local_option']
  */
 $cfg['Import']['ldi_local_option'] = 'auto';

 /**
  * 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.
  *
  * @global string $cfg['MySQLManualBase']
  */
 $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
  *
  * @global string $cfg['MySQLManualType']
  */
 $cfg['MySQLManualType'] = 'viewable';


 /*******************************************************************************
  * PDF options
  */

 /**
  *
  *
  * @global array $cfg['PDFPageSizes']
  */
 $cfg['PDFPageSizes'] = array('A3', 'A4', 'A5', 'letter', 'legal');

 /**
  *
  *
  * @global string $cfg['PDFDefaultPageSize']
  */
 $cfg['PDFDefaultPageSize'] = 'A4';


 /*******************************************************************************
  * Language and character set conversion settings
  */

 /**
  * Default language to use, if not browser-defined or user-defined
  *
  * @global string $cfg['DefaultLang']
  */
 $cfg['DefaultLang'] = 'en-iso-8859-1';
                 ↓ 
 $cfg['DefaultLang'] = 'ja-euc';    ← 入力（日本語に変更）
 
 /**
  * Default connection collation (used for MySQL >= 4.1)
  *
  * @global string $cfg['DefaultConnectionCollation']
  */
 $cfg['DefaultConnectionCollation'] = 'utf8_unicode_ci';

 /**
  * Force: always use this language - must be defined in
  * libraries/select_lang.lib.php
  * $cfg['Lang'] = 'en-iso-8859-1';
  *
  * Regular expression to limit listed languages, e.g. '^(cs|en)' for Czech and
  * English only
  *
  * @global string $cfg['FilterLanguages']
  */
 $cfg['FilterLanguages'] = '';

 /**
  * Default character set to use for recoding of MySQL queries, does not take
  * any effect when character sets recoding is switched off by
  * $cfg['AllowAnywhereRecoding'] or in language file
  * (see $cfg['AvailableCharsets'] to possible choices, you can add your own)
  *
  * @global string $cfg['DefaultCharset']
  */
 $cfg['DefaultCharset'] = 'iso-8859-1';
                 ↓ 
 $cfg['DefaultCharset'] = 'ja-euc';    ← 入力（日本語に変更）

 /**
  * Allow character set recoding of MySQL queries, must be also enabled in language
  * file to make harder using other language files than Unicode.
  * Default value is false to avoid problems on servers without the iconv
  * extension and where dl() is not supported
  *
  * @global boolean $cfg['AllowAnywhereRecoding']
  */
 $cfg['AllowAnywhereRecoding'] = false;

 /**
  * You can select here which functions will be used for character set conversion.
  * Possible values are:
  * auto - automatically use available one (first is tested iconv, then
  * recode)
  * iconv - use iconv or libiconv functions
  * recode - use recode_string function
  *
  * @global string $cfg['RecodingEngine']
  */
 $cfg['RecodingEngine'] = 'auto';

 /**
  * Specify some parameters for iconv used in character set conversion. See iconv
  * documentation for details:
  * http://www.gnu.org/software/libiconv/documentation/libiconv/iconv_open.3.html
  *
  * @global string $cfg['IconvExtraParams']
  */
 $cfg['IconvExtraParams'] = '//TRANSLIT';

 /**
  * Available character sets for MySQL conversion. currently contains all which could
  * be found in lang/* files and few more.
  * Character sets will be shown in same order as here listed, so if you frequently
  * use some of these move them to the top.
  *
  * @global array $cfg['AvailableCharsets']
  */
 $cfg['AvailableCharsets'] = array(
     'iso-8859-1',
     'iso-8859-2',
     'iso-8859-3',
     'iso-8859-4',
     'iso-8859-5',
     'iso-8859-6',
     'iso-8859-7',
     'iso-8859-8',
     'iso-8859-9',
     'iso-8859-10',
     'iso-8859-11',
     'iso-8859-12',
     'iso-8859-13',
     'iso-8859-14',
     'iso-8859-15',
     'windows-1250',
     'windows-1251',
     'windows-1252',
     'windows-1256',
     'windows-1257',
     'koi8-r',
     'big5',
     'gb2312',
     'utf-16',
     'utf-8',
     'utf-7',
     'x-user-defined',
     'euc-jp',
     'ks_c_5601-1987',
     'tis-620',
     'SHIFT_JIS'
 );


 /*******************************************************************************
  * Customization & design
  *
  * The graphical settings are now located in themes/theme-name/layout.inc.php
  */

 /**
  * enable the left panel pointer
  * (used when LeftFrameLight is false)
  * see also LeftPointerColor
  * in layout.inc.php
  *
  * @global boolean $cfg['LeftPointerEnable']
  */
 $cfg['LeftPointerEnable'] = true;

 /**
  * enable the browse pointer
  * see also BrowsePointerColor
  * in layout.inc.php
  *
  * @global boolean $cfg['BrowsePointerEnable']
  */
 $cfg['BrowsePointerEnable'] = true;

 /**
  * enable the browse marker
  * see also BrowseMarkerColor
  * in layout.inc.php
  *
  * @global boolean $cfg['BrowseMarkerEnable']
  */
 $cfg['BrowseMarkerEnable'] = true;

 /**
  * textarea size (columns) in edit mode
  * (this value will be emphasized (*2) for SQL
  * query textareas and (*1.25) for query window)
  *
  * @global integer $cfg['TextareaCols']
  */
 $cfg['TextareaCols'] = 40;

 /**
  * textarea size (rows) in edit mode
  *
  * @global integer $cfg['TextareaRows']
  */
 $cfg['TextareaRows'] = 7;

 /**
  * double size of textarea size for LONGTEXT fields
  *
  * @global boolean $cfg['LongtextDoubleTextarea']
  */
 $cfg['LongtextDoubleTextarea'] = true;

 /**
  * auto-select when clicking in the textarea of the query-box
  *
  * @global boolean $cfg['TextareaAutoSelect']
  */
 $cfg['TextareaAutoSelect'] = true;

 /**
  * textarea size (columns) for CHAR/VARCHAR
  *
  * @global integer $cfg['CharTextareaCols']
  */
 $cfg['CharTextareaCols'] = 40;

 /**
  * textarea size (rows) for CHAR/VARCHAR
  *
  * @global integer $cfg['CharTextareaRows']
  */
 $cfg['CharTextareaRows'] = 2;
 
 /**
  * Enable Ctrl+Arrows moving between fields when editing?
  *
  * @global boolean $cfg['CtrlArrowsMoving']
  */
 $cfg['CtrlArrowsMoving'] = true;
 
 /**
  * Max field data length in browse mode for all non-numeric fields
  *
  * @global integer $cfg['LimitChars']
  */
 $$cfg['LimitChars'] = 50;

 /**
  * show edit/delete links on left side of browse
  * (or at the top with vertical browse)
  *
  * @global boolean $cfg['ModifyDeleteAtLeft']
  */
 $cfg['ModifyDeleteAtLeft'] = true;
 
 /**
  * show edit/delete links on right side of browse
  * (or at the bottom with vertical browse)
  *
  * @global boolean $cfg['ModifyDeleteAtRight']
  */
 $cfg['ModifyDeleteAtRight'] = false;
 
 /**
  * default display direction (horizontal|vertical|horizontalflipped)
  *
  * @global string $cfg['DefaultDisplay']
  */
 $cfg['DefaultDisplay'] = 'horizontal';
 
 /**
  * default display direction for altering/creating columns (tbl_properties)
  * (horizontal|vertical|<number>)
  * number indicates maximal number for which vertical model is used
  *
  * @global integer $cfg['DefaultPropDisplay']
  */
 $cfg['DefaultPropDisplay'] = 3;
 
 /**
  * table-header rotation via faking or CSS? (css|fake)
  * NOTE: CSS only works in IE browsers!
  *
  * @global string $cfg['HeaderFlipType']
  */
 $cfg['HeaderFlipType'] = 'css';

 /**
  * shows stored relation-comments in 'browse' mode.
  *
  * @global boolean $cfg['ShowBrowseComments']
  */
 $cfg['ShowBrowseComments'] = true;

 /**
  * shows stored relation-comments in 'table property' mode.
  *
  * @global boolean $cfg['ShowPropertyComments']
  */
 $cfg['ShowPropertyComments']= true;

 /**
  * repeat header names every X cells? (0 = deactivate)
  *
  * @global integer $cfg['RepeatCells']
  */
 $cfg['RepeatCells'] = 100;

 /**
  * Set to true if Edit link should open the query to edit in the query window
  * (assuming JavaScript is enabled), and to false if we should edit in the right panel
  *
  * @global boolean $cfg['EditInWindow']
  */
 $cfg['EditInWindow'] = true;

 /**
  * Width of Query window
  *
  * @global integer $cfg['QueryWindowWidth']
  */
 $cfg['QueryWindowWidth'] = 550;

 /**
  * Height of Query window
  *
  * @global integer $cfg['QueryWindowHeight']
  */
 $cfg['QueryWindowHeight'] = 310;

 /**
  * Set to true if you want DB-based query history.If false, this utilizes
  * JS-routines to display query history (lost by window close)
  *
  * @global boolean $cfg['QueryHistoryDB']
  */
 $cfg['QueryHistoryDB'] = false;

 /**
  * which tab to display in the querywindow on startup
  * (sql|files|history|full)
  *
  * @global string $cfg['QueryWindowDefTab']
  */
 $cfg['QueryWindowDefTab'] = 'sql';

 /**
  * When using DB-based query history, how many entries should be kept?
  *
  * @global integer $cfg['QueryHistoryMax']
  */
 $cfg['QueryHistoryMax'] = 25;

 /**
  * Use MIME-Types (stored in column comments table) for
  *
  * @global boolean $cfg['BrowseMIME']
  */
 $cfg['BrowseMIME'] = true;

 /**
  * When approximate count < this, PMA will get exact count for table rows.
  *
  * @global integer $cfg['MaxExactCount']
  */
 $cfg['MaxExactCount'] = 20000;

 /**
  * Zero means that no row count is done for views; see the doc
  *
  * @global integer $cfg['MaxExactCountViews']
  */
 $cfg['MaxExactCountViews'] = 0;

 /**
  * Utilize DHTML/JS capabilities to allow WYSIWYG editing of
  * the PDF page editor. Requires an IE6/Gecko based browser.
  *
  * @global boolean $cfg['WYSIWYG-PDF']
  */
 $cfg['WYSIWYG-PDF'] = true;

 /**
  * Sort table and database in natural order
  *
  * @global boolean $cfg['NaturalOrder']
  */
 $cfg['NaturalOrder'] = true;


 //-----------------------------------------------------------------------------
 // custom-setup by mkkeck: 2004-05-04
 //    some specials for new icons and scrolling
 /**
  * @todo 2004-05-08 rabus: We need to rearrange these variables.
  */


 /*******************************************************************************
  * Window title settings
  */

 /**
  * title of browser window when a table is selected
  *
  * @global string $cfg['TitleTable']
  */
 $cfg['TitleTable'] = '@HTTP_HOST@ / @VSERVER@ / @DATABASE@ / @TABLE@ | @PHPMYADMIN@';

 /**
  * title of browser window when a database is selected
  *
  * @global string $cfg['TitleDatabase']
  */
 $cfg['TitleDatabase'] = '@HTTP_HOST@ / @VSERVER@ / @DATABASE@ | @PHPMYADMIN@';

 /**
  * title of browser window when a server is selected
  *
  * @global string $cfg['TitleServer']
  */
 $cfg['TitleServer'] = '@HTTP_HOST@ / @VSERVER@ | @PHPMYADMIN@';

 /**
  * title of browser window when nothing is selected
  * @global string $cfg['TitleDefault']
  */
 $cfg['TitleDefault'] = '@HTTP_HOST@ | @PHPMYADMIN@';

 /**
  * show some icons for warning, error and information messages (true|false)?
  *
  * @global boolean $cfg['ErrorIconic']
  */
 $cfg['ErrorIconic'] = true;

 /**
  * show icons in list on main page and on menu tabs (true|false)?
  *
  * @global boolean $cfg['MainPageIconic']
  */
 $cfg['MainPageIconic'] = true;

 /**
  * show help button instead of strDocu (true|false)?
  *
  * @global boolean $cfg['ReplaceHelpImg']
  */
 $cfg['ReplaceHelpImg'] = true;


 /*******************************************************************************
  * theme manager
  */

 /**
  * using themes manager please set up here the path to 'themes' else leave empty
  *
  * @global string $cfg['ThemePath']
  */
 $cfg['ThemePath'] = './themes';

 /**
  * if you want to use selectable themes and if ThemesPath not empty
  * set it to true, else set it to false (default is false);
  *
  * @global boolean $cfg['ThemeManager']
  */
 $cfg['ThemeManager'] = true;

 /**
  * set up default theme, if ThemePath not empty you can set up here an valid
  * path to themes or 'original' for the original pma-theme
  *
  * @global string $cfg['ThemeDefault']
  */
 $cfg['ThemeDefault'] = 'original';

 /**
  * allow different theme for each configured server
  *
  * @global boolean $cfg['ThemePerServer']
  */
 $cfg['ThemePerServer'] = false;


 /*******************************************************************************
  *
  */

 /**
  * Default queries
  * %d will be replaced by the database name.
  * %t will be replaced by the table name.
  * %f will be replaced by a list of field names.
  * (%t and %f only applies to DefaultQueryTable)
  *
  * @global string $cfg['DefaultQueryTable']
  */
 $cfg['DefaultQueryTable'] = 'SELECT * FROM %t WHERE 1';

 /**
  * Default queries
  * %d will be replaced by the database name.
  * %t will be replaced by the table name.
  * %f will be replaced by a list of field names.
  * (%t and %f only applies to DefaultQueryTable)
  *
  * @global string $cfg['DefaultQueryDatabase']
  */
 $cfg['DefaultQueryDatabase'] = '';


 /*******************************************************************************
  * SQL Query box settings
  * These are the links display in all of the SQL Query boxes
  *
  * @global array $cfg['SQLQuery']
  */
 $cfg['SQLQuery'] = array();

 /**
  * Edit link to change a query
  *
  * @global boolean $cfg['SQLQuery']['Edit']
  */
 $cfg['SQLQuery']['Edit'] = true;

 /**
  * EXPLAIN on SELECT queries
  *
  * @global boolean $cfg['SQLQue