Using AppServ for local WP install

  • I don’t know if anyone else has tried using AppServ (package that automagically installs Apache 1.3.x, PHP 4.3.4, mySQL 4.0.x) for Windows, but here’s a tip if you do.
    AppServ sets all of the above up for you. It asks for a username/password for mysql, you finish up, boom, you’re up and running. Until, if you’re like me, you get various messages when you try to install WP (or any other PHP app that uses mysql) that give you the idea that you’re not connecting to your database (even though it’s running) due to incorrect username/password.
    In the WP config file, where you dutifully entered the uname/pw you chose when installing AppServ? Try changing those to username: root, password: ‘ ‘ .
    Bam, everything started working. I don’t know why. My my.ini for mysql gives the uname/pass that I chose initially. I’m sure this must be horribly insecure and whatnot, but I thought I’d pass it along if anyone has been having aggravation with this.
    Of course, if anyone knows why my ‘real’ uname/password aren’t working, please let me know!
    ??

Viewing 6 replies - 1 through 6 (of 6 total)
  • Thread Starter Cena (a11n)

    (@cena)

    Well, I used phpmyadmin, of course. I used it to create the wp db, etc. But mysql would only accept the previously mentioned username/password. It’s a mystery to me.

    Sushubh

    (@sushubh)

    u can define a new user/password to a database. it works.
    it should ask u to restart the sql server…
    i had some problems with a forum installation but WP did fine.

    Uhh, I know this post is a little old but… You should always change that admin password to something else using whatever program you find appropriate (I use the command line myself). This is just so that if a newbie comes strolling in and does a search, or browses in to this post like I did this info will help avoid a potential problem. If I had your IP and you were online and you didn’t change this password, I could do all kinds of neat things to your databases. You especially wouldn’t want this if you kept confidential data such as finances and such on there.

    Thread Starter Cena (a11n)

    (@cena)

    Guys, I appreciate the concern and all, but I *am* aware of these issues. My problem (and point) was that no matter what I did, mySQL would not take any uname/password except root (using the AppServ installer). Yes, I know how to use phpmyadmin, and tried repeatedly to change the u/p. I turned the comp off, flushed the caches, etc. Nothing seemed to work. Hell, nothing *did* work. Obviously something wasn’t configured correctly. Now I’m just using a standard WAMP install, without the ‘help’ from AppServ.

    strange, as i have a forum (IPB) and 3 local test installations of WP running on my local server using a similar kinda installation…
    I installed my PHP+mySQL+Apache usin’ a file named: phpdev423.exe (10,447 KBs)
    Now i cant recall what it actually is…

    Thread Starter Cena (a11n)

    (@cena)

    Cool, I’ll try it out!

Viewing 6 replies - 1 through 6 (of 6 total)
  • The topic ‘Using AppServ for local WP install’ is closed to new replies.