As part of my latest project, I decided to try out WampServer, the Windows development environment for developing web applications with Apache web server, MySQL database and PHP scripting (Windows, Apache, MySQL, PHP – WAMP). Packages like WampServer and EasyPHP are simplified ways to create a testing environment on your PC without spending a lot of time downloading, installing and configuring the individual components. The package also includes utilities such as PHPMyAdmin and SQLBuddy for managing your MySQL databases and writing SQL queries. The software is available in 32- and 64-bit versions and the installation is pretty straightforward.
All of the functionality of WampServer is controlled from the program menu which is accessed through the system tray icon.
Once the installation is finished, you can start the WampServer environment by selecting the ‘start WampServer’ menu item from the Windows start menu. The environment is controlled from the system tray icon which provides a menu with management selections for all the modules as well as start, stop and restart commands for the entire system.
Installation Problems
Download Orange For Mac
The system tray icon also functions as a status indicator, initially showing red and then orange or green as components come online. If the icon remains red or orange, it means that one or more components are not working as they should. Apache, MySQL and PHP all have error logs that are accessible from the WampServer menu and it’s a good idea to check those if there’s any problem but here are a couple of things you can also try.
One of the first things to check whether another software is using communications port 80 on your system. Apache defaults to port 80 but so do other packages like Skype. In my case, I have Microsoft IIS installed and it had already called dibs on the port. You can find out if another software is using port 80 by selecting the Apache >> Service >> Test Port 80 options from the WampServer menu. Removing IIS and SQL Server, which can also claim port 80, was one solution but not one I wanted to go with.
Selecting Apache >> Service >> Test Port 80 from the WampServer menu will reveal if another software is using port 80 on your system and keeping WampServer from working.
The next solution I found online was to change the port that Apache was using to another one, like 7080. You can actually test to see if a port is being used by opening a command window (Start >> cmd) and typing the following:
This will provide you with a list of all current port connections along with the ID (PID) of the process involved which you can look up in Task Manager. If port 80 is in use, you can decide on an available port number not listed there and change WampServer’s preference by selecting the Apache >> httpd.conf options from the WampServer menu. This will open up the configuration file that tells Apache what port number to use. It will probably open in Notepad and look like complete gibberish since Notepad doesn’t recognize the line breaks. If you do have a better editor, like Notepad++, you can find the file in the C:wampbinapacheapache2.4.9conf subdirectory and open it from there.
By editing the Listen commands in the httpd.conf file, you can tell Apache to use a port other than port 80. In Notepad, use CTRL-F to search for the lines shown highlighted here.
If you don’t have another editor to use, just use CTRL-F in Notepad and search for the ##Listen command within the file. Then change the commands to match the following (assuming port 7080), replacing “:80” with “:7080” in both places. (Listen 12.34.5.6.78:80 is preceded by a # – it’s a commented line.)
After you save the file, close it and choose the Restart All Services option from the WampServer menu. Give it 30 seconds or so and see if the icon turns green. If it does, open your web browser and go to the following address:
This specifies localhost and the port number. If everything is working, you should see the following screen:
When WampServer is working correctly, localhost (plus the port number if you’ve changed it) should show the main screen.
If that doesn’t work … be sure the Apache and MySQL services are actually installed.
After messing around with different options on my system, I decided to do a system restore to get my IIS back to normal and reinstall WampServer with the port adjustment I outlined above. After I started it from the Windows Start menu, the status icon actually stayed RED, much to my concern. I checked the port and it was set to 7080 which was not being used.
The next things I checked were the the Apache and MySQL Service menus under the WampServer menu. The Service menus enable you to start, stop and restart the services or perform installation functions. In my case, the start / stop buttons were completely grayed out which suggested to me that the services had not been installed during the installation. So, I selected the Install Service option under both the Apache and MySQL menus. After that task completed, I chose Restart All Services from the main WampServer menu and, after a tense moment, the status icon showed green.
If you’re using EasyPHP WAMP dev server …
The procedure for changing the port number also works on EasyPHP with the added bonus that this server will automatically specify the corrected port number when you select the Local Web (F7) from the Administration menu. To change the httpd.conf file in EasyPHP, select Configuration >> Apache from the system tray menu.
For more information …
Again, if neither of these work, check the error logs from the individual component menus to see if you can get any sense of what went wrong. Google is generally my first stop and that will likely take you to the WampServer forum or StackOverflow, both of which can provide a lot of good information on working with the software.
MySQL does not have to be a mystery!
MySQL Explained offers a complete guide to the installation and use of MySQL and is written for people without a background in I.T. or database design. MySQL Explained takes the reader from the very basics of database theory through the installation options for MySQL and the design of custom databases based on everyday real-world examples. Find out more and get your copy on LeanPub.com and Amazon.com in paperback and a variety of electronic formats!
Available on Amazon.com
Wrangler Authentics Men's Big and Tall Classic Relaxed Fit Jean Wrangler
MySQL Community Edition is a freely downloadable version of the world's most popular open source database that is supported by an active community of open source developers and enthusiasts.
MySQL delivers enterprise features, including:
This quickstart demonstrates how to connect to an Azure Database for MySQL using the MySQL Workbench application.
Prerequisites
This quickstart uses the resources created in either of these guides as a starting point:
Install MySQL Workbench
Download and install MySQL Workbench on your computer from the MySQL website.
Get connection information
Get the connection information needed to connect to the Azure Database for MySQL. You need the fully qualified server name and login credentials.
Connect to the server by using MySQL Workbench
To connect to Azure MySQL Server by using the GUI tool MySQL Workbench:
Create a table, insert data, read data, update data, delete data
Now, you have connected to Azure Database for MySQL by using MySQL Workbench, and you have queried data using the SQL language.
Next stepsComments are closed.
|
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |