Support to MySQL 8.x
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.
Subject
Written By
Posted
Support to MySQL 8.x
June 21, 2022 12:41AM
Sorry, only registered users may post in this forum.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.