Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 465
  • Last Modified:

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

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
MohammadAliQureshi
Asked:
MohammadAliQureshi
  • 6
  • 3
1 Solution
 
TolomirAdministratorCommented:
0
 
MohammadAliQureshiAuthor Commented:

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
 
kiwistagCommented:
Check the security permissions. It could be something in the background it's trying to access that is blocked/denied.
0
Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

 
MohammadAliQureshiAuthor Commented:
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
 
kiwistagCommented:
Are you using IIS or apache?
0
 
MohammadAliQureshiAuthor Commented:
Hello kiwistag:

Apache ...
0
 
MohammadAliQureshiAuthor Commented:
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
 
kiwistagCommented:
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
 
MohammadAliQureshiAuthor Commented:
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
 
MohammadAliQureshiAuthor Commented:
I found the solution on the net ....
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

  • 6
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now