Can connect with PHP to MYSQL

2004-08-13 Thread leegold
I can connect in the php by using 'root' and the root pw. But when I tried adding a user ( sarah ) with GRANT I cannot connect from php. The php is simple, what am I overlooking? Again putting the root user name and pw it'll work in php but not for sarah: the php

Re: Can connect with PHP to MYSQL

2004-08-13 Thread suomi
i usually do $link = mysql_connect($server, $userid, $password); and it works, except when the pw is incorrect suomi leegold wrote: I can connect in the php by using 'root' and the root pw. But when I tried adding a user ( sarah ) with GRANT I cannot connect from php. The php is simple, what

Re: Can connect with PHP to MYSQL

2004-08-13 Thread Wesley Furgiuele
What error are you getting? My problem when moving to 4.1 was forgetting that I was using an older MySQL client. I'm not positive, but I think that in order to connect to MySQL 4.1 with PHP you need to use the mysqli functions, not mysql, and mysqli requires PHP 5. If you want to keep

Re: Can connect with PHP to MYSQL

2004-08-13 Thread leegold
On Fri, 13 Aug 2004 11:24:46 -0400, Wesley Furgiuele [EMAIL PROTECTED] said: What error are you getting? My problem when moving to 4.1 was forgetting that I was using an older MySQL client. I'm not positive, but I think that in order to connect to MySQL 4.1 with PHP you need to use the

Re: Can connect with PHP to MYSQL

2004-08-13 Thread Andreas Ahlenstorf
I think that's the problem. Could be a lot of editing PHP scripts for a lot of people(!?) Thanks Try to compile PHP against the client library for MySQL 4.1. I'll wonder if it won't work. ext/mysqli is required if you like to use things like prepared statements... Regards, A. -- MySQL