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 488 times
0
CharlieT
- 373
- 4
- 26
-
Possible duplicate? These are two different questions ! – CharlieT 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
1
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,512
- 7
- 43
- 69