RE: php conection problems

[Jeff Mao]

Argh,...this is what happens when you leave your sysadmin job to 
become a bureaucrat!  Lost my edge I guess,...I just looked again at 
what I downloaded earlier today to install,...and I had the version 
for Mac OS X v 10.2 and not 10.3,...

Thanks all for your help!
Jeff
At 8:29 AM +1100 2/11/05, Logan, David (SST - Adelaide) wrote:
As I said, I don't know the process on a mac (unless this is os X and
then I can guess) so can't advise on that. The manual at
http://www.php.net/manual/en/install.macosx.php probably has the info
there.
Another reason would be the different release schedules with php and
mysql. They are dropping the built in mysql for version 5.0 of php. That
is documented at the php site.
The php site has all the installation instructions for a Mac and should
be able to guide you through building your own. The mysql site
http://dev.mysql.com/downloads/mysql/4.1.html (this for version 4.1) has
binaries prebuilt for a Mac OS X
If you still don't get the info you need for the above pages, try
running
./configure --help at the command prompt. This will give you all the
options available to you including directing the compiler/linker etc. to
the right spot for your mysql client libraries.
Regards
David Logan
Database Administrator
HP Managed Services
148 Frome Street,
Adelaide 5000
Australia
+61 8 8408 4273 - Work
+61 417 268 665 - Mobile
+61 8 8408 4259 - Fax
-----Original Message-----
From: Jeff Mao [mailto:[EMAIL PROTECTED]
Sent: Friday, 11 February 2005 7:52 AM
To: Logan, David (SST - Adelaide)
Cc: mysql@lists.mysql.com
Subject: RE: php conection problems
I'm running Mac OS X,...so if the the disable and rebuild isn't too
hard, can you outline that process?
Jeff
Probably because they don't have the time to get the latest and
greatest
client library every time. I'm not sure how to rebuild it on Windows
but
you can disable the built in on unix and rebuild it linking in the
latest library.
Regards
David Logan
Database Administrator
HP Managed Services
148 Frome Street,
Adelaide 5000
Australia
+61 8 8408 4273 - Work
+61 417 268 665 - Mobile
+61 8 8408 4259 - Fax
-----Original Message-----
From: Jeff Mao [mailto:[EMAIL PROTECTED]
Sent: Friday, 11 February 2005 7:36 AM
To: mel list_php; mysql@lists.mysql.com
Subject: RE: php conection problems
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]

--
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]

--
************************
Jeff Mao
[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]