Configuration¶

Server connection settinλ→↕gs¶

$cfg['Servers']¶

Type

array

Default value

one server array with settings listed beπ¶ λlow

Since version 1.4.2, phpMyAdmin supp↓∞orts the administration of multiple MyS&•QL servers. Therefore, a $cfg['Servers']-array has been added which contains the login i¶™₽nformation for the different™© servers. The first $cfg['Servers'][$i]['host'] contains the hostname ofε÷ the first server, the second $cfg['Servers'][$i]['host'] the hostname of the second server, etc. In libraries/config.defauγ$lt.php, there is only one section fφ≈or server definition, however you can put as×↔ many as you need in config.inc.php, copy that block or needed p​ ✔‍arts (you don’t have to define all <®↕↕settings, just those you need t✘©o change).

Note

The $cfg['Servers'] array starts with $cfg[‘Servers’][1].→"σ♦ Do not use $cfg[‘Servers’][0]. If yo ♦↑±u want more than one serδ"ver, just copy following ®↑section (including $i increment) seveα δral times. There is no need to define fβ→β♦ull server array, just defin$£≈e values you need to c£✔hange.

$cfg['Servers'][$i]['host']¶

Type

string

Default value

'localhost'

The hostname or IP address of your $i-th MySQL-server. E.g. localhost.

Possible values are:

• hostname, e.g., 'localhost' or 'mydb.example.org'

• IP address, e.g., '127.0.0.1' or '192.168.10.1'

• IPv6 address, e.g. 2001:cdba:0000:0000:0000♦£φ:0000:3257:9652

• dot - '.', i.e., use named pipes on windows systems

• empty - '', disables this server

Note

The hostname localhost is handled specially by MySQL and it us≠®∑£es the socket based connection protocol. To¶ ™π use TCP/IP networking,↕✘  use an IP address or hostname such as→'"™ 127.0.0.1 or db.example.com. You can configure the★✘Ω≤ path to the socket with $cfg['Servers'][$i]['socket'].

See also

$cfg['Servers'][$i]['port'], <https://dev.mysql.com/doc/refman/8.0/en/¥↔σconnecting.html>

$cfg['Servers'][$i][σ‌®δ'port']¶

Type

string

Default value

''

The port-number of you  ♣r $i-th MySQL-server. Default is 3306 (leave bl€←ank).

Note

If you use localhost as the hostname, MySQ♠¥L ignores this port number  ♠↕and connects with the socket, so if you w‌∞λ™ant to connect to a port di≤γφfferent from the defau↔≠​₩lt port, use 127.0.0.1 or the real hostname in $cfg['Servers'][$i]['ho<Ω‌>st'].

See also

$cfg['Servers'][$i]['host'], <https://dev.mysql.com/doc/refma₩↕≥n/8.0/en/connecting.html>

$cfg['Servers'][$i]['so'•cket']¶

Type

string

Default value

''

The path to the socket to use. Lea✔↑ve blank for default. To determine the c∏λorrect socket, check your MySQL configu​γ≠ration or, using the mysql command–line client, issue the status command. Among the resulting info¥♦♠rmation displayed will be the↑₹ socket used.

Note

This takes effect only if $cfg['Servers'][$i]['h₹β •ost'] is set to localhost.

See also

$cfg['Servers'][$i]['host'], <https://dev.mysql.com/doc/refman/8.0/en/connec™₩↔ting.html>

$cfg['Servers'][$i][↕≠♥'ssl']¶

Type

boolean

Default value

false

Whether to enable SSL for the ×∑γconnection between phpMyAdmin and the MySQL se‌×rver to secure the cαε✘onnection.

When using the 'mysql' extension, none of the remaining 'ssl...' configuration options apply$×€≥.

We strongly recommend the 'mysqli' extension when using this option.

See also

Using SSL for connection to database server, Google Cloud SQL with SSL, Amazon RDS Aurora with SS÷€L, $cfg['Servers'][$i]['ssl_key'], $cfg['Servers'][$i][≈φ☆'ssl_cert'], $cfg['Servers'][$i]['ssl_ca'], $cfg['Servers'][$i]['ssl_ca_path'], $cfg['Servers'][$i]['ssl_ciphers'], $cfg['Servers'][$i]['®<ssl_verify']

$cfg['Servers'][$i]['ssl_key']¶

Type

string

Default value

NULL

Path to the client kα£→ey file when using SSL for connecting to →✔the MySQL server. This is used♥σ to authenticate the client to the server€‌.

For example:

$cfg['Servers'][$i]['ssl_key'] = '/etc/mysql/server-key.pπ em';

See also

Using SSL for connection to databas'δεφe server, Google Cloud SQL with SSL, Amazon RDS Aurora with SSL€→, $cfg['Servers'][$i]['ssl'], $cfg['Servers'][$i]['ssl_cert'], $cfg['Servers'][$i]['s↓∑sl_ca'], $cfg['Servers'][$i]['ssl_ca_path€ε'], $cfg['Servers'][$i]['ssl_ciphers'], $cfg['Servers'][$i]['ssl_verify']

$cfg['Servers'][$i]['ssl_cert']¶

Type

string

Default value

NULL

Path to the client certificate file when usin≠₹g SSL for connecting to the MySQL server. ♥₽This is used to authenticate the client←≥ to the server.

See also

Using SSL for connection to database serve‌↔≈¥r, Google Cloud SQL with S↓∏↔×SL, Amazon RDS Aurora with SSL, $cfg['Servers'][$i]['ssl'], $cfg['Servers'][$i]['ssl_k¶ ey'], $cfg['Servers'][$i]['ssl_ca'], $cfg['Servers'][$i]['ssl_ca_path'], $cfg['Servers'][$i]['ssl_ciphers'], $cfg['Servers'][$i]['ssl_verify'™β§]

$cfg['Servers'][$i]['ss¥πl_ca']¶

Type

string

Default value

NULL

Path to the CA file when using €♦​SSL for connecting to the ↕α®&MySQL server.

See also

Using SSL for connection ×σ©to database server, Google Cloud SQL with SSL, Amazon RDS Aurora wit≈ h SSL, $cfg['Servers'][$i]['ssl'÷≤λ], $cfg['Servers'][$i]['ssl_k♠‌ ey'], $cfg['Servers'][$i][∞π'ssl_cert'], $cfg['Servers'][$i]['ssl_ca_path'☆↑♥], $cfg['Servers'][$i]['s®≠<sl_ciphers'], $cfg['Servers'][$i]['ssl_verify']

$cfg['Servers'][$i]['ssl_ca_≠≤♦path']¶

Type

string

Default value

NULL

Directory containing trusted SSL CA ce‌&↔αrtificates in PEM form♣β≈at.

See also

Using SSL for connection to database §π ×server, Google Cloud SQL withβ₩"‍ SSL, Amazon RDS Aurora with SSL, $cfg['Servers'][$i]['♥∏¥λssl'], $cfg['Servers'][$i]['ssl_key'], $cfg['Servers'][$i]['ssλπσl_cert'], $cfg['Servers'][$i]['ssl_ca'¥✔±≤], $cfg['Servers'][$i]['ssl_ciphers'], $cfg['Servers'][$i]['ssl_verify']

$cfg['Servers'][$i]['ssl_ciphers']¶

Type

string

Default value

NULL

List of allowable ciphers for SSL∑♦¥£ connections to the MySQL server↔¥≈≠.

See also

Using SSL for connection to database ¥Ωserver, Google Cloud SQL with SSL, Amazon RDS Aurora with SSL, $cfg['Servers'][$i]['ssl'], $cfg['Servers'][$i]['ssl_kφ£♥φey'], $cfg['Servers'][$i]['ssl_cert'₹♠♠±], $cfg['Servers'][$i]['ssl_ca'], $cfg['Servers'][$i]['ssl_ca_path'], $cfg['Servers'][$i]['ssl_verify']

$cfg['Servers'][$i]['ssl_verify']¶

Type

boolean

Default value

true

New in version 4.6.0: This is supported since phpMyAdmin 4.6.0.

If your PHP install uses the MySQL Native Dri♥&★ver (mysqlnd), your MySQ♠‌£L server is 5.6 or later, and your SSL γ∏βcertificate is self-signed, there is a cha☆♥&nce your SSL connection will fa¶β✘↔il due to validation. Setting this to¥‌✘♦ false will disable the validation check.

Since PHP 5.6.0 it also verifies wh₽☆ether server name ma$¶tches CN of its certificate. There ≠<' is currently no way to disab↓•Ωαle just this check without disablin÷ ® g complete SSL verification.

Warning

Disabling the certificate verificatio÷↔× n defeats purpose of €≠✘using SSL. This will make the connection £¥≈ vulnerable to man in the middle≈±← attacks.

Note

This flag only works wi♦≤εth PHP 5.6.16 or later.

See also

Using SSL for connection to database server×∞≠¥, Google Cloud SQL with&φ₽¶ SSL, Amazon RDS Aurora wi↑®th SSL, $cfg['Servers'][$i]['ssl'], $cfg['Servers'][$i]['ssl_key'], $cfg['Servers'][$i]['ssl_cert'≥& ∞], $cfg['Servers'][$i]['ssl_ca'], $cfg['Servers'][$i]['ssl_ca_path'], $cfg['Servers'][$i]['ssl_ciphers'], $cfg['Servers'][$i][£σ≈←'ssl_verify']

$cfg['Servers'][$i]['connect_type'♣±↕]¶

Type

string

Default value

'tcp'

Deprecated since ver§∏&sion 4.7.0: This setting is no longer used as of ™ ≠4.7.0, since MySQL decidδ↑es the connection type based on host, so iπ¥t could lead to unexpected results. Please σλφset $cfg['Servers'][$i]['host'] accordingly instead.

What type connection to use with the"ε∑ MySQL server. Your options are 'socket' and 'tcp'. It defaults to tcp as that is nearly gu☆¥ aranteed to be availa♣&‍ble on all MySQL servers, while sockets ar"§≥∏e not supported on some platforms. To use © εthe socket mode, your MySQL s±×erver must be on the "×☆ same machine as the Web server.

$cfg['Servers'][$i]['compress']¶

Type

boolean

Default value

false

Whether to use a compressed protoco€φσl for the MySQL serve★≠≤≥r connection or not (expe∞ &€rimental).

$cfg['Servers'][$i]['con★  trolhost']¶

Type

string

Default value

''

Permits to use an alternate host toσα hold the configuration storage data.

See also

$cfg['Servers'][$i]['control_*']

$cfg['Servers'][$i]['controlport']¶

Type

string

Default value

''

Permits to use an alternate port to ≥‍connect to the host thaα≥ ←t holds the configuration storage.

See also

$cfg['Servers'][$i]['c‍✘ontrol_*']

$cfg['Servers'][$i]['controluser']¶

Type

string

Default value

''

$cfg['Servers'][$i]['controlpass']¶

Type

string

Default value

''

This special account is used to✘✘₹↔ access phpMyAdmin configuration storage. You don’t need it in sing£™∏$le user case, but if phpMyAdmin is $αshared it is recommended to give acc♦→ess to phpMyAdmin configuration stδ∏✔orage only to this user and configure phpMyAdmin ♦©to use it. All users will then b↔↔≤αe able to use the features without need♦© to have direct access to phpMyAdmin configuration storage.

Changed in version 2.2.5:★ו those were called stduser and stdpass

See also

Installation, Using authentication modes, phpMyAdmin configurati'×on storage, $cfg['Servers'][$i]['≠σpmadb'], $cfg['Servers'][$i]['controlhost'], $cfg['Servers'][$i][≤&→γ'controlport'], $cfg['Servers'][$i]['control_*']

$cfg['Servers'][$i]['control_*'δ✔ε]¶

Type

mixed

New in version 4.7.0.

You can change any MyS ★↓QL connection setting for control link (used σ<to access phpMyAdmin configurati₹¥ $on storage) using configuration prefi<≥xed with control_.

This can be used to change any aspect of ™≈​Ωthe control connection, which by ∞∞default uses same parameters as the user one.

For example you can configure ©✔§₹SSL for the control connection:

// Enable SSL
$cfg['Servers'][$i]['control_ssl'] = true;
// Client secret key
$cfg['Servers'][$i]['control_ssl_key'] = '../client-key.pem';
// Client certificate
$cfg['Servers'][$i]['control_ssl_cer←≤±t'] = '../client-cert.pem';
// Server certification authority
$cfg['Servers'][$i]['control_ssl_ca'] = '../server-ca.pem↑££';

See also

$cfg['Servers'][$i]['ssl'], $cfg['Servers'][$i]['ssl_key'], $cfg['Servers'][$i]['ssl‌¥®_cert'], $cfg['Servers'][$i]['ssl_ca'], $cfg['Servers'][$i]['ssl_ca✘ε_path'], $cfg['Servers'][$i]['ssl_ciphers'], $cfg['Servers'][$i]['ssl_verify']

$cfg['Servers'][$i]['auth_type']¶

Type

string

Default value

'cookie'

Whether config or co¶₽okie or HTTP or signon authenticatio©σ≤ n should be used for this server.

• ‘config’ authentication ($auth_type = 'config') is the plain old way: username and password arε₹γ←e stored in config.inc.php.

• ‘cookie’ authentication mode ($auth_type = 'cookie') allows you to log in as '↔any valid MySQL user with the£∑↕♠ help of cookies.

• ‘http’ authentication allows ♠♥φ>you to log in as any valid MySQL use &r via HTTP-Auth.

• ‘signon’ authentication mo ‍↓de ($auth_type = 'signon') allows you to log in from prepared PH$←P session data or using supplied PH>✘P script.

See also

Using authentication modes

$cfg['Servers'][$i]['auth_h↑'♣↓ttp_realm']¶

Type

string

Default value

''

When using auth_type = http, this field allows to define a custom HTTP Basic Auth Realm which will be d 'isplayed to the user. $÷♦≠If not explicitly specified i↕&↓n your configuration, a strin→∑g combined of “phpMyAdmin •€♦₽” and either $cfg['Servers'][$i]['verbose'] or $cfg['Servers'][$i]['host'] will be used.

$cfg['Servers'][$i]['auth_swekey_coα↓nfig']¶

Type

string

Default value

''

New in version 3.0.0.0: This setting was named $cfg[‘Servers’][$i][‘a€₩₩uth_feebee_config’] and was renamed before the☆¶σ∏ 3.0.0.0 release.

Deprecated since version 4.6.4: This setting was removed b↓←∑ecause their servers ♣™ε>are no longer working and it wa↓¥‌‌s not working correctly.

Deprecated since version 4.0.10.17: This setting was remov↔&<>ed in a maintenance release because £₹ their servers are no l£™onger working and it was not work↔↔ing correctly.

The name of the file co≤ ntaining swekey ids and login names fo♠±​r hardware authentication. Leave empt≤>φ¶y to deactivate this feature.

$cfg['Servers'][$i]['user']¶

Type

string

Default value

'root'

$cfg['Servers'][$i]['password']¶

Type

string

Default value

''

When using $cfg['Servers'][$i]['auth↑↑_type'] set to ‘config’, this is the user/passw€÷₹↔ord-pair which phpMyAdm →in will use to connect to the MySQL"    server. This user/password pair is not needed <®<when HTTP or cookie authentication is used and should be ♣₹★empty.

$cfg['Servers'][$i]['n ✘∏opassword']¶

Type

boolean

Default value

false

Deprecated since version 4.7.0: This setting was removed as it can produce unexpe<©cted results.

Allow attempt to log in without passwoφ₽​≈rd when a login with password fails. T±©‍his can be used together with ht±‍tp authentication, when au¶¶thentication is done some ot≠<✘αher way and phpMyAdmin gets user name from au"↓>th and uses empty passwordσ←¥ for connecting to MySQL. Password log¥πin is still tried first, but as fallback, no pass£¶©word method is tried'σ.

$cfg['Servers'][$i]['only_d•✔π✘b']¶

Type

string or array

Default value

''

If set to a (an array of) database n₹✔δ∏ame(s), only this (these) datab↔§ase(s) will be shown to the user. Since phpMyAdmi ↔→n 2.2.1, this/these database(✔∑δ≤s) name(s) may contain MySQL wi₹"↔ldcards characters ( ✘©↑“_” and “%”): if you want to us"≈λ e literal instances of these↕δ< characters, escape theσ↕™‍m (I.E. use 'my\_db' and not 'my_db').

This setting is an efficient way to lo÷&wer the server load since the latter does no∑↕t need to send MySQL requests to build the av>¥♣₹ailable database list. But it does not replace theβ←& privileges rules of t¥‌↔ he MySQL database server. If set, it just means only these databases w±®&ill be displayed but not that all other databases can’t be use✔<d.

An example of using more that o♥♦ne database:

$cfg['Servers'][$i]['only_db'] = ['db1', 'db2'];

Changed in version 4.0.0:←® Previous versions permitted to specify t₽↔he display order of t  δ©he database names via this directive.

$cfg['Servers'][$i]['hide_db'<©✔]¶

Type

string

Default value

''

Regular expression for hidin>≤g some databases from unprivil$>eged users. This only hides them from listingλ'‌, but a user is still able to access them ∏<≈(using, for example, the SQL query areδ"a). To limit access, use the MySQL©©≈♦ privilege system. For example, to hide a& ±€ll databases starting with the letter “a”, use

$cfg['Servers'][$i]['hide_db'] = '^a';

and to hide both “db1” and “db2” use

$cfg['Servers'][$i]['hide_db'] = '^(db1|db2)$';

More information on regular expr↑€essions can be found in the PCRE pattern syntax portion of the PHP reference manu↓♥λal.

$cfg['Servers'][$i]['verbose']¶

Type

string

Default value

''

Only useful when using phpMyAdmin with multi εple server entries. If set, th← is string will be displayed instead of th≤✘e hostname in the pull-down menu on the m∞€© ain page. This can be useful if yo₩$Ωu want to show only certain databases on your sysε∞§≥tem, for example. For HTTP auth, all non- ‌∞₽US-ASCII characters will be strippe↔★d.

$cfg['Servers'][$i]['extension']¶

Type

string

Default value

'mysqli'

Deprecated since version 4.↕↑2.0: This setting was removed. The mysql extension will only be used when the mysqli extension is not available. As of 5 ©.0.0, only the mysqli extension can be used.

The PHP MySQL extension to use (mysql or mysqli).

It is recommended to use mysqli in all installations.₽¥

$cfg['Servers'][$i]['pmadb']¶

Type

string

Default value

''

The name of the database containing the phpMyAd÷×★min configuration storage.

See the phpMyAdmin configuration s✘★ torage section in this document to see the b✔‍enefits of this feature, and fo★δr a quick way of creatinδ↑g this database and the needed ₽<★¥tables.

If you are the only user of this phpMyAdm•"in installation, you canπα‌' use your current da₽Ωtabase to store those special ta<™≥♣bles; in this case, just put your current datab•δ±βase name in $cfg['Servers'][$i]['pmadb']. For a multi-user installat•↔∞ion, set this parameter to the name≥₩​ of your central database containing the ∑≠phpMyAdmin configuration storage.

$cfg['Servers'][$i]['bookmarktable']¶

Type

string or false

Default value

''

New in version 2.2.0.

Since release 2.2.0 phpMyAdmin ₹₹≠<allows users to bookmar→₽•k queries. This can be usefu↑★£l for queries you often run. To allow the ₩✘×εusage of this functionality:

• set up $cfg['Servers'][$i]['pmadb'] and the phpMyAdmin configuration≠→ storage

• enter the table name in $cfg['Servers'][$i]['§‍‍bookmarktable']

This feature can be disa×₩bled by setting the configuration to false.

$cfg['Servers'][$i]['r'♥elation']¶

Type

string or false

Default value

''

New in version 2.2.4.

Since release 2.2.4 you can describe, §♦"in a special ‘relation’ table, which column is aλ♦> key in another table (a​£↑' foreign key). phpMyAdmin currently u♠≠÷™ses this to:

• make clickable, when you¥® browse the master table, the data values∑♠↔≠ that point to the foreign table;姶

• display in an optional tool-tip the “display coluδ ↑mn” when browsing the master∞π←§ table, if you move the mouse to a colum∑±∏n containing a foreign key ±♦✘(use also the ‘table_info’ table); (see 6.7 How can I use the “display column” featu♣±®÷re?)

• in edit/insert mode, display a drop-down ♠₽✘±list of possible foreign keys (key value ≠πand “display column” are ≥≈∑shown) (see 6.21 In edit/insert mo ✘ de, how can I see a list§‍​ of possible values for a column, based   ¶≠on some foreign table?)

• display links on the table properties page, toδ' check referential integrity (display mi✔♥ssing foreign keys) π€•for each described key;

• in query-by-example, create au¥γ £tomatic joins (see 6.6 How can I use the relation tableλ™↑ in Query-by-example?)

• enable you to get a PDF schema of your database (also uses the  ∞←‌table_coords table).

The keys can be numeric or character.

To allow the usage of this functionality< :

• set up $cfg['Servers'][$i]['pmadb'] and the phpMyAdmin configuration storage

• put the relation table÷±Ω name in $cfg['Servers'][$i]['relati£€δ♣on']

• now as normal user op♥☆en phpMyAdmin and for each one of your ta©'↑αbles where you want to£>> use this feature, click Structure/Relation view/ and choose foreign columns.

This feature can be disabled by setting the¶≥£ configuration to false.

Note

In the current version, master_db must be the same as foreign_db. Those columns have been put in fut>↓♠ure development of th±δe cross-db relations.

$cfg['Servers'][$i]['table_info']¶

Type

string or false

Default value

''

New in version 2.3.0.

Since release 2.3.0 you ca♥♠♣n describe, in a special ‘table_inf≈★≥€o’ table, which column is to↑λ×± be displayed as a tool-tip when mov$₹©‍ing the cursor over th> ‌'e corresponding key. This configuration ∑☆variable will hold the name of this special ↔ table. To allow the usage of t☆ ¶his functionality:

• set up $cfg['Servers'][$i]['pmadb'] and the phpMyAdmin confi→'guration storage

• put the table name in $cfg['Servers'][$i]['table_info'] (e.g. pma__table_info)

• then for each table wh✘♥☆ere you want to use this feat₽ ≈ure, click “Structure/Relation view/Choose☆₹™ column to display” to choo♣<se the column.

This feature can be disablε®ed by setting the configuration to false.

See also

6.7 How can I use the ≠γ “display column” feature?

$cfg['Servers'][$i]['tab$£↓le_coords']¶

Type

string or false

Default value

''

The designer feature can save your page la ♣yout; by pressing the “Save page” or “Save✘> page as” button in the<∑λ™ expanding designer menu, you can customize th‍£δ$e layout and have it loaded ® λthe next time you use the designer. That layout $±$≠is stored in this table. Fur★'♠¥thermore, this table is als€‌o required for using the PDF rela&§εtion export feature, see $cfg['Servers'][$i]['pdf_paφ÷₹>ges'] for additional details.

$cfg['Servers'][$i]['pd&•σ₩f_pages']¶

Type

string or false

Default value

''

New in version 2.3.0.

Since release 2.3.0 y₽<"±ou can have phpMyAdm&©'<in create PDF pages showing the relations between Ω® your tables. Further♣♣€', the designer interface permits vβπφαisually managing the relations.↑•λ± To do this it needs two tables “←αpdf_pages” (storing in✔♠formation about the avai★&>lable PDF pages) and “table_coords” (storing ★®♦©coordinates where each table will be placed on a≤‍< PDF schema output). You must be us©ε$εing the “relation” featuλ↑$re.

To allow the usage of this functionality:

• set up $cfg['Servers'][$i]['pmadb'] and the phpMyAdmin configuration storage

• put the correct table βεnames in $cfg['Servers'][$i]['table_coords']®γ'π and $cfg['Servers'][$i]['pdf_pages']

This feature can be disabled by setting ei±>ther of the configurations to false.

See also

6.8 How can I produce a PDF schema of m ✘≤y database?.

$cfg['Servers'][$i]['designer_coord‍★s']¶

Type

string

Default value

''

New in version 2.10.0: Since release 2.10.0 a Designer interface is a♥> ♥vailable; it permits to visually manage the >∞✔φrelations.

Deprecated since version 4.3.0: This setting was removed±±≠✔ and the Designer table positio<←ning data is now stored into $cfg['Servers'][$i]['table_coords'].

Note

You can now delete the table pma__designer_coords from your phpMyAdmin configuration stλ↕→÷orage database and rem¥​©ove $cfg['Servers'][$i]['designer_↑•coords'] from your configuration file.•'"

$cfg['Servers'][$i]['c✘εδolumn_info']¶

Type

string or false

Default value

''

New in version 2.3.0.

This part requires a content update! Since rele" ase 2.3.0 you can store comments to describe eachεφ©  column for each table. These will then be γβ♥≥shown on the “printview”.

Starting with release 2.5.0, comments​§ are consequently used on the table ₹λφαproperty pages and table browse view, sho✘ wing up as tool-tips above the column name (pro∞£perties page) or embedded within the h $eader of table in browse view. They can also b ♥Ωe shown in a table dump. Please see th<>e relevant configuration direct"÷© ives later on.

Also new in release 2.5.0 is a M↔₩IME- transformation syst>∑ &em which is also based on the following table ¥¥₽ structure. See Transformations for further information. ★∞♠εTo use the MIME- transformation system, ↓€≠φyour column_info table has to have the thΩ✔♣±ree new columns ‘mimetype’, ‘tran¶★₹↔sformation’, ‘transformation_options’.

Starting with release 4.3.0, a new input-orie₽σα>nted transformation system has  ✘₩δbeen introduced. Also, backward compatibility★β code used in the old transforβ©mations system was removed. As&φ a result, an update to colum★♥£n_info table is necessa÷ ry for previous transformations and the new&​ input-oriented transformation system to work. ph‍®♣≥pMyAdmin will upgrade it automatically for you b™©¶y analyzing your current column_infoσ∏ table structure. However, if something₽∑δ goes wrong with the auto-upgrade the$™₩n you can use the SQL script found ←☆in ./sql/upgrade_column_i★÷nfo_4_3_0+.sql to upgrade it manually.

To allow the usage of this functi₽δ'₹onality:

• set up $cfg['Servers'][$i]['pmadb'] and the phpMyAdmin configuration‌α storage

• put the table name in $cfg['Servers'][$i]['column_in ↕≠fo'] (e.g. pma__column_info)

• to update your PRE-2.5.0 Column_c≥←<omments table use this: and remember that the Va→÷ riable in config.inc.php has been renamed fro↕ ‌<m $cfg['Servers'][$i]['column_comments'] to $cfg['Servers'][$i]['column_info']

  ALTER TABLE `pma__column_comments`
  ADD `mimetype` VARCHAR( 255 ) NOT NULL,
  ADD `transformation` VARCHAR( 255 ) NOT NULL,
  ADD `transformation_options` VARCHAR( 255 ) NOT NULL;
  

• to update your PRE-4.3.0 Column_info table ↕±₩ manually use this ./sql/upgrade_column_info_4_3♦φ_0+.sql SQL script.

This feature can be disabled by setting the con>≥♣figuration to false.

Note

For auto-upgrade function♠₽≥ality to work, your $cfg['Servers'][$i]['controluse'‌β™r'] must have ALTER privilege on phpmyadmin database. See the MySQL documentation for GRANΩ♥÷T on how to GRANT privileges to a userα‌§→.

$cfg['Servers'][$i]['history']¶

Type

string or false

Default value

''

New in version 2.5.0★☆$☆.

Since release 2.5.0 you can store your SQL history, which means all querie‌♠↓☆s you entered manually into the phpMyAdmin in§₩γ↕terface. If you don’t want to u®'Ω÷se a table-based history,‍₽ you can use the JavaScript-based history.

Using that, all your hi​∑♣>story items are deleted ‍₩↕$when closing the window. Using $cfg['QueryHistoryMa♣ x'] you can specify an am•★"↓ount of history itemΩ×÷₹s you want to have on hold. On every l♣Ωogin, this list gets cut ₩¥to the maximum amount.

The query history is only available if Jav≤÷‍↕aScript is enabled in your browser.

To allow the usage of this↓≈ functionality:

• set up $cfg['Servers'][$i]['pmadbλ π'] and the phpMyAdmin configuration sto•αrage

• put the table name in $cfg['Servers'][$i]['history'] (e.g. pma__history)

This feature can be disabled by setting the ∑Ωconfiguration to false.

$cfg['Servers'][$i]['recent']¶

Type

string or false

Default value

''

New in version 3.5.0.

Since release 3.5.0 you can show recently us₽♦φ≥ed tables in the navig‍ελγation panel. It helps you to jump acr®∏oss table directly, without the nee  d to select the database, a♠®✘nd then select the table. Using $cfg['NumRecentTables'] you can configure the ma<↔®∏ximum number of recent tables s×≠λπhown. When you select a table from the list,σφλ" it will jump to the page specified in $cfg['NavigationTreeDefaultTabTable'].

Without configuring the storage, you​★ ₹ can still access the recently used t<$ables, but it will disa™♠  ppear after you logout.¶ ₹↓

To allow the usage of t​₩ ₽his functionality persistently:

• set up $cfg['Servers'][$i]['¶α←✘pmadb'] and the phpMyAdmin configuration storage

• put the table name in $cfg['Servers'][$i]['recen↑±¶↕t'] (e.g. pma__recent)

This feature can be disabled by setti₩φ∞€ng the configuration to false.

$cfg['Servers'][$i]['favorite']¶

Type

string or false

Default value

''

New in version 4.2.0.

Since release 4.2.0 you ca₽¥¥≠n show a list of selected tabl♣₹δ es in the navigation panel. It helps you to jump₹β to the table directly, wit®÷↓'hout the need to select the database, β§ and then select the tab'↓le. When you select a ✘≠®table from the list, it will ©¥ jump to the page specified in $cfg['NavigationTreeDefaultTabTable'].

You can add tables to this list or reσ≈​move tables from it in ¥×₩→database structure page<→ by clicking on the star i γcons next to table names. Using $cfg['NumFavoriteTables'] you can configure the maximum number of >∑‍favorite tables shown.

Without configuring the storage, you &™>can still access the favoπ"$rite tables, but it will disappear after ♠ $→you logout.

To allow the usage of this ♣​<functionality persist™Ω&×ently:

• set up $cfg['Servers'][$i]['pmadb'] and the phpMyAdmin configuration storage

• put the table name in $cfg['Servers'][$i]['favorite'] (e.g. pma__favorite)

This feature can be disabled♠β  by setting the configuration to false.

$cfg['Servers'][$i]['table_uip↔₽"≈refs']¶

Type

string or false

Default value

''

New in version 3.5.0.

Since release 3.5.0  ♦phpMyAdmin can be configured to remember severa∞δl things (sorted column $cfg['RememberSorting'], column order, and column visibility from a da•✘↕tabase table) for browsing table>≠s. Without configuring tδ"he storage, these features stφ≈ill can be used, but the values will disappear af↔÷γ ter you logout.

To allow the usage of these γβ‌functionality persistently:

• set up $cfg['Servers'][$i]['pmadb'] and the phpMyAdmin configuration sδ✔✘torage

• put the table name in $cfg['Servers'][$i]['table_uiprefs'] (e.g. pma__table_uiprefs)

This feature can be disabled by §✔♥ setting the configura∑< tion to false.

$cfg['Servers'][$i]['users']¶

Type

string or false

Default value

''

The table used by phpMyAdmin to store user name i±​≥∑nformation for associati✘✘☆←ng with user groups. See the Ω‌<next entry on $cfg['Servers'][$i]['usergroups'] for more details and the suggested setting★εs.

$cfg['Servers'][$i]['usergro∏∞♥♦ups']¶

Type

string or false

Default value

''

New in version 4.1.0.

Since release 4.1.0 you can create different user‌σ™ groups with menu items attached to them©∏÷≤. Users can be assigned to these ∏>λgroups and the logged in user would only se'>↓e menu items configured to the usergroup they are♥←♥★ assigned to. To do th"♠∑‌is it needs two tables “usergroups” (storin↑∑g allowed menu items for each user group) and “ ©users” (storing users and their assignme "©¥nts to user groups).

To allow the usage of this functionality:

• set up $cfg['Servers'][$i]['pmadb'] and the phpMyAdmin configuration storage

• put the correct tabl✔♦πe names in $cfg['Servers'][$i]['usersε∏'] (e.g. pma__users) and $cfg['Servers'][$i]['user≥₩ φgroups'] (e.g. pma__usergroups)

This feature can be disabled★≈↑ by setting either of the configur₽‌ations to false.

See also

Configurable menus an α♠÷d user groups

$cfg['Servers'][$i]['navigationβ®hiding']¶

Type

string or false

Default value

''

New in version 4.1.0.

Since release 4.1.0 you c★β an hide/show items in the naviga≤‍​✘tion tree.

To allow the usage of this functi₩☆÷onality:

• set up $cfg['Servers'][$i]['pma₹×∏db'] and the phpMyAdmin configuration storage

• put the table name in $cfg['Servers'][$i]['navigationhiding→♦'] (e.g. pma__navigationhiding)

This feature can be disabl€←ed by setting the configuration to false.

$cfg['Servers'][$i]['cent≠♣ral_columns']¶

Type

string or false

Default value

''

New in version 4.3.0.

Since release 4.3.0 you can have a central π™€↑list of columns per database. Y§₹↔ou can add/remove columns toΩε" the list as per your req§♣™§uirement. These colum ®ns in the central list w™>≥ill be available to use wh'∏ile you create a new column for a table o'↔↕r create a table itself. Yφ>ou can select a column from centralΩ©≈↑ list while creating a new co​σ"↑lumn, it will save you from writing the same c☆ ≈olumn definition over again or from writing ®φ×different names for si‍>≈milar column.

To allow the usage of this δ✘$functionality:

• set up $cfg['Servers'][$i]['pmadb>''] and the phpMyAdmin configuration storage

• put the table name in $cfg['Servers'][$i]['central_columns'] (e.g. pma__central_columnsΩ♣§×)

This feature can be disabled byβ >✘ setting the configuration toק ± false.

$cfg['Servers'][$i]['desi✔✘gner_settings']¶

Type

string or false

Default value

''

New in version 4.5.0.

Since release 4.5.0 your designer ≥€ ≥settings can be remembered. Your choice regarding​£™∏ ‘Angular/Direct Links’, ‘Snap to Grid’, ‘To€♠ ggle Relation Lines’, ‘Small/Big All’,≈ק ‘Move Menu’ and ‘Pin Text’ →♥'±can be remembered persistently.

To allow the usage of this functionality:

• set up $cfg['Servers'][$i]['pmadb'] and the phpMyAdmin configurati∞ on storage

• put the table name in $cfg['Servers'][$i]['design ↑∞er_settings'] (e.g. pma__designer_settings)

This feature can be disable< §d by setting the configuration to false.

$cfg['Servers'][$i]['savedsear↕β ches']¶

Type

string or false

Default value

''

New in version 4.2.0.

Since release 4.2.0 you can save and ™¶load query-by-example searches from the Dδ‍σatabase > Query panel.

To allow the usage of this functional✔★φ"ity:

• set up $cfg['Servers'][$i]['pmadb'] and the phpMyAdmin confiα λguration storage

• put the table name in $cfg['Servers'][$i]['↕€savedsearches'] (e.g. pma__savedsearches)

This feature can be disabled by set Ωting the configuration to false.

$cfg['Servers'][$i]['export_templates'δφ★φ]¶

Type

string or false

Default value

''

New in version 4.5.0.

Since release 4.5.0 you can save and load ex★¥'♣port templates.

To allow the usage of this functionali≠∑←ty:

• set up $cfg['Servers'][$i]['pmadb'] and the phpMyAdmin configuration storage

• put the table name in $cfg['Servers'][$i]['export_templatesα‌'] (e.g. pma__export_templates)

This feature can be disabγ≥ ≠led by setting the c≥↕↓ onfiguration to false.

$cfg['Servers'][$i]['tracking']¶

Type

string or false

Default value

''

New in version 3.3.x.

Since release 3.3.x a tracking mec★↔​&hanism is available. It helps you t♥Ω×₩o track every SQL command which is executed by phpMyAdm₩&in. The mechanism supports logging o≤↕δ≠f data manipulation and data definition stateme÷ <πnts. After enabling it you can create versiβ$ons of tables.

The creation of a version has two effects:

• phpMyAdmin saves a snapshot of the tab & le, including structure and indexes.

• phpMyAdmin logs all commands which changeε≈✔≤ the structure and/or data of the table and lin↑ ks these commands with the version num€λ¶ber.

Of course you can view the tracked changes∞‌Ω. On the Tracking page a complete report is∏∑δ× available for every version. For the report y∑↑✔♣ou can use filters, for example you can get a li₽♣♠€st of statements within a date range. When yo∑↔u want to filter usernames yo↔↓ δu can enter * for all names or you enter a ☆π∑list of names separated by ‘,’. In additiσ‍♠on you can export the (fδ±>δiltered) report to a file or to a β¥≠ temporary database.

To allow the usage of this functionality:

• set up $cfg['Servers'][$i]['pmadb'] and the phpMyAdmin configuration st¥←✘orage

• put the table name in $cfg['Servers'][$i]['tr®β"₩acking'] (e.g. pma__tracking)

This feature can be ©±disabled by setting the ∏≥φconfiguration to false.

$cfg['Servers'][$i]['trackin♣λ∑ g_version_auto_create']↕""¶

Type

boolean

Default value

false

Whether the tracking mechanism c♥↑εreates versions for tables and views automatλ★∑ically.

If this is set to true and you create a table""↑λ or view with

• CREATE TABLE …

• CREATE VIEW …

and no version exists for it, the mechanisσ&m will create a version for you automatically.

$cfg['Servers'][$i]['t♣™→λracking_default_statements']¶

Type

string

Default value

'CREATE TABLE,ALTER TABLE,DROP TABLE,RENAME TABLE,CREATE INDEX,DROP INDEX,INSERT,UPDATE,DELETE,TRUNCATE,REPLACE,CRΩ EATE VIEW,ALTER VIEW,DROP VIEW,CREATE DATABASE,ALTER DATABASE,DROP DATABASE'

Defines the list of statements the auto-§→creation uses for new versions.

$cfg['Servers'][$i]['tracking_add_drop_σ↑↔‌view']¶

Type

boolean

Default value

true

Whether a DROP VIEW IF EXISTS statement will be adde♦∏d as first line to the log when¶γ£₹ creating a view.

$cfg['Servers'][$i]['tracking_add_drop_ta✔♣&​ble']¶

Type

boolean

Default value

true

Whether a DROP TABLE IF EXISTS statement will be added as first line•' to the log when creating a table.¥​γφ

$cfg['Servers'][$i]['tracking_add_dαδπλrop_database']¶

Type

boolean

Default value

true

Whether a DROP DATABASE IF EXISTS statement will be added a♠✔→δs first line to the log£'π when creating a database.

$cfg['Servers'][$i]['userconfig']¶

Type

string or false

Default value

''

New in version 3.4.x.

Since release 3.4.x p‌∞ hpMyAdmin allows users to set most preferences by‍↔ ☆ themselves and store them in the da¥÷tabase.

If you don’t allow for storing pref÷↑♥βerences in $cfg['Servers'][$i]['pmadb'], users can still personalize phpMyAdm π ±in, but settings will be saved in browser’≤¶s local storage, or, it is is unavailable, unΩ₽til the end of session.

To allow the usage of this functionality:

• set up $cfg['Servers'][$i]['pmadb'] and the phpMyAdmin configuration ±≥storage

• put the table name in $cfg['Servers'][$i]['userconfig']

This feature can be disabled by setting th♠§πe configuration to false.

$cfg['Servers'][$i]['MaxTableUiprefs']¶

Type

integer

Default value

100

Maximum number of rows saveΩ<'d in $cfg['Servers'][$i]['tabl®>e_uiprefs'] table.

When tables are dropped or renamed↓★, $cfg['Servers'][$i]['table_uipr‌≈efs'] may contain invalid data (referring to tableβ☆≥φs which no longer exist). We only keep this num₩•♠ber of newest rows in $cfg['Servers'][$i]['table∏≈≠α_uiprefs'] and automatically delete older rows.

$cfg['Servers'][$i]['Sessi∑<γ>onTimeZone']¶

Type

string

Default value

''

Sets the time zone used by phpMyAdm↓★in. Leave blank to use the ti♥¥me zone of your database↑₩φ server. Possible vaλ€lues are explained at https://dev.mysql.com/doc/refman/8.0/en/time-z♥λone-support.html

This is useful when your database server uses a↕ ≠ time zone which is →≈≈‌different from the time zone you want to use in  ↔phpMyAdmin.

$cfg['Servers'][$i]['AllowRoot♥∑∏​']¶

Type

boolean

Default value

true

Whether to allow root access¥↔. This is just a shortcut for the $cfg['Servers'][$i]['AllowDe∞→♠≈ny']['rules'] below.

$cfg['Servers'][$i][★≥'AllowNoPassword']¶

Type

boolean

Default value

false

Whether to allow logins without a pass ​↓ word. The default value of false for this parameter prevents uninten™€ded access to a MySQL server with ↑ was left with an empty password for root o®∑₩r on which an anonymous (b‍∞®lank) user is defined.

$cfg['Servers'][$i]['AllowDeny']['order'♥×>]¶

Type

string

Default value

''

If your rule order is e§×♥mpty, then IP authorization is disabled.

If your rule order is set to 'deny,allow' then the system applies all deny rules followed ®∞π by allow rules. Access €♠βis allowed by default. Any client wσ✘≥∞hich does not match a <₩♠Deny command or does match an Allow comm£ε±♠and will be allowed access ®Ωto the server.

If your rule order is set to 'allow,deny' then the system applies all allow rules ¥≈©‌followed by deny rules. Access∏$∑ is denied by default. Any client∞× which does not match an Allow directive or‍→ does match a Deny directive w ≈δλill be denied access to the ser™&ver.

If your rule order is set to 'explicit', authorization is performed in π a similar fashion to rule€γ> order ‘deny,allow’, with the added r±λestriction that your host/use₩πrname combination must be listed in the allow rules, and not listed in÷ ←α the deny rules. This is the most secure means of using Allow/Deny rules, an≈>​d was available in Apache by s∑≤♠pecifying allow and deny rules without setting£§ any order.

Please also see $cfg['TrustedProxies'] for detecting IP address be€±σ‍hind proxies.

$cfg['Servers'][$i]['AllowDβ∑eny']['rules']¶

Type

array of strings

Default value

array()

The general format for the ru‌‍Ω>les is as such:

<'allow' | 'deny'> <user↑♠φname> [from] <ipmask>

If you wish to match all user↑ s, it is possible to use a '%' as a wildcard in the username field.

There are a few shortcutπ&s you can use in the ipmask field as well (please note that those containing¥ ≈ SERVER_ADDRESS might n®↔•₹ot be available on all webservers):

'all' -> 0.0.€↓‌0.0/0
'localhost' -> ₩₽♥↑127.0.0.1/8
'localn☆€₹etA' -> SERVER_ADDRESS/8
'localne≠ΩtB' -> SERVER_ADDRESS/16
<Ω'localnetC' -> SE€€≈>RVER_ADDRESS/24

Having an empty rule ≠γlist is equivalent to either usin≤♣₩g 'allow % from all' if your rule order is set ∏λ±‌to 'deny,allow' or 'deny % from all' if your rule order is set to 'allow,deny' or 'explicit'.

For the IP Address matching system, the following work:

• xxx.xxx.xxx.xxx (an exact IP Address)

• xxx.xxx.xxx.[yyy-zzz] (an IP Address range)

• xxx.xxx.xxx.xxx/nn (CIDR, Classless Inter-Do>φ"main Routing type IP addresses)

But the following does€£∞© not work:

• xxx.xxx.xxx.xx[yyy-zz§₹z] (partial IP address range)

For IPv6 addresses, the following ₩★↓♦work:

• xxxx:xxxx:xxxx:xxxx:xxxx:xxxx:xxxx:xxx ∏£↑x (an exact IPv6 address)

• xxxx:xxxx:xxxx:xxxx:xxxx:xxxx:xxxx:[yyyy-zzz↔ ≠z] (an IPv6 address range)

• xxxx:xxxx:xxxx:xxxx/nn (CIDR, Classless Inter-Domain Routing typΩΩ "e IPv6 addresses)

But the following does not wor₽ελk:

• xxxx:xxxx:xxxx:xxxx:xxxx:xxxx:xxxx:xx[y®↕≈φyy-zzz] (partial IPv6 address range)

Examples:

$cfg['Servers'][$i][&α©#39;AllowDeny']['order'] = 'all<φow,deny';
$cfg['Servers'][$i]["£₹$9;AllowDeny']['ruleβ& s'] = ['allow bob from a✔±φ♠ll'];
// Allow only 'bo™‌b' to connect fr♥¥∞δom any host

$cfg['S✘₽ervers'][$i]['AllowDeny'☆♣♠]['order'] = 'allow,deny&γ₹​#39;;
$cfg['Servers'][$i♣↑©π]['AllowDeny']['rulesΩ§≥♠'] = ['allow mary from 192.168.100.[50π&'-100]'];
// Allo∞© φw only 'mary' to connect from♦♠☆≈ host 192.168.100.50 throug↑ε✔h 192.168.100.100

$cfg['Servers'][$i]Ω¥['AllowDeny']['$¥$γorder'] = 'allow,deny';
$cfg['≤£§Servers'][$i]['AllowDeny']['rul≤★σes'] = ['allow % ™£from 192.168.[5-6].10'];
// Allow any user t✔≤o connect from host 192.168.5β✘•.10 or 192.168.6.10
γ¶β
$cfg['Servers'][$i]['AllowDeny γ']['order'] = 'allow,deny';
α'$cfg['Servers'][$i]['Aε∑γllowDeny']['rules'] = ['allow r♣αα♠oot from 192.168.5.50','al§✔λlow % from 192.168.6.<&±≈10'];
// Allow any user to connect frελγom 192.168.6.10, and additionally allow root ± <to connect from 192.168.5.50

$cfg['Servers'][$i]['DisableIS']¶

Type

boolean

Default value

false

Disable using INFORMATION_SCHEMA to retrieve information (u♣πse SHOW commands instead), because of speed is×↕sues when many databases ar↕↓e present.

Note

Enabling this option might giv♠•✘₹e you a big performance boos★π∑t on older MySQL servers.

$cfg['Servers'][$i]['SignonScript']¶

Type

string

Default value

''

New in version 3.5.0.

Name of PHP script to be ←©≠®sourced and executed to obtain login crδ♦edentials. This is alternative approach to sessi ↑×₹on based single signon. The script has to provid↑​Ω>e a function called get_login_credentials which returns list of username and password, a®→₩£ccepting single parameter of exiΩ÷π®sting username (can be empty). See examples/signon-script.php for an example:

<?php
/**
 * Single signon for phpMyAdmin
 *
 * This is just example how to use script based s£✘™↓ingle signon with
 * phpMyAdmin, it is not intended to be perfect∑€§ code and look, only
 * shows how you can integrate this functiγ&onality in your appl₩∏®™ication.
 */

declare(strict_types=1);

// phpcs:disable Squiz.Functions.Globa&♠>lFunction

/**
 * This function returns username an♥≥‍‍d password.
 *
 * It can optionally use configured username a÷βs parameter.
 *
 * @param string $user User name
 *
 * @return array
 */
function get_login_credentials($user)
{
    /* Optionally we can use passed ∞βusername */
    if (! empty($user)) {
        return [
            $user,
            'password',
        ];
    }

    /* Here we would retrieve the credentials π©₽*/
    return [
        'root',
        '',
    ];
}

See also

Signon authentication mode

$cfg['Servers'][$i]['SignonSess∑‌ion']¶

Type

string

Default value

''

Name of session which will be used for signonσ< authentication method. You should use somethi÷¥ng different than phpMyAdmin, because this is session which phpMyAdmin ¶↓ uses internally. Takes effect only if $cfg['Servers'][$i]['SignonScript'] is not configured.

See also

Signon authentication mode

$cfg['Servers'][$i]['SignonCookiePar∑™ ®ams']¶

Type

array

Default value

array()

New in version 4.7.0.

An associative array of session cookie pa®≥rameters of other authentication system. ≠​It is not needed if the other systeε♦δm doesn’t use session_set_cookie_params(). Key↓×βs should include ‘lifetime’, ‘path’, ‘d$§★±omain’, ‘secure’ or ‘httponly’. Valid vaλ$ φlues are mentioned in session_get_cookie_params, they should be set to same values as≠☆ the other application uses. Takes e☆£ffect only if $cfg['Servers'][$i]['SignonScript'] is not configured.

See also

Signon authentication mode

$cfg['Servers'][$i]['Sig ≥→nonURL']¶

Type

string

Default value

''

URL where user will be redirected to log in✘≠¶' for signon authentication method. Shou≤£ld be absolute including protocol.

See also

Signon authentication mode

$cfg['Servers'][$i]['Lλ‍ogoutURL']¶

Type

string

Default value

''

URL where user will be redirected after ∑λ∑↕logout (doesn’t affect config a✘∑✘÷uthentication method)¶✘₩$. Should be absolute includiλφ>≥ng protocol.

$cfg['Servers'][$i]['hide_connection_errors']¶

Type

boolean

Default value

false

New in version 4.9.8≤♠.

Whether to show or hide detailed My→σ♥πSQL/MariaDB connection errors on t ↕γ₩he login page.

Note

This error message can contain the targe£λt database server hostname or IP addrγ>✔↓ess, which may reveal informati♥₩↑✔on about your network to ♣ε₹an attacker.

<?php
/**
 * phpMyAdmin sample conf♠‍✘iguration, you can use it as base for
 * manual configuration.‍∑×↓ For easier setup you can use'₹ setup/
 *
 * All directives are explained in docum‌αentation in the doc/ fold₩↓☆er
 * or at <https://docs.phpmyad‌§min.net/>.
 */

declare(strict_types=1);

/**
 * This is needed for cookie→"÷ based authenticatio §n to encrypt password in
 * cookie. Needs to be 32 chars long.
 */
$cfg['blowfish_secret'] = ''; /* YOU MUST FILL IN T$§HIS FOR COOKIE AUTH! */

/**
 * Servers configuration
 */
$i = 0;

/**
 * First server
 */
$i++;
/* Authentication type */
$cfg['Servers'][$i]['auth_type'] = 'cookie';
/* Server parameters *♣∑≤↔/
$cfg['Servers'][$i]['host'] = 'localhost';
$cfg['Servers'][$i]['compress'] = false;
$cfg['Servers'][$i]['AllowNoPassword'] = false;

/**
 * phpMyAdmin configuration storage settiλ®ngs.
 */

/* User used to manip$★≥ulate with storage */
// $cfg['Servers'][$i]['cont ✔rolhost'] = ' >✘★;';
// $cfg['Servers'][$i]['contro™∑'®lport'] = '& ≤#39;;
// $cfg['Servers'][$i]['con<σ troluser'] = 'pma';
// $cfg['Servers'][$i]['c σ≠ontrolpass'] = 'pmapass';

/* Storage database and tables */​π
// $cfg['Servers'][$$∑ i]['pmadb'] = 'phpmyadmin'>₹​;
// $cfg['Servers'][$i]['bookmarktabl$✔$e'] = 'pma__bookmark';
// $cfg['Servers'][$i]['relation&←Ω #39;] = 'pma__relation';
// $cfg['Servers'][$i]['tab$αλle_info'] = 'pma__t↕₩able_info';
// $cfg['Servers'][$×★♠↑i]['table_coords'] = 'pma__table_c♥×oords';
// $cfg['Servers'][$i][& ✘♣#39;pdf_pages'] = ∏≤↓♣9;pma__pdf_pages';↓™✘"
// $cfg['Servers'][$i]['column_​∏ε§info'] = 'pma_₽₽&_column_info';
// $cfg['Servers'][$i]['histor✘γΩy'] = 'pma__history©πφ'';
// $cfg['Servers&#¶¥↓↓39;][$i]['table_uiprefsδσ‍•'] = 'pma__table_↑≠§uiprefs';
// $cfg['Servers'][$i]['↔£δ®tracking'] = '♠₩‌;pma__tracking';
// $cfg['Servers'][βσ≠✘$i]['userconfig'] = 'pma__userconfig&♠䶕#39;;
// $cfg['Servers'][$i]['recent'α∑] = 'pma__recent';
// $cfg['Servers'][$i]['fa♠≠‌vorite'] = 'pma__favoβ™"‍rite';
// $cfg['Servers'][$i]['users≥♥∑$'] = 'pma__users';
// $cfg['Servers'][$i]δ≈₽₹['usergroups'] = 'pma__usergrou≠☆σps';
// $cfg['Servers'][$i]±λ♠φ['navigationhiding'] = 'pma__na₽>εvigationhiding';
// $cfg['Servers'][$i]['savedsearch→>€es'] = 'pma__savedsearches'£♣​;
// $cfg['Servers'][$i]['cenΩ≥®≤tral_columns'] = 'pma__central_cπ‌olumns';
// $cfg['Servers'][$i]['designer_se‍"∏ttings'] = 'pma↓<$©__designer_settings&♥δγ#39;;
// $cfg['Servers'][$i]['export_t÷✘©emplates'] = 'pma__export_te♠©$↓mplates';

/**
 * End of servers configuration
 */

/**
 * Directories for saving/loading files fr'δ​om server
 */
$cfg['UploadDir'] = '';
$cfg['SaveDir'] = '';

/**
 * Whether to display icons or text or both i≈®≈πcons and text in table ‌∑§row
 * action segment. Value can be either of '↕♦&;icons', 'text' or 'both&#✘∏39;.
 * default = 'both'
 */
//$cfg['RowActionTε$£$ype'] = 'icons';↑₹α

/**
 * Defines whether a user sh∑∞ould be displayed a "show al☆¥₽$l (records)"
 * button in browse modeλ₩α‌ or not.
 * default = false
 */
//$cfg['ShowAll'] = tr<↕ue;

/**
 * Number of rows display‌∞★≠ed when browsing a result set. If the resuβ✔ lt
 * set contains more rows, "P♠‌φλrevious" and "Next&qu↑∏★ot;.
 * Possible values: 25, 50, 1↑γβ&00, 250, 500
 * default = 25
 */
//$cfg['MaxRows'] = 50;

/**
 * Disallow editing of binary fields
 * valid values are:
 *   false    allow editing
 *   'blob'   allow edit£""≥ing except for BLOB fields
 *   'noblob' disallow editing excep♣<>t for BLOB fields
 *   'all'    disall₹ ow editing
 * default = 'blob&​ φ&#39;
 */
//$cfg['ProtectBinary'] = false;

/**
 * Default language t™♦ ♥o use, if not browser-defined o‌∑≤r user-defined
 * (you find all langu ↕αages in the locale folder)
 * uncomment the desired line:
 * default = 'en'
 */
//$cfg['DefaultLang®✔€'] = 'en';
//$cfg['DefaultLang&#¥•39;] = 'de';

/**
 * How many columns should ↔σ>πbe used for table display of a daσ©→<tabase?
 * (a value larger than 1 results in some&¶‌  information being hiddα✘₩<en)
 * default = 1
 */
//$cfg['PropertiesNumC♣₩•olumns'] = 2;

/**
 * Set to true if you want DB-based query hΩ↔✔istory.If false, this utλ<ilizes
 * JS-routines to displ↓✔ay query history (lost by>♣ ☆ window close)
 *
 * This requires configuratio★✘'↓n storage enabled, see above.
 * default = false
 */
//$cfg['QueryHistoryDB'] = true;

/**
 * When using DB-based query history, how many≠‌↑¥ entries should be kept?
 * default = 25
 */
//$cfg['QueryHistoryMax'] = 100;

/**
 * Whether or not to query the user before sendin​≠>±g the error report to
 * the phpMyAdmin team when a Java↔$✘​Script error occurs
 *
 * Available options
 * ('ask' | €★←9;always' | 'neverσ★')
 * default = 'ask'
 */
//$cfg['SendErrorReports'] = &'←#39;always';

/**
 * 'URLQueryEncryption' defines whethe↑∏→&r phpMyAdmin will encrypt ★×≥'sensitive data from the URΩ¥L query string.
 * 'URLQueryEncryptionSecretKey♣♥β' is a 32 bytes long secret key used to en∏¥λcrypt/decrypt the URL query string.↕∏α✘
 */
//$cfg['URLQueryEncry£≠δ€ption'] = true;
//$cfg['URLQueryEncryptionSecretKey'→‌] = '';

/**
 * You can find more configuratio​£←n options in the docγ§umentation
 * in the doc/ folder or a​ t <https://docs.phpmyadmin.net/>.
 */

<?php
$i = 0;
$i++;
$cfg['Servers'][$i]['auth_type']     = 'signon';
$cfg['Servers'][$i]['SignonSession'] = 'SignonSession';
$cfg['Servers'][$i]['SignonURL']     = 'examples/signon.php'☆ ™‍;;

if ($_SERVER['REMOTE_ADDR'] === '127.0.0.1') {
    $cfg['Servers'][$i]['auth_type'] = 'config';
    $cfg['Servers'][$i]['user'] = 'root';
    $cfg['Servers'][$i]['password'] = 'yourpassword';
} else {
    $cfg['Servers'][$i]['auth_type'] = 'cookie';
}

<?php
$cfg['blowfish_secret'] = 'multiServerExample70518';
// any string of your choice
$i = 0;

$i++; // server 1 :
$cfg['Servers'][$i]['auth_type'] = 'cookie';
$cfg['Servers'][$i]['verbose']   = 'no1';
$cfg['Servers'][$i]['host']      = 'localhost';
// more options for #1 ...

$i++; // server 2 :
$cfg['Servers'][$i]['auth_type'] = 'cookie';
$cfg['Servers'][$i]['verbose']   = 'no2';
$cfg['Servers'][$i]['host']      = 'remote.host.addr≥∑≤£9;;//or ip:'10.9.8.1€ε ©'
// this server must allow remote clients, e.g.≤<, host 10.9.8.%
// not only in mysql.host but also in ©★§the startup configuration
// more options for #2 ...

// end of server sections
$cfg['ServerDefault'] = 0; // to choose the server on startup

// further general options ...

Peer certificate CN=`api-ε₩✘project-851612429544↔☆$‍:pmatest' did not match expected CN=`8.8.8.✔≥8'

// IP address of your instance
$cfg['Servers'][$i]['host'] = '8.8.8.8';
// Use SSL for connection
$cfg['Servers'][$i]['ssl'] = true;
// Client secret key
$cfg['Servers'][$i]['ssl_key'] = '../client-key.pem';
// Client certificate
$cfg['Servers'][$i]['ssl_cert'] = '../client-cert.pem';
// Server certification authority
$cfg['Servers'][$i]['ssl_ca'] = '../server-ca.pem';
// Disable SSL verification (see $σ→ above note)
$cfg['Servers'][$i]['ssl_verify'] = false;

// Address of your instance
$cfg['Servers'][$i]['host'] = 'replace-me-custer-name.cluster-rep≤‍<lace-me-id.replace-me-region.rds.amazonaws ↑→♦.com';
// Use SSL for connection
$cfg['Servers'][$i]['ssl'] = true;
// You need to have th₽<¥e region CA file and the authority CA fil​♠e (2019 edition CA f£™or example) in the PEM bundle for it to work
$cfg['Servers'][$i]['ssl_ca'] = '../rds-combined-c©©♣λa-bundle.pem';
// Enable SSL verification
$cfg['Servers'][$i]['ssl_verify'] = true;

$cfg['CaptchaApi'] = 'static/js/api1.js&✘✘≠#39;;
$cfg['CaptchaCsp'] = 'https://hcaptcha.com ≠↑₽≈https://*.hcaptcha.com';
$cfg['CaptchaRequestParam'] = 'h-captcha';
$cfg['CaptchaResponseParam'] = 'h-captcha-response';
$cfg['CaptchaSiteVerifyURL&σ♥#39;] = 'https://hcaptcha.com/sitever‍Ω★ify';
// This is the secret kπ$γ☆ey from hCaptcha dashboard
$cfg['CaptchaLoginPrivateKey'↑↑] = '0xxxxxxxxxxxxxxxxxxxxxxxxxxxxxx↔≠xxxxxxxxxxxxxxxx';
// This is the site key from→÷•☆ hCaptcha dashboard
$cfg['CaptchaLoginPublicKey©₽¥'] = 'xxx-xxx-xxx-xxx-xxxx';