[Ahmedn1]

I'm new to PHP so I'm learning to use it
I installed WAMP because it has Apache, PHP and mysql in it

the problems are as follows:

1- before installing WAMP I had already MySQL 5.5.9 installed as I was using it in .NET programming
I was using the server databases using SQLYog and it was going very well
when I installed WAMP its icon is Yellow
So, I understood that there are missing services
I checked the Apache and it is running
the Mysql service is not running (which I discovered lately that it was 5.5.8 in the latest version of WAMP and also XAMPP)
I tried a lot but no use
I tried to uninstall the 5.5.9 and re-install WAMP but no use
so I installed back the 5.5.9 version

2- When I try to open 'localhost' from the WAMP tray it doesn't load
it tries to load the page but it can't reach it
"Unable to connect"

3- of course because of the mysql thing I cannot use phpMyAdmin

[codeprada]

I would believe your problem is more than service is trying to use a port. No too programs can use the same port at the same time. Check your Services and disable the ones you're not using and enable the ones you want to use. For MySQL you'll see a service with the name of MySQL by default or if you specified to change it's name you'll find it under that name.

I've got MySQL server and WAMPSERVER on my computer and I haven't had any problems. Even used the two at the same time so it's quite possible to have to the two.

This post has been edited by codeprada: 04 July 2011 - 07:04 AM

[Atli]

Like codeprada said, no two programs can use the same port at the same time, and by default MySQL will attempt to use port 3306. If you want to run both servers at the same time, and you did not specify another port during setup (if that's even possible with WAMPP), you will need to edit the my.ini config file for either of them and edit the port directive.

By default it will be set to port=3306, which you will have to change to another open port. Note that there are usually two such directives, one under [client] and another under [mysqld]. The latter is what really matters, but generally they should match.

Also, you'll have to make sure you applications are pointing to the right server. As 3306 is the default port, most MySQL drivers will automatically attempt to connect to the server running on that port. If you want to connect to the other one, you'll have to make sure your code sets the correct port number.


That said, surely you can just turn off the MySQL instance WAMPP uses and use the one you already had? The Apache server it runs shouldn't be affected by a MySQL server conflict.

[no2pencil]

** Moved to Web Servers & Hosting **

Question is not PHP code, but for server configuration.

[Ahmedn1]

thank you for all your help
what happened is I removed the mysql server and re-installed WAMP
it worked
but there is a problem
when I try to run the MySQL console to set a password for the root it says it cannot connect to the mysql server
although it is running in wamp and SQLyog connects to it without problems

I tried to change the password through 'my.ini' but I still login without any password