AW: mysql program wont work after mysqlserver update

[Jürgen Ladstätter]

The output of the cmds is this:


mysql> show variables like "collation%";
+--+---+
| Variable_name| Value |
+--+---+
| collation_connection | latin1_swedish_ci |
| collation_database   | latin1_general_cs |
| collation_server | latin1_swedish_ci |
+--+---+
3 rows in set (0.00 sec)

mysql> show create table admin;
+---+---



+
| Table | Create Table
|
+---+---



+
| admin | CREATE TABLE `admin` (
  `u_id` int(10) unsigned NOT NULL auto_increment,
  `member_id` varchar(13) collate latin1_general_ci NOT NULL default '',
  `password` text collate latin1_general_ci NOT NULL,
  PRIMARY KEY  (`u_id`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=latin1
COLLATE=latin1_general_ci COMMENT='admin identification' |
+---+---



+
1 row in set (0.00 sec)

mysql>

Mit freundlichen Grüßen

Jürgen Ladstätter ( [EMAIL PROTECTED] )

___

P.I.C.S. EDV GmbH.
A-5020 Salzburg, Landsturmstraße 18
Tel.: +43 (662) 455467
Fax.: +43 (662) 455468

Web: http://www.pics.co.at
E-Mail: [EMAIL PROTECTED]
Ihr Partner für Internet, Computer und Software
___


-Ursprüngliche Nachricht-
Von: Dan Buettner [mailto:[EMAIL PROTECTED] 
Gesendet: Dienstag, 22. August 2006 16:33
An: Jürgen Ladstätter
Cc: mysql@lists.mysql.com
Betreff: Re: mysql program wont work after mysqlserver update

Jürgen, I wonder if you have properly set collations in just some areas?

show variables like "collation%";

show create table ;  (for each table involved)

I would think you'd want this all to match ... though I am not an
expert in this area.

Dan



SHOW COLLATION

On 8/22/06, Jürgen Ladstätter <[EMAIL PROTECTED]> wrote:
> Hi Dan,
>
> first of all thanks for your reply, but i already changed the password to
> the "old_style" password, otherwise i wouldnt be able to connect and
> authenticate at all!
> But there must be anything else :-/
> I don't think that I need to write a new MySQL component to talk with my
> server, or let the 4.0 version run foever :-/
> I know that there is a solution - but where :)
>
> Mit freundlichen Grüßen
>
> Jürgen Ladstätter ( [EMAIL PROTECTED] )
>
> ___
>
> P.I.C.S. EDV GmbH.
> A-5020 Salzburg, Landsturmstraße 18
> Tel.: +43 (662) 455467
> Fax.: +43 (662) 455468
>
> Web: http://www.pics.co.at
> E-Mail: [EMAIL PROTECTED]
> Ihr Partner für Internet, Computer und Software
> ___
>
> -Ursprüngliche Nachricht-
> Von: Dan Buettner [mailto:[EMAIL PROTECTED]
> Gesendet: Dienstag, 22. August 2006 14:52
> An: Jürgen Ladstätter
> Cc: mysql@lists.mysql.com
> Betreff: Re: mysql program wont work after mysqlserver update
>
> Jürgen, not sure if this would be it, but password handling changed
> somewhat with MySQL 4.1.  From your error msg it seems doubtful, but
> thought I'd mention it.
>
> http://dev.mysql.com/doc/refman/4.1/en/password-hashing.html
>
> Dan
>
>
> On 8/22/06, Jürgen Ladstätter <[EMAIL PROTECTED]> wrote:
> > Hi all,
> >
> >
> >
> > i developed a c+ programm which uses dbx to get access to my
mysqlserver.
> > Now I needed to change provider and so I have my own server here :-)
> >
> > the old server was a 4.0.24 and now I have a 4.1.21.
> >
> > the problem is: when I connect and want to access any data, I get the
> error
> > message, that the "translation is illegal" … I really don't know what
this
> > means! Collation is set to latin1_general_ci, as on the old server :-(
> >
> >
> >
> > do you have any ideas?
> >
> >
> >
> > Mit freundlichen Grüßen
> >
> > Jürgen Ladstätter ( [EMAIL PROTECTED] )
> >
> > ___
> >
> > P.I.C.S. EDV GmbH.
> > A-5020 Salzburg, Landsturmstraße 18
> > Tel.: +43 (662) 455467
> > Fax.: +43 (662) 455468
> >
> > Web:   htt

AW: mysql program wont work after mysqlserver update

[Jürgen Ladstätter]

Hi Dan,

first of all thanks for your reply, but i already changed the password to
the "old_style" password, otherwise i wouldnt be able to connect and
authenticate at all!
But there must be anything else :-/
I don’t think that I need to write a new MySQL component to talk with my
server, or let the 4.0 version run foever :-/
I know that there is a solution - but where :)

Mit freundlichen Grüßen

Jürgen Ladstätter ( [EMAIL PROTECTED] )

___

P.I.C.S. EDV GmbH.
A-5020 Salzburg, Landsturmstraße 18
Tel.: +43 (662) 455467
Fax.: +43 (662) 455468

Web: http://www.pics.co.at
E-Mail: [EMAIL PROTECTED]
Ihr Partner für Internet, Computer und Software
___

-Ursprüngliche Nachricht-
Von: Dan Buettner [mailto:[EMAIL PROTECTED] 
Gesendet: Dienstag, 22. August 2006 14:52
An: Jürgen Ladstätter
Cc: mysql@lists.mysql.com
Betreff: Re: mysql program wont work after mysqlserver update

Jürgen, not sure if this would be it, but password handling changed
somewhat with MySQL 4.1.  From your error msg it seems doubtful, but
thought I'd mention it.

http://dev.mysql.com/doc/refman/4.1/en/password-hashing.html

Dan


On 8/22/06, Jürgen Ladstätter <[EMAIL PROTECTED]> wrote:
> Hi all,
>
>
>
> i developed a c+ programm which uses dbx to get access to my mysqlserver.
> Now I needed to change provider and so I have my own server here :-)
>
> the old server was a 4.0.24 and now I have a 4.1.21.
>
> the problem is: when I connect and want to access any data, I get the
error
> message, that the "translation is illegal" … I really don't know what this
> means! Collation is set to latin1_general_ci, as on the old server :-(
>
>
>
> do you have any ideas?
>
>
>
> Mit freundlichen Grüßen
>
> Jürgen Ladstätter ( [EMAIL PROTECTED] )
>
> ___
>
> P.I.C.S. EDV GmbH.
> A-5020 Salzburg, Landsturmstraße 18
> Tel.: +43 (662) 455467
> Fax.: +43 (662) 455468
>
> Web:   http://www.pics.co.at
> E-Mail: [EMAIL PROTECTED]
> Ihr Partner für Internet, Computer und Software
> ___
>
>
>
>
>


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