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

[larrydalton71]

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 at lists.lazarus-ide.org> Date: 6/5/18  07:02  (GMT-05:00) To: Larry Dalton via Lazarus <lazarus at lists.lazarus-ide.org> Cc: Michael Van Canneyt <michael at 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 at 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 at lists.lazarus-ide.org
>> https://lists.lazarus-ide.org/listinfo/lazarus
>>
>
-- 
_______________________________________________
Lazarus mailing list
Lazarus at lists.lazarus-ide.org
https://lists.lazarus-ide.org/listinfo/lazarus
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.lazarus-ide.org/pipermail/lazarus/attachments/20180607/1a884438/attachment.html>