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

[Larry Dalton via Lazarus]

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.
8.All tables are accessable from the application and phpmyadmin when
running it on Windows 7.

What do I need to look for?

[Michael Van Canneyt via Lazarus]

Post by Larry Dalton via Lazarus
I have an application that uses mysql databases. It works perfectly in
Windows, but not linux. Here is the problem: Mysql57Connection won't apply
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) ?

Post by Larry Dalton via Lazarus
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.
--