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 using MySQL 4.1 with PHP 4, then try changing your user's password with the OLD_PASSWORD() function.
http://dev.mysql.com/doc/mysql/en/Encryption_functions.html
Wes
On Aug 13, 2004, at 9:48 AM, 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 am I overlooking? Again putting the root user name and pw it'll work in php but not for sarah:
the php.... mysql_pconnect("localhost","sarah","camera") or die("ERROR: Could not connect to database!"); mysql_select_db("howto");
*But* on the command line the sarah user works OK:
C:\Documents and Settings\Administrator>mysql -u sarah -p Enter password: ****** Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 19 to server version: 4.1.3a-beta-nt-max
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql> select * from howto.page; +---------+-----------------------------+ | page_id | page_url | +---------+-----------------------------+ | 1 | http://www.lg.netfarms.org | +---------+-----------------------------+ 1 row in set (0.00 sec)
mysql> show grants for [EMAIL PROTECTED];
+---------------------------------------------------------------------- -------------------------------------------------+
| Grants for [EMAIL PROTECTED]
|
+---------------------------------------------------------------------- -------------------------------------------------+
| GRANT ALL PRIVILEGES ON *.* TO 'sarah'@'localhost' IDENTIFIED BY
PASSWORD '*6043233C67ADBE7E9242089D718763C3C5E1A1E2' |
+---------------------------------------------------------------------- -------------------------------------------------+
1 row in set (0.00 sec)
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
