Databases
StackOverflow2013
Postsdbo
POCan't get PHP to work with mySQL on Vista 64
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POCan't get PHP to work with mySQL on Vista 64
    primarykey
    data
    text
    <p>I'm running Vista 64 box, and attempting to setup Joomla using IIS7 (I like Joomla, I want to have some asp.net components on my web site, so that's why I want to use IIS7 and not Apache). It's my first time installing both php and mysql, so it's very possible that I'm doing something obviously wrong... though I think I tried enough diagnostic steps (described below) that there's nothing obviously wrong <em>to me</em>...</p> <p>I installed PHP (32 bit, 5.2.8), and that seems to work ok: I got a test.php that displays phpinfo in an IIS7-served web page.</p> <p>I also installed mySQL (32 bit, 5.1.31, downloaded from <a href="http://dev.mysql.com/downloads/mysql/5.1.html#win32" rel="nofollow noreferrer">http://dev.mysql.com/downloads/mysql/5.1.html#win32</a> ). That seems to work fine too (I can connect to it using MySQL Administrator).</p> <p>I've setup php.ini and what not to turn on the mySQL extension. If I do php -m from the command line I see mysql in the list. However, with phpinfo (either from the command line (php -info) or served via IIS (in a test.php file)), there is no mysql section. Because mysql is not even showing up in the command-line call of php, I don't think this has anything to do with IIS -- just an install of mysql &amp; php on vista.</p> <p>I didn't install mysql 64bit because I have an 32bit install of php, and since mysql 32 bit seems to work fine I assume that's not the issue. It seems there is no official 64bit version of php so that's why I installed that (and again, that seems to work fine).</p> <p>I currently have UAC disabled, so that's not the issue.</p> <p>If I put the semi-colon back in front of extension=php_mysql.dll in my php.ini then when running php -m, the mysql module doesn't show up. If I take it out again then it shows up. So I'm at least certain I'm modifying the right php.ini .</p> <p>I've copied libeay32.dll, libmysql.dll, and php_mysql.dll to c:\windows\system32. I've taken them out and that doesn't seem to make a difference to the output of php -m (i.e., mysql still shows up there if the module is uncommented from php.ini).</p> <p>I also tried copying the dlls ibeay32.dll, libmysql.dll, and php_mysql.dll to c:\windows\sysWOW64; that made no difference.</p> <p>It seems like the smallest positive step would be for mysql to show up when running php -info from the command line. Is there any further thing I should try to figure out why mysql is showing up in php -m and not with php -info? Or am I off track as using this to gauge whether php can talk to mysql?</p> <p>Thanks!</p>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. USJimmy
    1. USJimmy
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    2. PO
      singulars
      1. PTAnswer
    3. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POCan't get PHP to work with mySQL on Vista 64
      1. USJimmy
      1. VTFavorite
    2. VO
      singulars
      1. POCan't get PHP to work with mySQL on Vista 64
      1. This table or related slice is empty.
      1. VTUpMod
    3. VO
      singulars
      1. POCan't get PHP to work with mySQL on Vista 64
      1. This table or related slice is empty.
      1. VTUpMod
    1. This table or related slice is empty.
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload