Support to MySQL 8.x

[Suresh Anantharam]

Hello, Currently I'm using MySQL 5.7.x release, and planning to migrate to 8.x. With this I'm planning to have backward compatibility as well. Currently I have DB user creation script which was prepared for 5.7 does not work with MySQL 8.0.

MySQL 5.7.x (User Creation script as below):
CREATE USER 'suresh'@'localhost' IDENTIFIED BY 'suresh';
GRANT ALL PRIVILEGES ON TEST.* TO 'suresh'@'localhost' IDENTIFIED BY 'suresh';
grant select on `mysql`.`proc` to 'suresh'@'localhost';
GRANT FILE ON *.* TO 'suresh'@'localhost';

This creation does not work on 8.x releases, and I want to have backward compatibility as well.

Can someone help me to resovle this issue.