Re: upgrade which client?
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: Mysqlgrant 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]
upgrade which client?
I needed 5to 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: Mysqlgrant 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 addes 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? Brian Duke SS-Technical Customer Assistance Level(3) Communications 720-888-7797
RE: upgrade which client?
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: Mysqlgrant 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? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]