Invalid password exception handling (EMysqlException error)

[[email protected]]

I'm new to these components so I apologize, but I need help handling a wrong password exception from the MyConnection and MyConnectDialogue. With correct username and password, the applicatio nruns fine, however, an invalid password gives te following error:

"Project myproject.exe raised exception class EMySqlException with
message #280000Access denied for user 'User1@localhost' using
password:YES'. Process stopped. Use Step or Run to continue"

It's probably a quick fix, that I can't see, but any help is appreciated.

[eduardosic]

I'm new to these components so I apologize, but I need help handling a wrong password exception from the MyConnection and MyConnectDialogue. With correct username and password, the applicatio nruns fine, however, an invalid password gives te following error:

"Project myproject.exe raised exception class EMySqlException with
message #280000Access denied for user 'User1@localhost' using
password:YES'. Process stopped. Use Step or Run to continue"

It's probably a quick fix, that I can't see, but any help is appreciated.

What version of myDAC and mySQL server?

the information is very important.

[Antaeus]

To handle this error try using somethig like this:

Code: Select all

  try
    MyConnection.Connect;
  except
    on e: EMyError do
      if E.Errorcode = ER_ACCESS_DENIED_ERROR then
        MessageDlg('Wrong username or password', mtError, [mbOK], 0)
      else
        raise;
  end;

Dont forget to include MyClasses and MyCall units into the project.

[[email protected]]

Version 4.3 myDAC with version 4.1 mySQL