MySQL Forums
Forum List  »  General

Support to MySQL 8.x
Posted by: Suresh Anantharam
Date: June 21, 2022 12:41AM

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.

Options: ReplyQuote

Written By
Support to MySQL 8.x
June 21, 2022 12:41AM
June 21, 2022 01:31AM

Sorry, you can't reply to this topic. It has been closed.

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.