<html><head><meta http-equiv="Content-Type" content="text/html; charset=UTF-8"></head><body><div><font face="sans-serif">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.</font></div><div><br></div><div><br></div><div><br></div><div id="composer_signature"><div style="font-size:85%;color:#575757" dir="auto">Sent from my Verizon, Samsung Galaxy smartphone</div></div><div><br></div><div style="font-size:100%;color:#000000"><!-- originalMessage --><div>-------- Original message --------</div><div>From: Michael Van Canneyt via Lazarus <lazarus@lists.lazarus-ide.org> </div><div>Date: 6/5/18 07:02 (GMT-05:00) </div><div>To: Larry Dalton via Lazarus <lazarus@lists.lazarus-ide.org> </div><div>Cc: Michael Van Canneyt <michael@freepascal.org> </div><div>Subject: Re: [Lazarus] can't connect to Mysql database using TMysql57connection </div><div><br></div></div><br><br>On Tue, 5 Jun 2018, Larry Dalton via Lazarus wrote:<br><br>> running mysql in terminal gets ERROR 1045 (28000): Access denied for user<br>> 'larry'@'localhost' (using password: NO)<br>><br>> running mysql -u root Ricky2013 -D bankofamerica get ERROR 1698 (28000):<br>> Access denied for user 'root'@'localhost'<br>><br>> apparently it is using a different password? or case?<br><br>Could very well be. MySQL is case sensitive where you don't expect it, and<br>case insensitive where you don't expect it either... :)<br><br>My conclusion - after all this - is that this is not a FPC error, but a<br>configuration problem on your machine. How to debug this is described on:<br><br>https://dev.mysql.com/doc/refman/5.7/en/problems-connecting.html<br><br>What I can do from the FPC side is to attempt to get a more <br>informative/detailed connection error code from the MYSQL server.<br><br>Michael.<br><br>><br>><br>> On Tue, Jun 5, 2018 at 1:55 AM, Michael Van Canneyt via Lazarus <<br>> lazarus@lists.lazarus-ide.org> wrote:<br>><br>>><br>>><br>>> On Mon, 4 Jun 2018, leledumbo via Lazarus wrote:<br>>><br>>> Project Moneyproject raised exception class 'ESQLDatabaseError ' with<br>>>>><br>>>> message<br>>>><br>>>>> 'Server Connect Failed'.<br>>>>><br>>>><br>>>> Check installed libmysql client version.<br>>>><br>>><br>>> The error he gets is the error fpc raises when mysql_connect() fails.<br>>> So I think it is something else.<br>>><br>>> However, to test this, Larry, can you please please test on the command<br>>> line, on the machine where lazarus is running:<br>>><br>>> mysql<br>>><br>>> If you see:<br>>> Client does not support authentication protocol requested<br>>> by server; consider upgrading MySQL client<br>>><br>>> then you'll know what to do<br>>><br>>> additionally, can you test what you get with:<br>>><br>>> mysql -u root -p yourpassword -D bankofamerica<br>>><br>>> Considering you are using a bitnami install, phpadmin may be configured<br>>> with some extra parameters.<br>>><br>>> Michael.<br>>><br>>> --<br>>> _______________________________________________<br>>> Lazarus mailing list<br>>> Lazarus@lists.lazarus-ide.org<br>>> https://lists.lazarus-ide.org/listinfo/lazarus<br>>><br>><br>-- <br>_______________________________________________<br>Lazarus mailing list<br>Lazarus@lists.lazarus-ide.org<br>https://lists.lazarus-ide.org/listinfo/lazarus<br></body></html>