Can I directly access a database or table pages? ΒΆ
Yes. Out of the box, you can use a URL like http://server/phpMyAdmin/index.php?server=X&db=database&table=table&target=script
. For server
you can use the server number which refers to the numeric host index (from $i
) in config.inc.php
. The table and script parts are optional.
If you want a URL like http://server/phpMyAdmin/database[/table][/script]
, you need to do some additional configuration. The following lines apply only for the Apache web server. First, make sure that you have enabled some features within the Apache global configuration. You need Options SymLinksIfOwnerMatch
and AllowOverride FileInfo
enabled for directory where phpMyAdmin is installed and you need mod_rewrite to be enabled. Then you just need to create the following .htaccess file in root folder of phpMyAdmin installation (don't forget to change directory name inside of it):
RewriteEngine On RewriteBase /path_to_phpMyAdmin RewriteRule ^([a-zA-Z0-9_]+)/([a-zA-Z0-9_]+)/([a-z_]+\.php)$ index.php?db=$1&table=$2&target=$3 [R] RewriteRule ^([a-zA-Z0-9_]+)/([a-z_]+\.php)$ index.php?db=$1&target=$2 [R] RewriteRule ^([a-zA-Z0-9_]+)/([a-zA-Z0-9_]+)$ index.php?db=$1&table=$2 [R] RewriteRule ^([a-zA-Z0-9_]+)$ index.php?db=$1 [R]
Changed in version 5.1.0: Support for using the target
parameter was removed in phpMyAdmin 5.1.0. Use the route
parameter instead.