Solved

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

Posted on 2010-11-28
10
438 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
What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

 

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

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…
Nothing in an HTTP request can be trusted, including HTTP headers and form data.  A form token is a tool that can be used to guard against request forgeries (CSRF).  This article shows an improved approach to form tokens, making it more difficult to…
This Micro Tutorial will give you a introduction in two parts how to utilize Windows Live Movie Maker to its maximum editing capability. This will be demonstrated using Windows Live Movie Maker on Windows 7 operating system.
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 …

776 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