How to Install phpMyAdmin on Windows ?
phpMyAdmin lets you control you MySQL database from a web browser.
To install PHPMyAdmin, you need to extract the .zip file to the C:\SimplePHP folder and rename the phpmyadmin folder as C:\SimplePHP\phpMyAdmin. After, open the config.inc.php file and find the line starting with $cfg['PmaAbsoluteUri'] and change it for :
$cfg['PmaAbsoluteUri'] = ‘http://localhost/mysql/’;
phpMyAdmin can also try to auto-detect the proper value if this directive is left as it is (blank) and this line is changed to ‘TRUE’…
$cfg['PmaAbsoluteUri_DisableWarning'] = FALSE;
Next, you need to locate the series of lines starting with $cfg['Servers'][$i][] and make sure the four following lines are identical :
$cfg['Servers'][$i]['host'] = ‘localhost’;
$cfg['Servers'][$i]['connect_type'] = ‘tcp’;
$cfg['Servers'][$i]['auth_type'] = ‘config’;
$cfg['Servers'][$i]['user'] = ‘root’;
Since we installed PHPMyAdmin out of the C:\SimplePHP\root folder which is the web server’s root folder, we will use a trick to make sure PHPMyAdmin is found by the web server.
To achieve this feat, you will once again need to open the httpd.conf file and insert the following code in the Aliases section (located at about two thirds of the beginning of the file) :
Alias /mysql/ “C:/SimplePHP/phpMyAdmin/”
AllowOverride None
Order deny,allow
Deny from all
Allow from 127.0.0.1
This enables us to access PHPMyAdmin by typing the below address in our browser (the “/” is very important) :
http://localhost/mysql/
You are done!
Related posts:
- How to Do it – Install MySQL Database Server on Windows I am writing few simple steps to do it . just fallow them and you will handle it .Download the latest stable Windows version, which includes a Windows Installer, of...
- How to Install the Apache Web Server on Windows ? It is my personal experience , That easiest way to Install the Apache Web Server on Windows have to fallow the procedure mentioned below. just fallow it and enjoy having...
- Do it – Install the PHP Engine on Windows PC Steps to Install the PHP Engine on your Windows PC. fallow the fallowing procedure for it. 1. Typical Setup. 2. On the next window, click the radio button “Advanced”, and...
- Getting PHP5 to work with mySQL Unfortunately PHP5 removed built-in support for mySQL. So you´ll need to copy some files by hand. open the folder you unzipped your PHP to. Copy the libmysql.dll file (should be...
- Top Windows Desktop Security Software The computer has ceased to be a mere tool in our lives; it is more of an integral part of our day-to-day life. Hence taking care of our desktops is...