Forums

[resolved] Putting It Together -- Starting with MySQL (5 posts)

  1. stevewilson
    Member
    Posted 1 year ago #

    I'm setting up a development machine under Windows Vista. I've downloaded Apache/PHP/MySQL and WP and both Apache and MySQL are "running". But it's a mystery how I get these elements to talk to each other.

    For example, I am reading that when I install WP I will need to know the name of the MySQL database reserved for my content. The WordPress Codex then says, under "Using the MySQL Client" that I can "create MySQL users and databases quickly by running MySQL from the shell". MySQL is running as a service so in a 'cmd' window I enter what it tells me to:

    $ mysql -u adminusername -p

    The reaction to that is:

    '$' is not recognized as an internal or external command

    There seems to be no end to this confusion. I now have no idea how to talk to MySQL. And find no guidance what to say once I get there. Can anyone advise?

  2. songdogtech
    Member
    Posted 1 year ago #

    It's easiest to use Apache Friends - XAMPP or Install PHP 5 Apache MySQL on Windows : WampServer for WIndows.

    But if you want to roll your own and stay with what you've already installed, use phpMyAdmin to work with database names, usernames and passwords for MySQL.

  3. stevewilson
    Member
    Posted 1 year ago #

    I went looking for phpMyAdmin, thinking it part of the PHP download, but find it is a separate application that the docs here tell me "is not the easiest to install in the world, but it is not impossibly hard". Uh-oh. Yet another layer of complexity.

    So, you're right. The objective is to produce a website, not sink ever deeper into this Apache/PHP/MySQL quagmire. I was unaware of XAMPP until after I had done these downloads and tried to find my way in the dark -- a pointless misappropriation of time. If roll your own could be said to confer any advantages, i.e., a better understanding of what's going on, one would think that by now there would be a detailed, plain language step-by-step instruction to take us every step of the way. I'd be happy to produce it if only I could figure out what I am supposed to do.

  4. songdogtech
    Member
    Posted 1 year ago #

  5. stevewilson
    Member
    Posted 1 year ago #

    Thanks much for providing those links. Even the link under "If you want to install it yourself" steers us to packaged installations, so it's time to uninstall everything and use XAMPP or whatever for a do over. XAMPP is mentioned most often in this forum and elsewhere, but this link...
    http://www.simplehelp.net/2008/07/18/how-to-install-wordpress-in-windows-vista/
    ...helpfully walks us through screenshots for BitNami. Anyone have any feel for BitNami vs. XAMPP?

    BitNami shows what perhaps any package will ask for -- "Hostname" -- and the screenshot shows entry of an IP address (192.168.0.102 in the example). For a development desktop machine not exposed to the web, can you advise what I should enter?

Topic Closed

This topic has been closed to new replies.

About this Topic