[Lazarus] errno 13 permission denied

[Michael Van Canneyt via Lazarus]

I need to correct my original statement: the column name is 'checking', not
'mycheck'

It am running lazarus 1.8.2 on linux 17.2, and trying to connect to mysql
5.7.
I have a database named 'boa', with 5 columns, the first named 'mycheck';
I am using a TMySql57Connection, named boaconnection with the following
Databasename=boa;
HostName=localhost
KeepConnection=false
LoginPrompt=false
Transaction=boatransaction
UserName=root,
A TSqlTransaction named boatransaction
Database named boaconnection
A TDatasource with DataSet set to BoaQuery
A TSqlQuery named boaquery with the following settings
Database=boaconnection
Transaction=boatransaction
SQL='Select * from Checking
'./boa/checking.frm' (errno: 13-Permission denied).
When I leave boaquery.active set to 'false', and run the program, when I
Project MoneProject raised exception class 'ESQLDatabaseError' with
BoaConnection:Error executing query: Can't read dir of './boa/'
(errno:13-Permission denied)
How can I correct these errors?

These are errors in your MySQL server. They have nothing to do with FPC.
The file permissions on the server are wrong; the server process does not
have sufficient rights to read/write the database files.

Assuming the server is on Linux or BSD, you should find the MySQL
databases directory and execute as root
chown -R mysqld:mysqld boa
(mysqld must be replaced with the username that the mysql server is running
as)

Michael.

Michael.
--