Thursday, August 21, 2014
Installing phpmyadmin for Developers
Before installing phpMyAdmin, you should have already installed a webserver. Apache or IIS are solid options.
Step 1:
Install php with MySQL support
If you haven't done this already, you can download phpMyAdmin here.
Step 2:
If your webserver is Apache, first unpack file like so: phpMyAdmin-x.y.z.zip under C:\apache\htdocs\
Rename the directory.
Again, if you were using Apache, you might do this: C:\apache\htdocs\phpMyAdmin-x.y.z to C:\apache\htdocs\phpMyAdmin
Step 3: Rename the config
Apache example: C:\apache\htdocs\phpMyAdmin\config.sample.inc.php to 'config.inc.php'
For a single-user (root or trusted) environment, update config.inc.php as:
$cfg['Server'][$i]['auth_type'] ='config';
$cfg['Server'][$i]['user'] = 'root';
$cfg['Server'][$i]['password'] = 'root-password';
$cfg['Servers'][$i]['host'] = 'localhost';
$cfg['Servers'][$i]['connect_type'] = 'tcp';
$cfg['Servers'][$i]['compress'] = false;
$cfg['Servers'][$i]['AllowNoPassword'] = true;
Step 4 :
Access myphpadmin
If access is performed from localhost, use -> http://localhost/phpMyAdmin/
If access is not performed from localhost, use -> http://[URL of the website]/phpMyAdmin/
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment