here is the code snippet: it still doesn't work with mysql56conn:
a:=0;
clearul(a);
cleartl;
loaddb;
try
if (conn.Connected=true) then begin
query.Close;
query.SQL.Clear;
query.SQL.Add('select uname, pword from userlogintb;');
query.ExecSQL;
query.Last;
end;
except
on err: ESQLDatabaseError do begin
ShowMessage(err.Message);
ShowMessage(err.UnitName);
end;
end;