"Duke, Brian" <[EMAIL PROTECTED]> wrote:
>
> I needed to do some subqueries. I had mysql-3.23. Somehow I thought
> mysql4 included subqueries. Loaded mysql-4.0. Converted everything and
> got it working except it doesn't do subqueries. Therefore we installed
> mysql-4.1.1 6 hours of figuring out the permissions finally we got the
> databases all fixed and now I can actually query the tables I see.
>
> Now there is 1 error left that we're a little confused about. We logged
> into the server locally via:
>
> mysql -u root -p
>
> It verifies the password and lets us in. We create the users for all the
> php scripts via:
>
> Mysql>grant all on scratch.* to 'fred'@'localhost' identified by
> 'password';
>
> And then when we run our php scripts the mysql-server says;
>
> "Error
>
> MySQL said:
>
> #1250 - Client does not support authentication protocol requested by
> server; consider upgrading MySQL client"
>
> So what client is mysql-server talking about? Is it the php-mysql rpm or
> the MySQL-client rpm. The server was installed as a standard binary
> gunzip. We didn't see a mysql-client binary gunzip just the rpm.
>
>
> Our box currently has the following services:
>
> MySQL-client-4.1.1-0
>
> php-mysql-4.3.4-2
>
> mysql-standard-4.1.1-alpha-pc-linux-i686
>
> on a redhat9 os running a 2.4.20-30.9 kernel
>
> to be fair we installed the mysql-client after we got the first error
> message. Before that we had no mysql-client and added users via
> mysqladmin. I don't think I can upgrade the php-mysql any higher yet.
> Can someone let us know what we need to upgrade?
You should compile PHP with MySQL 4.1 client library or run MySQL server with
--old-passwords option:
http://dev.mysql.com/doc/mysql/en/Password_hashing.html
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensita.net/
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Egor Egorov
/ /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED]
/_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net
<___/ www.mysql.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
