Sunday, April 4, 2010

APPServ 2.6 + Window 7

Last week have been a googling week for me. 2 of the programmer are upgrading thier workstation into window 7. And php 6 finally hit the PHPer. However i had a few problem with APPServ 2.6 in window 7.

The first problem is unable to do connection to the localhost aka 127.0.0.1. And to solve this problem what i did is go to C:\Windows\System32\drivers\etc\hosts and uncomment the part where "localhost 127.0.0.1". I'm not really sure why microsoft put the default as comment. I think for some security reason.

The second problem is unable to do the connection to mySQL. Somehow the old authentication method does not work with the latest MySQl version.

  • Apache 2.2.8
  • PHP 6.0.0-dev
  • MySQL 6.0.4-alpha
  • phpMyAdmin-2.10.3

  • It something to do with the hashing way to keep the password security. As what i get from googling around the old MySQl version 4.x.x and version 5.x.x have a different bit of hashing. Could be something else they add on this new version.

    How to solve this problem :

    1. go to http://localhost/phpinfo.php
    2. Look under Apache enviroment, Look for SERVER_NAME. By default it will put the email address you filled in when u do the installation.
    3. Use the value in SERVER_NAME to log in into phpmyadmin. And left the password field empty.

    However another problem that i had is the privilages! even with the admin access level you can't even create a new database.

    So what i did is create a new user through MySQL cmd line, and grant all privilages to that account. It solve the problem for now!

    The findings that i get while solving this is :

    1. Editing the password using phpmyadmin will result the same error (unable to log in into mysql through phpmyadmin). So remove all the password or add them through cmd line. My theory is coz the phpmyadmin client (build on php5) have a different authentication method than the one this newest MySQL have, plus this version (6.0.4) are still on alpha stage.