Getting Mysql to work with Ruby and installing gem

I am trying to get ruby to work with MySQL. I am having trouble getting the gem to install. Ruby version is 2.7.5 and Rails is 6.0.4.6. The editor if Visual Studio on a Windows machine. The gem is mysql2, but if there is something better that would be OK.

Any suggestions.

Is more information needed, or does no one have any idea?

Hi nealrm!
Could you provide more details about the error you’re getting?

Thanks for the reply. Wasn’t sure if anyone was going to help.

For the mysql2 I kept getting installation errors. Since it’s been a month, I no longer have the exact wording.
I also tried ruby-mysql. For that gem I kept getting errors relating to Unix. Since I am on a Windows machine, I didn’t continue on.