Thanks very much for the reply. Perhaps I did something wrong last time but it seems to work now by following this page:
https://ixnfo.com/en/how-to-change-open_files_limit-in-mysql.html
https://ixnfo.com/en/how-to-change-open_files_limit-in-mysql.html