2 messages in com.mysql.lists.win32Re: MySQL cmd line OK but PHP Not Con...| From | Sent On | Attachments |
|---|---|---|
| Rob Lorimer | 30 Mar 2002 14:17 | |
| Rob Lorimer | 01 Apr 2002 15:27 |
| Subject: | Re: MySQL cmd line OK but PHP Not Connecting |
|---|---|
| From: | Rob Lorimer (rlor...@es.co.nz) |
| Date: | 04/01/2002 03:27:20 PM |
| List: | com.mysql.lists.win32 |
MyODBC is installed and shows up fine in WinMySQLAdmin. As you say, it's required for access to connect to MySQL.
PHP does not use MyODBC, it has mysql support functions built in.
I have the same setup on another win32 machine. Only difference I can see is that the problem PC is my Internet Connection Sharing PC.
Rob
----- Original Message ----- From: <jbon...@sola.com.au> To: <rlor...@es.co.nz> Sent: Tuesday, April 02, 2002 11:08 AM Subject: RE: MySQL cmd line OK but PHP Not Connecting
Have you installed MyODBC? You will need that for Access and possibly also PHP.
John Bonnett
-----Original Message----- From: Rob Lorimer [mailto:rlor...@es.co.nz] Sent: Sunday, 31 March 2002 7:48 AM To: win...@lists.mysql.com Subject: MySQL cmd line OK but PHP Not Connecting
I have MySQL installed OK, works from command prompt and from winmysqladmin. Strange thing is that I can't connect to MySQL from PHP (or MyODBC via Access).
I can use MySQLGUI OK using the password I set up with winmysqladmin.
I checked the users table in the mysql database to make sure that the user I setup with winmysqladmin has all privileges possible.
When trying to connect as root or with my other user name fromm php (or Access using MyODBC) I get the error message:
Can't connect to MySQL server on 'localhost' (10061)
Like I say, MySQL service is running and works from command prompt (and MySQLGUI using the password I set up with winmysqladmin).
I have the same setup on another PC and all works fine I'm getting very frustrated...thanks for your help.