Solved

Unable to access MySQL through PHP and phpMyAdmin on Win 7 PRO ....

Posted on 2010-11-28
10
435 Views
Last Modified: 2012-05-10
Hello:
I am having problems with accessing MySQL from PHP and phpmyadmin. I guess the problem may have the same root. Here is the problem description:

phpmyadmin

When I type in http://localhost/phpmyadmin/index.php, the login page is displayed. After entring userid and password, the page hangs for a while than browser (IE8) dispalys the following message:

The website cannot display the page
 HTTP 500  
   Most likely causes:
•The website is under maintenance.
•The website has a programming error.
 
   What you can try:
     Refresh the page.
 
     Go back to the previous page.
 
PHP

The page hangs for a while than displays the page with a javascript error. The page works great withoout the MySQL Access code.

I am able to access MYSQL from other softwares like" PHP Generator For MYSQL" and RazorSQL

Thanks,

<<< Ali >>>
0
Comment
Question by:MohammadAliQureshi
  • 6
  • 3
10 Comments
 
LVL 27

Expert Comment

by:Tolomir
ID: 34226818
0
 

Author Comment

by:MohammadAliQureshi
ID: 34226861

Hello Tolomir:

Attached is the PHP code I am using ...

Thanks,
<<< Ali >>>
<?php

echo "Trying To Connect ...";

$con = mysql_connect("localhost:3306","uid","pwd");



 if (!$con)

  {

    die('Could not connect: ' . mysql_error());

  }

echo "connected ...";

    $dbselect = mysql_select_db("test", $con);



 if (!$dbselect)

  {

    die('Unable To Select Database: ' . mysql_error());

  }

 echo "dbSelected ...");

$result = mysql_query("SELECT ....WHERE (DayOfYear(curdate()) - 1) between start_dayofyear AND end_dayofyear;", $con);



if (!$result)

 {

  $error = 9;

  die ("Unable To Retrieve Prayer Timings: ".mysql_error());

  }

 if (mysql_num_rows($result) > 0)

  {

 $row = mysql_fetch_array($result);

 }

else

{

  $error = 9;

  die ("Unable To Retrieve ..: \n"." ".mysql_error());

  }

?>

Open in new window

0
 
LVL 6

Expert Comment

by:kiwistag
ID: 34226955
Check the security permissions. It could be something in the background it's trying to access that is blocked/denied.
0
 

Author Comment

by:MohammadAliQureshi
ID: 34227078
Hello kiwistag:

Just wondering .... If there was a security issue, I think, I  should not be able to access MYSQLfrom other softwares?

Thanks,
<<< Ali >>>
0
 
LVL 6

Expert Comment

by:kiwistag
ID: 34227297
Are you using IIS or apache?
0
PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

 

Author Comment

by:MohammadAliQureshi
ID: 34227340
Hello kiwistag:

Apache ...
0
 

Author Comment

by:MohammadAliQureshi
ID: 34231794
Hello:

I have new issues regarding this problem ...

I uninstalled MySQL Server so that I can reinstall it uner C:\ where PHP, Apache are also installed.
Now, MySQL is not starting as Windows Service ... giver error 1067 (At times the error message is unable to find path ... I did change the slashes to match Windows on my.ini file .. but no success).

I did look around this site for the solution to 1067 problem, but none of the solution worked for me.

Tonight, I will reinstall MYSQL as Windows service with a different name (i.e.. MySQL2 instead of MySQL) and see if this helps ... I thought I will update you with the current happenings.

Thanks,

<<< Ali >>>
0
 
LVL 6

Expert Comment

by:kiwistag
ID: 34235713
Check that the existing service is pointing in the same location. I'm not too familiar with error 1067 but try points here: 2.10.5. Troubleshooting a MySQL Installation Under Windows

Is it possible that PHPmyAdmin needs to write to a config file somewhere and the security settings deny initial anonymous writes? I haven't used it enough to be sure.
0
 

Accepted Solution

by:
MohammadAliQureshi earned 0 total points
ID: 34235915
Hello:

UPDATE

I change the log file to C:\PHP\log and found the following error:

Warning: mysql_connect() [function.mysql-connect]: [2002]
A connection attempt failed because the connected party did
not (trying to connect via tcp://localhost:3306) in
C:\Path\To\Script.php on line 26

Warning: mysql_connect() [function.mysql-connect]: A connection
attempt failed because the connected party did not properly
respond after a period of time, or established connection failed
because connected host has failed to respond. in
C:\Path\To\Script.php on line 26

Fatal error: Maximum execution time of 30 seconds exceeded in
C:\Path\To\Script.php on line 26

Than I google the error and found the fix on this site:

http://ryan.rawswift.com/2010/03/29/a-connection-attempt-failed-because-the-connected-party-did-not-properly-respond/

The fix is simple as follows:
1.Go to “C:\Windows\System32\drivers\etc“.
2.Open “hosts” with Notepad program.
3.Uncomment this line: “127.0.0.1 localhost” or add it if it’s not on the host entry.

I will keep this question for couple of days in case I need some help ...

Anyway ... Thanks for all the help and the time all of you have invested ....

Thanks,
<<< Ali >>>
0
 

Author Closing Comment

by:MohammadAliQureshi
ID: 34426523
I found the solution on the net ....
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Password hashing is better than message digests or encryption, and you should be using it instead of message digests or encryption.  Find out why and how in this article, which supplements the original article on PHP Client Registration, Login, Logo…
Introduction This article is intended for those who are new to PHP error handling (https://www.experts-exchange.com/articles/11769/And-by-the-way-I-am-New-to-PHP.html).  It addresses one of the most common problems that plague beginning PHP develop…
The viewer will learn how to count occurrences of each item in an array.
The viewer will learn how to create a basic form using some HTML5 and PHP for later processing. Set up your basic HTML file. Open your form tag and set the method and action attributes.: (CODE) Set up your first few inputs one for the name and …

911 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

25 Experts available now in Live!

Get 1:1 Help Now