Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

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

Posted on 2010-11-28
10
Medium Priority
?
461 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
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 

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
 

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

Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

Question has a verified solution.

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

By, Vadim Tkachenko. In this article we’ll look at ClickHouse on its one year anniversary.
In this blog, we’ll look at how improvements to Percona XtraDB Cluster improved IST performance.
This Micro Tutorial will teach you how to change your appearance and customize your Windows 7 interface to your unique preference. This will be demonstrated using Windows 7 operating system.
The viewer will learn how to successfully download and install the SARDU utility on Windows 7, without downloading adware.
Suggested Courses

876 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