That did the trick,...thanks
so,...why is my Apache installation using an old client? After reading your suggestion, it makes more sense when I look at the output of phpinfo() which says that mysql is "builtin" and the Client API version is 3.23.49,...why?! I guess it was a bad assumption on my part that a fresh install of mysql would include all new versions?! Or is this "builtin" 3.23.49 part of my Apache installation that shipped with my laptop?
If anyone can shed some light on how to update that part of it, I'd greatly appreciate it! I'd hate to have to go through these extra steps every time!
Jeff
At 8:55 PM +0000 2/10/05, mel list_php wrote:
I'm not sure if it can be a password problem as you can connect through command line,but when upgrading to 4.1 I had the classical "access deny" error with phpmyadmin whereas everything else was ok.
You can still have a look there: http://dev.mysql.com/doc/mysql/en/old-client.html
but I think in that case you should have an explicit error message. (Client does not support authentication protocol).
You can still try to update dbUser set password=old_password(***) for one of your user and give it a try.
good luck!
From: Jeff Mao <[EMAIL PROTECTED]>
To: Jay Blanchard <[EMAIL PROTECTED]>, mysql@lists.mysql.com
Subject: RE: php conection problems
Date: Thu, 10 Feb 2005 15:36:19 -0500
I've tried using a variety of very wide open permissions just to get something to connect including:
using the root user/password in the php scripts
declaring a user in mysql,...
grant all on mydatabase.* to myuser identified by 'mypassword';
grant all on mydatabase.* to myuser@'%' identified by 'mypassword';
grant all on mydatabase.* to [EMAIL PROTECTED] identified by 'mypassword';
grant all on mydatabase.* to [EMAIL PROTECTED] identified by 'mypassword'; [my current IP]
grant all on mydatabase.* to [EMAIL PROTECTED] identified by 'mypassword';
flushed privileges,..etc,...no go,...
Thanks for any other ideas! Jeff
At 2:09 PM -0600 2/10/05, Jay Blanchard wrote:[snip] 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? [/snip]
Permissions?
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
-- ************************ Jeff Mao [EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
_________________________________________________________________
Want to block unwanted pop-ups? Download the free MSN Toolbar now! http://toolbar.msn.co.uk/
-- ************************ Jeff Mao [EMAIL PROTECTED]
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
