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
