Best practice for configuring PHPMyAdmin with IIS?

Posted on 2008-11-06
Last Modified: 2013-12-24
Attempting to use PHPMyAdmin with a MySQL database on IIS. I have the server setup with php and can see the PHPMyAdmin page, however unlike good ol' WAMP looks like there is a lot to do here. I would like to mock what WAMP does if at all possible.

So I am looking for an "easy" best practice as configure PHPMyAdmin.

I am going to be authoring ColdFusion pages with the MySQL database and would like to use PHPMyAdmin or something similar to manage the database side.

Thanks ahead of time for your help.
Question by:fpstech
    LVL 9

    Expert Comment

    by:Andrew Maurer
    Why not just use MySQL administrator like a real man? (or woman) =p

    JK about the real man/woman part.. but are you already using PHP and ColdFusion on the same server? If not, why not just admin your database with the administrator tools from

    Author Comment

    Yeah I have a MySQL administrator but it doesn't seem to let me see the tables and all like PHPMyAdmin does. Since I have worked with PHPMyAdmin and know it a little I was just trying to avoid more reading. That and there are several on the net falling over themselves to say that PHPMyAdmin is the greatest software in the world.

    I did find a tool by Navicat that lets me see the data and hopefully will allow me to import CSVs etc.

    So maybe I am being "soft" and I should ask questions concerning MySQL administrator...thoughts?
    LVL 7

    Accepted Solution

    I use HeidiSQL 3, ( it does all that stuff, it's free too.

    I find it easier to use for manipulating dbs and tables and doing queries although mysqladmin is better for monitoring and backup.


    Author Closing Comment

    Works for me thanks...this is what I was looking is key

    Featured Post

    Why You Should Analyze Threat Actor TTPs

    After years of analyzing threat actor behavior, it’s become clear that at any given time there are specific tactics, techniques, and procedures (TTPs) that are particularly prevalent. By analyzing and understanding these TTPs, you can dramatically enhance your security program.

    Join & Write a Comment

    If you don't have the right permissions set for your WordPress location in IIS, you won't be able to perform automatic updates. Here's how to fix the problem.
    Nothing in an HTTP request can be trusted, including HTTP headers and form data.  A form token is a tool that can be used to guard against request forgeries (CSRF).  This article shows an improved approach to form tokens, making it more difficult to…
    The viewer will learn how to look for a specific file type in a local or remote server directory using PHP.
    The viewer will learn how to create a basic form using some HTML5 and PHP for later processing. Set up your basic HTML file. Open your form tag and set the method and action attributes.: (CODE) Set up your first few inputs one for the name and …

    745 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    16 Experts available now in Live!

    Get 1:1 Help Now