Configuring phpMyAdmin

Posted on October 17, 2008
Filed Under PHP, SQL |

Installing phpMyAdmin is simple as extracting to the www folder, but I install it in a different way, I extract phpMyAdmin in Program Files folder, and configure Apache to map /myadmin to the extracted folder, and make that only accessible by the local machine for security purpose.

1
2
3
4
5
6
7
8
9

Alias /myadmin/ "C:/Program Files/phpMyAdmin-2.11.9.2/"
 
<Directory "C:/Program Files/phpMyAdmin-3.0.0">
    Options Indexes MultiViews
    AllowOverride None
    Order deny,allow
    Deny from all
    Allow from 127.0.0.1
</Directory>

In the phpMyAdmin copy the config.sample.inc.php to config.inc.php and change the first server configuration to authenticate via configuration file so that I don’t have to enter the user name and password again and again and hide the mysql database as I don’t really need access to that.

1
2
3
4
5
6
7
8

$cfg['Servers'][$i]['auth_type'] = 'config';
$cfg['Servers'][$i]['host'] = 'localhost';
$cfg['Servers'][$i]['connect_type'] = 'tcp';
$cfg['Servers'][$i]['compress'] = false;
$cfg['Servers'][$i]['user'] = "root";
$cfg['Servers'][$i]['password'] = "xxxxxx";
$cfg['Servers'][$i]['hide_db']  = "mysql";
$cfg['Servers'][$i]['extension'] = 'mysql';

Comments

Leave a Reply




  • About

    This is an area on your website where you can add text. This will serve as an informative location on your website, where you can talk about your site.