How do I set file privilege for user of MySQL database in cpanel. I have tried
USE mysql;
UPDATE user SET File_priv = 'Y' WHERE User = 'db_user';
FLUSH PRIVILEGES;
With no success I have tried the code inside the database
Asked
Active
Viewed 467 times
0
Charles Tester
- 165
- 1
- 16
-
Possible duplicate? These are two different questions ! – Charles Tester Jul 28 '16 at 14:56
-
If you tried, put your error message. Error messages are the best way to find the root of the problems – abkrim Jul 29 '16 at 04:56
1 Answers
0
By default Cpanel put on my.cnf local-infile=0
You must put on /etc/my.cnf
local-infile=1
After restart mysql
abkrim
- 3,190
- 7
- 37
- 58