Re: mysql 8 file creation issue

I'm not certain, but it doesn't look to me as a MySQL version issue. It's more probably a umask issue. Search for "umask" and you'll probably find the answer. However, it's likely that this is suboptimal and risky. It would probably be better to run `mysql` (or whatever mysql client you are usi

mysql 8 file creation issue

When I run this query on mysql 5.7: SELECT CURDATE() INTO OUTFILE '/var/lib/mysql-files/test.csv'; It creates test.csv with the following permissions: -rw-rw-rw- 1 mysql mysql 11 Mar 18 04:27 test.csv But when I create the same file in mysql 8.0 it creates file with the following permissions