installed WAMP, but I had IIS7 already installed. Help

Need help installing PHP, configuring a script, or configuring a server? Then come on in and post your questions! We'll try to help the best we can!

Moderator: General Moderators

Post Reply
User avatar
ChadAustinDesign
Forum Newbie
Posts: 9
Joined: Wed Oct 06, 2010 7:51 pm
Location: Hickory, NC, USA

installed WAMP, but I had IIS7 already installed. Help

Post by ChadAustinDesign »

Hi Gurus,

While I've got 15 years of front-end development, my backend skills are a little low. Please be specific, yet gentle, with me on any suggestions or solutions... mainly because my parents were related before they got married and, as a result, I have a lot of coping issues :)

I installed IIS7 over a year and never used it. I'm taking a Lynda.com course on php and it recommended I install WAMP since I'm using a PC. I had forgetten about IIS7 and did not uninstall prior to the WAMP install.

The install went fine- at least to my inexperienced eyes.

However, when I typed http://localhost/ in my Firefox Browser, I got the IIS7 home page, instead of the "Your website here" php page I was looking for.

So:
Do I uninstall IIS7? Both? then reinstall WAMP?

Or is there someway to fix localhost to show my php pages, and not the IIS stuff?

Again, please dumb it down for me! :) Thanks in advance!
Doug G
Forum Contributor
Posts: 282
Joined: Sun Sep 09, 2007 6:27 pm

Re: installed WAMP, but I had IIS7 already installed. Help

Post by Doug G »

You can simply disable the IIS www service if you don't want to use it for anything else. Or you can edit your httpd.conf and run apache http on a different port than port 80 which IIS will be using.
User avatar
ChadAustinDesign
Forum Newbie
Posts: 9
Joined: Wed Oct 06, 2010 7:51 pm
Location: Hickory, NC, USA

Re: installed WAMP, but I had IIS7 already installed. Help

Post by ChadAustinDesign »

Awesome, Doug, thank you- that worked! I shut down the features of IIS7 and localhost started working (I'm assumming) properly.

Now I can see WampServer's home page, which shows:

Server Configuration
Apache version: 2.2.1
Php version: 5.3.0
Loaded extensions (40 different extentions listed)
MySQL version: 5.1.36

Tools
phpinfo()
phpmyadmin

Your Aliases
phpmyadmin

Now, the Tool, phpinfo() works fine. however, the "phpmyadmin" gives an Error that reads:
MySQL said:
#1045 - Access denied for user 'root'@'localhost' (using password: NO)
phpMyAdmin tried to connect to the MySQL server, and the server rejected the connection. You should check the host, username and password in your configuration and make sure that they correspond to the information given by the administrator of the MySQL server.
I did a search with in the whole forum, as a well as a focused effort within the installation section & DB section. It seems that a lot of the answers were over my head (not to mention out-of-date). I understand what a DLL is, as well as a CONF file and even an INI file... but I don't understand the lingo or contents enough to be of much use. :)

Any more insight Doug? Or anyone? Thanks folks- love the forum.
User avatar
ChadAustinDesign
Forum Newbie
Posts: 9
Joined: Wed Oct 06, 2010 7:51 pm
Location: Hickory, NC, USA

Re: Learning as I go hopping down the Php trail.

Post by ChadAustinDesign »

OK... I sort of got the ball rolling on my own.

I'd like to share what I found during this WAMP introduction- and what I'm finding out- for the other newbies on here like myself. The biggest reason I'm posting this- despite seeing similar posts- is because I want to explain from a Front End Developers' Point of View. I've been around backend Dev for probably 12 years or more, but it doesn't mean I'm worth a d@mn at it. :)

The "#1045 - Access denied for user 'root'@'localhost' (using password: NO) " ERROR was fixed- for me- by going to this site:

http://downloads.jlbn.net/ResetMysql.html and downloading a little zipped file called "ResetMysql".

The Text Link for this ResetMysql file is located toward the bottom of the page and easy to miss beacuse of all the intrusive "Adds by Google". This is an open source site, but they will appreciate any donations. For the record, I donated.

One you download the zipped file, look inside and read the "Read Me First" txt file. Basically, you're going shut down WAMP in your service tray, then you're going to locate several specific files on your C Drive within the WAMP folder, save copies of them (for a "just in case"), and finally replace these located files with the ones included in the zipped file.

When I restarted WAMP, I was finally able to see phpMyAdmin!

However, I have 2 new "alerts" on my phpMyAdmin that will now consume my waking thoughts. They are as follows (with the reasons of consuming thoughts):
The additional features for working with linked tables have been deactivated. To find out why click here.
Great. I have no idea why features are going to have to be disabled when I finally got the silly thing working... I followed the "To find out why click here" link and didn't understand any of it. :) Will look in to this later.

The second and final alert is as follows:
Your configuration file contains settings (root with no password) that correspond to the default MySQL privileged account. Your MySQL server is running with this default, is open to intrusion, and you really should fix this security hole by setting a password for user '.root'.
Now, this one annoys me. AfterI originally installed WAMP, I used the MySQL Console to create a password (for you newbies, it's very similar to the Windows' Command Prompt- or DOS prompt). And, according to the MySQL Console, the password took. However, you can see by following this thread from the beginning, even though I thought I created a password, I couldn't access phpMyAdmin.

So does this mean I will have more Password issues with MySQL and phpMyAdmin if I create another? Stay tuned to this thread to see if our hero is dashed to bits on the rocks below. :D
User avatar
ChadAustinDesign
Forum Newbie
Posts: 9
Joined: Wed Oct 06, 2010 7:51 pm
Location: Hickory, NC, USA

Re: WAMP should be renamed WASP, because it will sting you.

Post by ChadAustinDesign »

Well, the short answer to my last question: "So does this mean I will have more Password issues with MySQL and phpMyAdmin if I create another?" is a resounding YES!

Since I could now see phpMyAdmin, I started exploring the "Privileges" Tab. I clicked the "edit" icon for "root@localhost" and tried assigning a password...

Worth noting... a subsection in the "Privileges" Tab is called "Change Password". you have either the option of chosing (via radio button) "no password" WHICH WASN'T EVEN SELECTED (it should have been because by default there was no password selected!) or "Password".. which, for some idiotic reason, was selected.... as if to prompt a password change. Go figure. :dubious:

So I tried Changing the password... as soon as I hit save... (another faux pas... instead of "Save" the button reads "Go") phpMyAdmin QUIT WORKING AGAIN! %^&$. How moronic is this? More mySQL errors.

I even tried the ResetMysql stuff again. Nope. Not this time.

So Uninstalled the silly thing (WAMP). Restarted the PC... Re-installed WAMP... did not create a password... started WAMP... and Presto! Everything works.

However, now I'm getting those same two previouely noted alerts.

Experience in design and development tells me to create a password (I'm assuming for mySQL) but my experience over the last several days says I can't.

Is there anyone out there that can explain what is going on?

On a brighter note... my Merlot is very, very good this evening. I wish everyone out there who is reading this the same feeling I currently hold :)
Doug G
Forum Contributor
Posts: 282
Joined: Sun Sep 09, 2007 6:27 pm

Re: installed WAMP, but I had IIS7 already installed. Help

Post by Doug G »

You might spend time with the mysql command line program and the mysql manual. Permissions can be complex on a database. Once you learn how to manipulate the permissions using mysql itself phpmyadmin will seem very straightforward.
User avatar
ChadAustinDesign
Forum Newbie
Posts: 9
Joined: Wed Oct 06, 2010 7:51 pm
Location: Hickory, NC, USA

Re: installed WAMP, but I had IIS7 already installed. Help

Post by ChadAustinDesign »

Hi Doug! Fancy meeting you here again! :) Thanks for your contributing feedback!!!!

I guess you're referring to the MySQL Console when you speak of the "mysql command line program"?

And you're defintely correct: I should read the manual... and I usually do. But I get so distracted so easily when I approach the Bell Curve that I... hey... look at that butterfly. :lol:

Seriously, I will give it a read through tomorrow.

Still, the immediate lingering questions (for me) still remain:

• Why did the PhpMyAdmin not function logically (in my inexperienced SQL eyes) when I tried to add a password? Surely someone else has epxerienced this before me and can offer an explanation that my silly butt can understand! ha
• Since I reinstalled WAMP and everything is working without a MySQL password, should I worry about development on my own machine?

Inquiring minds want to know!

I saw "Social Network" tonight. Mark Zuckerburg is my new hero because he's rich. Stupid money. :)
User avatar
ChadAustinDesign
Forum Newbie
Posts: 9
Joined: Wed Oct 06, 2010 7:51 pm
Location: Hickory, NC, USA

Re: Back to Square one

Post by ChadAustinDesign »

As the saga continues:

So I read the the manuals for PhpMyAdmin & MySql. I couldn't follow them for anything. 8O

I decided to just go back and continue trying different options.

The first thing I tried within phpMyAdmin, was to go to the Privileges tab, and to create passwords for the two listed users (see image below).

Image

The first User "root" at host 143.0.5.6 (not my real IP... I did change that- ha) was succesfully edited and a new password was created... even got the notification saying it was changed.

So then I go to the next User "root" with host "localhost" and succesfully edited it, too, with the same password. Again, I received the notification it had been changed.

So there you go... the passwords had been created. I had seen where someone else did this same thing with positive results. I was pretty confident... but for nothing.

When I went back to the "homepage" of phpMyAdmin, this is what I saw. Again (I had tried creating passwords before).

Image

So now I humbly beg: can someone suggest to me a solution that would be applicable to my situation?
User avatar
ChadAustinDesign
Forum Newbie
Posts: 9
Joined: Wed Oct 06, 2010 7:51 pm
Location: Hickory, NC, USA

Re:

Post by ChadAustinDesign »

Oh, one more thing... when I now go to the mySQL console and put in my newly created password, it accepts it.

But I still can't get into phpMyAdmin.
User avatar
ChadAustinDesign
Forum Newbie
Posts: 9
Joined: Wed Oct 06, 2010 7:51 pm
Location: Hickory, NC, USA

Re: Wonders never cease. the config.inc.php file was not upd

Post by ChadAustinDesign »

OK... for whatever reason, when I edited the passwords using phpMyAdmin, it didn't update the config.inc.php file, located in C:\wamp\apps.

Once I added my password here, saved it... I went back to phpMyAdmin's home page and everything looks dandy.

Image

I sincerely hopes this helps any newbies like myself who get frustrated at the mere thought of Error messages. :)
Doug G
Forum Contributor
Posts: 282
Joined: Sun Sep 09, 2007 6:27 pm

Re: installed WAMP, but I had IIS7 already installed. Help

Post by Doug G »

I'm glad you got it fixed.
OK... for whatever reason, when I edited the passwords using phpMyAdmin, it didn't update the config.inc.php file, located in C:\wamp\apps.
That behaviour is by design.

IMHO you should always have a decent password on all database users. Ask Microsoft, a few years ago there was a world-wide virus attack that was made worse because many ms-sql servers were shipped with a default sa user without a password.
User avatar
ChadAustinDesign
Forum Newbie
Posts: 9
Joined: Wed Oct 06, 2010 7:51 pm
Location: Hickory, NC, USA

Re: installed WAMP, but I had IIS7 already installed. Help

Post by ChadAustinDesign »

Thanks for your insight, Doug. I certainly appreciate it. 85% of my 15 years has been geared towards Front End and Multimedia... Servers and Backend are the new battle for me! :)
Post Reply