Custom my.cnf/local-infile=1 for one user

[xerox]

Hello,

How to give limited access to local-infile=1 for one user only?

I am not sure how to do this with custombuild without future updates issues.

Anyone already know?

Specific commands would be much appreciated.

ThankS

 

[xerox]

I already tried to follow the instructions here:

General MariaDB and MySQL | Directadmin Docs

but, the command eg. "UPDATE mysql.user SET File_priv='Y' WHERE user=blabla" will give me error:

ERROR 1348 (HY000): Column 'File_priv' is not updatable

Note: I have MariaDB 10.4 installed.

UPDATE: For MariaDB 10.4 version, the mysql.user table is changed to mysql.global_priv as the documentation explains, Now, I am not sure how to update the file_priv because the table structure differs from mysql.user table.

@smtalk, could you please explain and update the referenced da documentation?

Thanks.

 

[Zhenyapan]

connect to phpmyadmin using da_admin credentials, use mysql DB, find needed user there and modify it's privileges.

 

[xerox]

Thanks for the idea.

I also tried that in phpmyadmin but I get the same error when i try to change any specific user File_priv column value to Y.

#1348 - Column 'File_priv' is not updatable

Under the Browse tab in phpmyadmin table user, there is an notice on the header:

 Current selection does not contain a unique column. Grid edit, Edit, Copy and Delete features may result in undesired behavior.

I am not sure its related to the issue.

MariaDB documentation:
mysql.user Table - MariaDB Knowledge Base

To point out the update in 10.4, its written that:

MariaDB starting with 10.4
In MariaDB 10.4 and later, the mysql.global_priv table has replaced the mysql.user table, and mysql.user is now a view.

 

[xerox]

Any ideas anyone?

 

[factor]

Not really I googled a bit and found this

access denied for load data infile in MySQL

I use MySQL queries all the time in PHP, but when I try LOAD DATA INFILE I get the following error #1045 - Access denied for user 'user'@'localhost' (using password: YES) Does anyone know what...

stackoverflow.com

I had this problem. I searched around and did not find a satisfactory answer. I summarise below the results of my searches.

The access denied error could mean that:

• 'user'@'localhost' does not have the FILE privilege (GRANT FILE on *.* to user@'localhost'); or,
• the file you are trying to load does not exist on the machine running mysql server (if using LOAD DATA INFILE); or,
• the file you are trying to load does not exist on your local machine (if using LOAD DATA LOCAL INFILE); or,
• the file you are trying to load is not world readable (you need the file and all parent directories to be world-readable: chmod 755 directory; and, chmod 744 file.dat)