I’ve been trying to connect OMNI to MySQL but I think the documentation is for MySQL prior to 9.0 because the internet is saying you cannot GRANT permissions in the newest version of MySQL. Has anyone else had the same issue?
Hey @sam_p where are you seeing that you can’t use GRANT / are you getting an error when trying the recommended commands? I see GRANT used in the docs for MySQL 9.0 here. We haven’t had other reports of this issue so would love to understand what you’re running into and help figure this out!
Hi Anika! Thanks for getting back to me. After further research, it seems that the use of ‘mysql_native_password’ was removed in MySQL 8.0 and replaced with caching_sha2_password. According to what I could find, mysql_native_password is no longer loaded in automatically and there was no easy workaround that I could find. However, I was able to create a user by entering:
CREATE USER ‘omni’ IDENTIFIED BY ‘’;
in the MySQL terminal. Maybe it’s just an issue on my end but I’m surprised no one else has run into the same error.
Currently, I’m just waiting on my Free Trial to get approved. I’m a student and want to get familiar with the OMNI environment 
That’s helpful feedback on the docs there, thank you!