mySQL 4.1 Can"t connect thru port 3306 protocol denied

--0-602571761-1124157033=:54034
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: 8bit

Dear Sir,

I'm using Win XP , Why my application program can't connect to MySQL 4.1 The error message is like this "Consider to upgrade mysql client".

Currenlt I'm using progarm realbasic 5.5 and if there is not password at username of ROOT it's fine. but If using password the problem occured. pls your help, thanks.

Rgds,
Eriko



Cheers,
Eriko
--0-602571761-1124157033=:54034--

Re: mySQL 4.1 Can"t connect thru port 3306 protocol denied

You're using a client wich doesn't support the new password format
released with MySQL 4.1, I've found many ways to work around this, but
for my app the best was to launch the server with the
--skip-grant-tables and login with the user that will have the
password changed, and issue an:

SET PASSWORD=3DOLD_PASSWORD('xxx');

This does the trick for me.

On 8/15/05, erikoguard-mysqlwin@yahoo.com w=
rote:
> Dear Sir,
>=20
> I'm using Win XP , Why my application program can't connect to MySQL 4.1 =
The error message is like this "Consider to upgrade mysql client".
>=20
> Currenlt I'm using progarm realbasic 5.5 and if there is not password at =
username of ROOT it's fine. but If using password the problem occured. pls =
your help, thanks.
>=20
> Rgds,
> Eriko
>=20
>=20
>=20
> Cheers,
> Eriko
>=20


--=20
Daniel da Veiga
Computer Operator - RS - Brazil
-----BEGIN GEEK CODE BLOCK-----
Version: 3.1
GCM/IT/P/O d-? s:- a? C++$ UBLA++ P+ L++ E--- W+++$ N o+ K- w O M- V-
PS PE Y PGP- t+ 5 X+++ R+* tv b+ DI+++ D+ G+ e h+ r+ y++
------END GEEK CODE BLOCK------

--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=3Dgcdmw-win32@m.gmane.org

Re: mySQL 4.1 Can"t connect thru port 3306 protocol denied

--0-2109569269-1124361076=:91327
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: 8bit

Thanks for advise, it's really work.

After checked ,my Application is doesn't supported the new password starting MySQL 4.1

I follow your suggest to change the password to OLD_PASSWORD.

Best Regards,
Eriko


Daniel da Veiga wrote:
You're using a client wich doesn't support the new password format
released with MySQL 4.1, I've found many ways to work around this, but
for my app the best was to launch the server with the
--skip-grant-tables and login with the user that will have the
password changed, and issue an:

SET PASSWORD=OLD_PASSWORD('xxx');

This does the trick for me.

On 8/15/05, erikoguard-mysqlwin@yahoo.com wrote:
> Dear Sir,
>
> I'm using Win XP , Why my application program can't connect to MySQL 4.1 The error message is like this "Consider to upgrade mysql client".
>
> Currenlt I'm using progarm realbasic 5.5 and if there is not password at username of ROOT it's fine. but If using password the problem occured. pls your help, thanks.
>
> Rgds,
> Eriko
>
>
>
> Cheers,
> Eriko
>


--
Daniel da Veiga
Computer Operator - RS - Brazil
-----BEGIN GEEK CODE BLOCK-----
Version: 3.1
GCM/IT/P/O d-? s:- a? C++$ UBLA++ P+ L++ E--- W+++$ N o+ K- w O M- V-
PS PE Y PGP- t+ 5 X+++ R+* tv b+ DI+++ D+ G+ e h+ r+ y++
------END GEEK CODE BLOCK------

--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=erikoguard-mysqlwin@yahoo .com



Cheers,
Eriko
--0-2109569269-1124361076=:91327--