SitePoint Sponsor

User Tag List

Results 1 to 2 of 2
  1. #1
    SitePoint Member
    Join Date
    Jan 2012
    Posts
    1
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Build Your Own Database Driven Web Site Using PHP & MySQL 4th Edition

    In the book it refers to installation of WAMPSERVER 2.0, the latest version is 2.2. Generally the installation process is the same for both. Once installed the "homepage" is slightly different with a couple more extensions in the newer version. In the post installation set-up tasks it suggests to assign a root password using mysqladmin, however I do not see how to get to that. I can see mysqladmin.exe in a bin folder inside the mysql folder in wamp, but this does not open as per the instruction. I can see how to get into the mysql (not mysqladmin) command prompt, but this doesnt allow me to change a password or assign a password there either. It also tells me to use mysqladmin -u root status and hit enter but this does not work in the mysql comand window. the instructions do not seem to match the program. I can't see that there should be such a dramatic change, so can someone advise me as to how to get thru this issue?

  2. #2
    SitePoint Member
    Join Date
    Jan 2012
    Posts
    3
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    I'm not 100% on this as I did the individual installs, however, I think that when you do a WAMP install rather than doing individual installs for Apache, MySQL and PHP it assigns the default mysqladmin password as "root" rather than leaving it blank.

    Try doing the following;
    Run command prompt from the windows start menu (search cmd or go to run and type in "cmd") and type in mysqladmin -u root -p status and when prompted for a password type in root. If MySQL is installed and running correctly it should return something along the lines of;
    Uptime: 102261 Threads: 1 Questions: 1 Slow queries: 0 Opens: 15
    Flush tables: 1 Open tables: 0 Queries per second avg: 0.0
    After checking that, you can then change the default password by typing mysqladmin -u root -p password "newpassword", where "new password" is your desired password. You will be prompted to put in the current password, which as I said, I believe is root.

    You can then try the first command again this time using you new password to ensure it has changed. Again, it should return something like the quote above.

    I'm pretty new to this so I may be wrong but give it a shot, let us know what happens.
    Hope this helps.
    Xero


Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •