[rt-users] Login fails after reinstall of RT 3.4.4 -- SOLVED

[Les Mikesell]

On Mon, 2005-11-07 at 21:17, Scott Courtney wrote:

> ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
> 

> I only discovered the problem by accident. As I was trying Luke's suggestion
> for the password, and had previously been referencing records by ID number,
> as in "SELECT * FROM Users WHERE id=12;". In that case, however, I issued the
> command "SELECT * FROM Users WHERE name='root';" and was amazed that MySQL
> didn't match the record.

Is your system default characterset latin1?  If not, when does the
conversion happen when a non-default characterset is specified
at the table level in mysql?

-- 
  Les Mikesell
    les at futuresource.com