Devart Forums

I am running into an issue with SSL connection with MySQL with Delphi 5.0. When I connect it says:

#28000Access denied for user
'myuser@xx-xx-xxx-x' (using password: YES)

I have set the CACert, Cert, Key after copying these files from the MySQL Server..
The user myuser was created on the MySQL Server with 'REQUIRE SSL'option.

What is missing or creating an error?

Check whether the TMyConnection.Options.Protocol property is set to mpSSL.
If yes, check whether you can connect to this user using other products, for instance, dbForge Studio for MySQL.

Thanks, I was able to connect Delphi App with the mpSSL settings on Windows -- I had to copy libeay32.dll and ssleay32.dll to the PATH.

However, when i run the Delphi App on iOS device (iphone) I am getting the following error:

"OpenSSL client library couldnt be loaded. Please place libssl.dylib file to system folder (included to LD_LIBRARY_PATH) or to the folder with executable unit of main program. dlopen (libssl.dylib, 1): image not found."

How do we get this resolved?

The OpenSSL library is not installed on iOS devices by default. You should install it to your device by yourself.

This kind of SSL connection error is really very frequent to MYSQL platform in any iOS-based systems like iPhone, iPad or iPods. The users are not capable to reconnect or solve all these issues regarding MYSQL. They can get an actual solution instructed by Apple customer support number that will be fruitful to the users.

You can use MyDAC with SecureBridge components for deployment of applications to iOS and Android mobile devices, since they don't require using third-party libraries. You can find information about connection to MySQL server using SSL in our documentation: https://www.devart.com/mydac/docs/secureconnections.htm