How To Install Your Own Web Server – Installing phpMyAdmin

June 12th, 2008 · 19 Comments

This is finally the last post of this series on How To Install Your Own Web Server. In my last post I’ve shown you how to setup a virtual host and now we’re going to use this to install phpMyAdmin.

Of course, the purpose of this tutorial is not really to install phpMyAdmin but it’s rather to show you how to host multiple websites sharing a single IP address. Most of the time you will make use of a web hosting control panel but it’s always good to know what’s going on behind the scenes if you ever need to do some troubleshooting.

PhpMyAdmin is an open source application developed in PHP (of course!) to help you manage your MySQL databases from your web browser.

How To Install phpMyAdmin

Note: I noticed that the “mysql” php extension is required by phpMyAdmin. To enable the mysql extension, edit c:\php\php.ini and uncomment the line that reads extension=php_mysql.dll. You will need to restart the Apache2 service for the change to take effect.

This is going to be quite easy and you could use this very same tutorial to install phpMyAdmin on any web hosting account.

  1. Get yourself a copy of phpMyAdmin at http://www.phpmyadmin.net. At the moment of this writing, the latest stable version is phpMyAdmin 2.11.6.
  2. Extract the content from the archive to your hard drive in C:\www\phpmyadmin (if you followed this tutorial).
  3. Create a folder named config into C:\www\phpmyadmin (ie.: C:\www\phpmyadmin\config).
    PhpMyAdmin Installation Tutorial
  4. Open your browser to http://phpmyadmin (again, you need to have followed this tutorial here). You will get an error message that says “Access denied for user ‘root’…”.
  5. Click on the setup script link at the top.
  6. Click on the Add button in the Servers section.
  7. Set the Authentication Type value to http.
  8. Click on the Add button at the bottom of the form.
  9. Click on the Save button from the Configuration section. This will create a file in C:\www\phpmyadmin\config named config.inc.php.
  10. Move C:\www\phpmyadmin\config\config.inc.php to C:\www\phpmyadmin\config.inc.php
  11. Delete the config directory created in c:\www\phpmyadmin
  12. Open your web browser to http://phpmyadmin. You will be prompted to enter a username and password.
  13. Enter the credentials you specified in this post. You should now be able to manage your MySQL database.
    phpmyadmin

Isn’t it the greatest day of your life? Okay maybe not.

But the point is, you now need to create a new virtual host each time you want to add a new website to your web server.

Click here to subscribe to our RSS feed or to receive email updates.

19 responses so far ↓

1. Response by : david on Jun 16, 2008 at 7:30 pm

This doesn’t work at all.

As with all other tutorials it ends up with me trying to go to localhost/phpmyadmin/ and getting a “website declined to show page”

you are leaving out some crucial step

how about the fact that we need to make manual changes to the config.inc.php file?

forget to mention that for any particular reason?

2. Response by : Stephane Brault on Jun 17, 2008 at 5:08 am

Hi David,

I’ve made a little video that shows you how I’ve done it:

http://www.youtube.com/watch?v=doMnOzLLY9E

Hope this helps.

The only difference in the video is that I extract files to c:\tmp before moving them to c:\www\phpmyadmin

Of course this is just a quick and dirty guide to get phpMyAdmin working. This is a tutorial to help you setup your own web server and not an advanced course on phpMyAdmin. See related posts for the previous steps.

For more info on phpMyAdmin configuration settings, visit http://www.phpmyadmin.net

Best regards,
Stephane

3. Response by : Stephane Brault on Jun 17, 2008 at 5:51 am

I realize that the YouTube video format is kinda small so here’s the video in 640×480:

http://www.thewebhostinghero.com/videos/how-to-install-phpmyadmin.avi

4. Response by : Zak on Jun 17, 2008 at 7:24 am

it worked for me

5. Response by : damion on Jul 11, 2008 at 4:11 pm

well i cant even fucking run the god damn setup!!!

6. Response by : Stephane Brault on Jul 11, 2008 at 4:17 pm

Damion I’d be happy to help you out if you could give more details of what went wrong.

7. Response by : Noobie on Jul 13, 2008 at 11:31 pm

Just a small sidenote for other noobs. In step nine, make sure the config directory you create has writable permissions or the SAVE button will be greyed out and unusable.

8. Response by : Stephane Brault on Jul 14, 2008 at 8:35 am

Thank you for the comment Noobie, this is absolutely true. By default, the folder was writeable on Windows so I forgot to mention it.

9. Response by : abhinav on Sep 3, 2008 at 9:13 am

hey man i am getting this error on my link bar i donnot know how to solve it

“http://localhost/error.php?lang=en&dir=ltr&type=Error&error=Cannot+load+
[a%40http%3A%2F%2Fphp.net%2Fmysql%40Documentation]
[em]mysql[%2Fem][%2Fa]+extension.+Please+check+your+PHP+configuration.+-
+[a%40.%2FDocumentation.html%23faqmysql%40documentation]Documentation[%2Fa]”

and this error also

“Cannot load mysql extension. Please check your PHP configuration. – Documentation”

kindly guide me up to solve this error….please i am waiting for this…..

10. Response by : Stephane Brault on Sep 3, 2008 at 9:20 am

Are you running Apache on Linux or Windows?

11. Response by : abhinav on Sep 3, 2008 at 9:58 am

apache on windows server 2003

12. Response by : Stephane Brault on Sep 3, 2008 at 10:37 am

Try these:

1. Make sure the mysql extension is loaded in php.ini

2. Use a phpinfo() page to make sure the MySQL extension is loaded.

3. Copy c:\program files\mysql\mysql server 5.0\bin\libmysql.dll to c:\windows\system32

Don’t forget to restart Apache after every changes.

13. Response by : abhinav on Sep 3, 2008 at 11:17 am

after this even its not working dear…..beside this every thing is working fine Apache, PHP…. even MySQL too working fine but the phpmyadmin is not working…..[:(]

14. Response by : abhinav on Sep 3, 2008 at 11:57 am

hey brother i got it solved………..but thanks for the suggestions….thanks a lot [:)]

15. Response by : Stephane Brault on Sep 3, 2008 at 12:13 pm

How did you finally solve it?

16. Response by : Rakotoniaina Andre on Sep 19, 2008 at 10:41 am

Thank you for your help.
The “save” button in configure section in phpmyadmin setup is deactivated and i could not save any change i made. Could you post a solution please? thanks in advance

17. Response by : Stephane Brault on Sep 19, 2008 at 1:27 pm

Rakotoniaina Andre,

Make sure your config directory exists and is writeable (chmod 0777).

18. Response by : missingchord on Dec 10, 2009 at 9:34 am

i have a the same problem like abhinav encountered
how can i fix this? can somebody help me?

19. Response by : Satheesh on Jan 22, 2010 at 1:15 am

Missing chord,

In the “php.ini” file in the php directory there should be an entry for “extension_dir”, remove the “;” infront of this line.

Also, check whether there are any “;” entries prior to the line having “mysql.so”, if so remove it too and restart the Apache server to get this working.

You can also try installing using the setup GUI, and check if its any better than ur current method.

Leave a Comment




Posted in Apache · Misc · MySQL · PHP · Tutorials · Windows Server | 19 Comments

 
 
 

Tutorials by Category

 
 
 
 

Recent Comments