RE: php conection problems - Dean, Michael L USAATC - com.mysql.lists.mysql

17 messages in com.mysql.lists.mysqlRE: php conection problems

From	Sent On	Attachments
Jeff Mao	10 Feb 2005 12:01
Jay Blanchard	10 Feb 2005 12:08
Dean, Michael L USAATC	10 Feb 2005 12:21
Jeff Mao	10 Feb 2005 12:35
mel list_php	10 Feb 2005 12:55
Jeff Mao	10 Feb 2005 13:05
Logan, David (SST - Adelaide)	10 Feb 2005 13:13
Jeff Mao	10 Feb 2005 13:22
Logan, David (SST - Adelaide)	10 Feb 2005 13:29
Jeff Mao	10 Feb 2005 13:40
Jeff Mao	11 Feb 2005 08:28
mel list_php	11 Feb 2005 08:59
Hassan Schroeder	11 Feb 2005 09:07
Jeff Mao	11 Feb 2005 09:41
Dean, Michael L USAATC	11 Feb 2005 10:10
Dean, Michael L USAATC	11 Feb 2005 10:18
Jeff Mao	11 Feb 2005 10:29

Subject:	RE: php conection problems
From:	Dean, Michael L USAATC (mich...@atc.army.mil)
Date:	02/11/2005 10:18:42 AM
List:	com.mysql.lists.mysql

Jeff,

When you upgraded to the 4.1 version of MySQL did you run the mysql_fix_privilege_tables script? I just upgraded a 3.23 server to the 4.1 and ran that script and my php seems to work fine using the 3.23 client. I had to "fix" other instances where I had used the password('pass') method in MySQL to populate a column, but as far as connecting I had no problems.

Michael

-----Original Message----- From: Jeff Mao [mailto:jm...@mac.com] Sent: Thursday, February 10, 2005 3:02 PM To: mys...@lists.mysql.com Subject: php conection problems

Hi All,

I'm not sure this a MySQL problem or a PHP problem,...

I just picked up a new laptop, and like I had always done in the past, installed MySQL and PHP so I could test and play with code locally.

The laptop is a Mac Powerbook running 10.3.8. The MySQL installation is the Standard 4.1.19 installation from the dev.mysql.com website. The php installation is Marc Liyanage's (entropy.ch) package installer for 4.3.10.

php appears to be OK as pulling a page with <?php phpinfo () ?> yields the normal output.

MySQL appears fine as I can login and do things Terminal using the mysql client.

But setting up an of the numerous simple php/mysql web sites, like phpbb or moodle give me database connection failures,...

In the past, I've always simply installed these two pieces as I mentioned above and everything was so easy,....but it's been awhile since I last did this,....did I miss something?