In mysql_create_db (in sql/sql_db.cc), a new directory is created with mode
0700. Is this intentional? It seems to me like the mode should be either
711 or 755, since the table files inside each database directory are
world-readable, but can't be accessed due to directory permissions.
My MySQL server needs to be backed up over a network, but the NFS-mounted
directories won't allow my backup script to read the database files until I
go in and change each directory to world-executable by hand.
Is this an oversight or an intentionally strict security model? If the
former, then I think that the directories should be created with mode 755.
If the latter, then the .ISD, .ISM, and .frm files should be created with