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 -------- Original message --------From: Michael Van Canneyt via Lazarus <lazarus@lists.lazarus-ide.org> Date: 6/5/18 07:02 (GMT-05:00) To: Larry Dalton via Lazarus <lazarus@lists.lazarus-ide.org> Cc: Michael Van Canneyt <mich...@freepascal.org> Subject: Re: [Lazarus] can't connect to Mysql database using TMysql57connection On Tue, 5 Jun 2018, Larry Dalton via Lazarus wrote: > 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? 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 < > lazarus@lists.lazarus-ide.org> wrote: > >> >> >> On Mon, 4 Jun 2018, leledumbo via Lazarus wrote: >> >> 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. >> >> -- >> _______________________________________________ >> Lazarus mailing list >> Lazarus@lists.lazarus-ide.org >> https://lists.lazarus-ide.org/listinfo/lazarus >> > -- _______________________________________________ Lazarus mailing list Lazarus@lists.lazarus-ide.org https://lists.lazarus-ide.org/listinfo/lazarus
-- _______________________________________________ Lazarus mailing list Lazarus@lists.lazarus-ide.org https://lists.lazarus-ide.org/listinfo/lazarus
