Fatal error: Maximum execution time of x seconds exceeded

Question

I am not sure whether this problem is related to magento or not.

I downloaded the below files

• magento 1.7.1 version
• XAMPP 1.7.3 win 32 (my laptop is Windows 8 64bit)

First, I installed Xampp and run the apache but due to port 80 unavailability, I changed the default port of apache server to "9999".

Later, I extracted the magento in "htdocs" folder and run it on firefox like this "http://localhost:9999/magento"

A Installation wizard appeared inside the webpage. In the "Configuration" step, I added the following information:

• Database Type = MySQL
• Host = localhost:9999
• Database name = magento
• username = root
• password = (nothing)

I haven't touched the other settings.

Before proceeding, I created a database name "magento" through "PhpMyAdmin" and added sample data (.sql file) which I had downloaded from magento.com.

When I pressed the button "continue", after a long time I got the following error:

Fatal error: Maximum execution time of 60 seconds exceeded in c:\wamp\www\magento\lib\Zend\Db\Statement\Pdo.php on line 228

I followed this link and did some changes as follows:

In php/php.ini file: (changed the following values)

• max_execution_time = 3600 (default was "60")
• max_input_time = -1 (default was "60")
• memory_limit = 512M (default was "128M")

and In magento/index.php file added set_time_limit(600); at very first after <?php line.

After doing the above changes, I am getting different error which is shown below: (In red line)

I can't understand what could be the problem.

Please help.

PS: At first, the installation went smooth but when I am trying to install second time, these issues are arousing.

Solution

While installing magento, In "configuration" page --> "Database connection" section, I was giving host as localhost:9999 instead of just localhost because PhpMyAdmin was running on localhost as shown in the below image.

This is my stupid mistake. I will keep this as answer because it is a good lesson for me to understand that there is difference between the host names of "Database" and "Web server".