[Lazarus] can't connect to Mysql database using TMysql57connection

[larrydalton71 via Lazarus]

Thanks for the help, both of you. After I corrected the mysql installation, it worked. To hook up the Mysql57connection, enter 127.0 0.1 as the hostname to access the UNIX socket.


Sent from my Verizon, Samsung Galaxy smartphone

running mysql in terminal gets ERROR 1045 (28000): Access denied for user
apparently it is using a different password? or case?

Could very well be. MySQL is case sensitive where you don't expect it, and
case insensitive where you don't expect it either... :)

My conclusion - after all this - is that this is not a FPC error, but a
configuration problem on your machine. How to debug this is described on:

https://dev.mysql.com/doc/refman/5.7/en/problems-connecting.html

What I can do from the FPC side is to attempt to get a more
informative/detailed connection error code from the MYSQL server.

Michael.

On Tue, Jun 5, 2018 at 1:55 AM, Michael Van Canneyt via Lazarus <

Project Moneyproject raised exception class 'ESQLDatabaseError ' with

message

'Server Connect Failed'.

Check installed libmysql client version.

The error he gets is the error fpc raises when mysql_connect() fails.
So I think it is something else.
However, to test this, Larry, can you please please test on the command
mysql
Client does not support authentication protocol requested
by server; consider upgrading MySQL client
then you'll know what to do
mysql -u root -p yourpassword -D bankofamerica
Considering you are using a bitnami install, phpadmin may be configured
with some extra parameters.
Michael.
--
_______________________________________________
Lazarus mailing list
https://lists.lazarus-ide.org/listinfo/lazarus

--

[leledumbo via Lazarus]

Project Moneyproject raised exception class 'ESQLDatabaseError ' with

message

'Server Connect Failed'.

Check installed libmysql client version.



--
Sent from: http://free-pascal-lazarus.989080.n3.nabble.com/
--

[Michael Van Canneyt via Lazarus]

Project Moneyproject raised exception class 'ESQLDatabaseError ' with

message

'Server Connect Failed'.

Check installed libmysql client version.

The error he gets is the error fpc raises when mysql_connect() fails.
So I think it is something else.

However, to test this, Larry, can you please please test on the command
line, on the machine where lazarus is running:

mysql

If you see:
Client does not support authentication protocol requested
by server; consider upgrading MySQL client

then you'll know what to do

additionally, can you test what you get with:

mysql -u root -p yourpassword -D bankofamerica

Considering you are using a bitnami install, phpadmin may be configured with some extra parameters.

Michael.
--

[Larry Dalton via Lazarus]

running mysql in terminal gets ERROR 1045 (28000): Access denied for user
'larry'@'localhost' (using password: NO)

running mysql -u root Ricky2013 -D bankofamerica get ERROR 1698 (28000):
Access denied for user 'root'@'localhost'

apparently it is using a different password? or case?


On Tue, Jun 5, 2018 at 1:55 AM, Michael Van Canneyt via Lazarus <

Project Moneyproject raised exception class 'ESQLDatabaseError ' with

message

'Server Connect Failed'.

Check installed libmysql client version.

The error he gets is the error fpc raises when mysql_connect() fails.
So I think it is something else.
However, to test this, Larry, can you please please test on the command
mysql
Client does not support authentication protocol requested
by server; consider upgrading MySQL client
then you'll know what to do
mysql -u root -p yourpassword -D bankofamerica
Considering you are using a bitnami install, phpadmin may be configured
with some extra parameters.
Michael.
--
_______________________________________________
Lazarus mailing list
https://lists.lazarus-ide.org/listinfo/lazarus