Re: [PHP-DB] help with mysql connect error

2007-02-11 Thread Chris
Tim McGeary wrote: Chris wrote: Tim McGeary wrote: Stut wrote: Ok, so I did the recommended process of: mysql UPDATE mysql.user SET Password = OLD_PASSWORD('newpwd') - WHERE Host = 'some_host' AND User = 'some_user'; mysql FLUSH PRIVILEGES; This allows the CLI script to run

Re: [PHP-DB] help with mysql connect error

2007-02-09 Thread Tim McGeary
Chris wrote: Tim McGeary wrote: Stut wrote: Ok, so I did the recommended process of: mysql UPDATE mysql.user SET Password = OLD_PASSWORD('newpwd') - WHERE Host = 'some_host' AND User = 'some_user'; mysql FLUSH PRIVILEGES; This allows the CLI script to run successfully, but the web php

Re: [PHP-DB] help with mysql connect error

2007-02-08 Thread Stut
Tim McGeary wrote: I am new to this list today, so if I should be sending this to another specific PHP list, please let me know. I am getting the following error via the PHP web page I am building: Warning: mysql_connect(): Can't connect to local MySQL server through socket

Re: [PHP-DB] help with mysql connect error

2007-02-08 Thread Tim McGeary
Stut wrote: Tim McGeary wrote: I am new to this list today, so if I should be sending this to another specific PHP list, please let me know. I am getting the following error via the PHP web page I am building: Warning: mysql_connect(): Can't connect to local MySQL server through socket

Re: [PHP-DB] help with mysql connect error

2007-02-08 Thread Tim McGeary
Please include the list in replies. Sorry, I meant to, but hit the wrong button. Tim McGeary wrote: Stut wrote: Tim McGeary wrote: I am new to this list today, so if I should be sending this to another specific PHP list, please let me know. I am getting the following error via the PHP web

Re: [PHP-DB] help with mysql connect error

2007-02-08 Thread Stut
Tim McGeary wrote: Please include the list in replies. Sorry, I meant to, but hit the wrong button. Tim McGeary wrote: Stut wrote: Tim McGeary wrote: I am new to this list today, so if I should be sending this to another specific PHP list, please let me know. I am getting the following

Re: [PHP-DB] help with mysql connect error

2007-02-08 Thread Tim McGeary
Stut wrote: Tim McGeary wrote: Tim McGeary wrote: Stut wrote: Tim McGeary wrote: I am new to this list today, so if I should be sending this to another specific PHP list, please let me know. I am getting the following error via the PHP web page I am building: Warning: mysql_connect():

Re: [PHP-DB] help with mysql connect error

2007-02-08 Thread Stut
Tim McGeary wrote: Oh, duh! Ok. I wrote this: ?php $hostname = localhost; $username = softread; $password = XXX; $dbname = software; mysql_connect($hostname, $username, $password) or die(mysql_error()); mysql_select_db($dbname) or

Re: [PHP-DB] help with mysql connect error

2007-02-08 Thread Tim McGeary
Stut wrote: Tim McGeary wrote: Oh, duh! Ok. I wrote this: ?php $hostname = localhost; $username = softread; $password = XXX; $dbname = software; mysql_connect($hostname, $username, $password) or die(mysql_error());

Re: [PHP-DB] help with mysql connect error

2007-02-08 Thread Stut
Tim McGeary wrote: But I do have a MySQL 5 client: [EMAIL PROTECTED] html]# rpm -qa MySQL* MySQL-shared-compat-5.0.27-0.rhel3 MySQL-client-standard-5.0.27-0.rhel3 MySQL-python-0.9.1-6 MySQL-server-standard-5.0.27-0.rhel3 MySQL-devel-standard-5.0.27-0.rhel3 or are you saying that the PHP libs

Re: [PHP-DB] help with mysql connect error

2007-02-08 Thread Tim McGeary
Stut wrote: Tim McGeary wrote: But I do have a MySQL 5 client: [EMAIL PROTECTED] html]# rpm -qa MySQL* MySQL-shared-compat-5.0.27-0.rhel3 MySQL-client-standard-5.0.27-0.rhel3 MySQL-python-0.9.1-6 MySQL-server-standard-5.0.27-0.rhel3 MySQL-devel-standard-5.0.27-0.rhel3 or are you saying that

Re: [PHP-DB] help with mysql connect error

2007-02-08 Thread Stut
Tim McGeary wrote: Thank you for the link. I think that's probably the best way to go in this case, since it's only on a dev/test server. When I build the production server, I should probably upgrade to PHP5 anyhow. I assume that should not have this problem, right? It might. PHP5 can be

Re: [PHP-DB] help with mysql connect error

2007-02-08 Thread Tim McGeary
Stut wrote: Tim McGeary wrote: But I do have a MySQL 5 client: [EMAIL PROTECTED] html]# rpm -qa MySQL* MySQL-shared-compat-5.0.27-0.rhel3 MySQL-client-standard-5.0.27-0.rhel3 MySQL-python-0.9.1-6 MySQL-server-standard-5.0.27-0.rhel3 MySQL-devel-standard-5.0.27-0.rhel3 or are you saying that

Re: [PHP-DB] help with mysql connect error

2007-02-08 Thread Chris
Tim McGeary wrote: Stut wrote: Tim McGeary wrote: But I do have a MySQL 5 client: [EMAIL PROTECTED] html]# rpm -qa MySQL* MySQL-shared-compat-5.0.27-0.rhel3 MySQL-client-standard-5.0.27-0.rhel3 MySQL-python-0.9.1-6 MySQL-server-standard-5.0.27-0.rhel3 MySQL-devel-standard-5.0.27-0.rhel3 or