[Lazarus] Can't access mysql tables in linux using lazarus

[Michael Van Canneyt]

On Sun, 24 Jun 2018, Larry Dalton via Lazarus wrote:

> I have an application that uses mysql databases. It works perfectly in
> Windows, but not linux. Here is the problem: Mysql57Connection won't apply
> updates correctly in linux. Here are the details:
>
> 1. I am using linux 18.3 Cinnamon 64bit
> 2. I am running lazarus 1.8.2.
> 3. I am using Mysql 5.7
> 4. Some of the tables were created using phpmyadmin.
> 5. Other tables were created from the lazarus application.
> 6. The tables created in phpmyadmin are accessable both for reading and
> writing from the lazarus application.
> 7. The tables created in lazarus are read only in the lazarus application.
> They are read and write both from phpmyadmin.

How do you conclude this ? What errors do you get (if any) ?

> 8.All tables are accessable from the application and phpmyadmin when
> running it on Windows 7.
>
> What do I need to look for?

SQLDB has no knowledge of security settings in the various DB engines.
It just executes SQL statements.

You need to check the security settings for these tables in MySQL.
It could be that phpMyAdmin uses a different user than your program.

The fact that it works differently on linux and windows may point to file
permissions on the table files.

Michael.