SAM & MySQL are Not Connecting. This is a brand new machine build running SAM v2021.6, MySQL v8.0.27 running as a service. MySQL Workbench 8.0 CE connects to the MySQL Server, samdb database (schema) created manually. OS: Win 11 v21H2 build 22000.434 with latest updates. Processor: 12th Gen Intel Core i7-12700K. MB: MSI MAG Z690, Tomahawk WiFi, DDR4, 32GB RAM. Everything is running on one machine. Other programs running on this machine include Libre Office, Firefox, Norton Security, dB Poweramp, Python 3.10, Tight VNC, Samsung Magician, MSI.CentralServer, MSI TerminalServer, RTKAudUService64, Asus Audio Center, Open Hardware Monitor, One Drive, MySQLWorkbench.
While running SAM Broadcaster Studio Setup:
In the Select Database System window, MySQL was already selected.
Login details for MySQL database: Specify custom settings(already selected)>Access mode: Local Server; Username: root; Database: SAMDB; Remote server settings (default, greyed out): Host: localhost, Port 3306.
Messages after entering all information:
Unable to connect to database. Please make sure the database server is properly installed and running. Also make sure your database login details are correct. Next screen: Failed to create, upgrade or configure database. Please check settings and try again. I’ve gone through this Setup series many times with different adjustments, thinking I had the answer, but no!
I’ve spent several hours every day over the last week searching Google, & FAQs for all 3 systems ending down in Rabbit HOles. I only found one SAM forum topic in the last year that addressed a similar problem. From User dan40, on 12-2-21: The solution is to install MySQL Workbench on my SQL server, and under (server)>“Users and Privileges” add a % sign in the “From Host” box for root and samusr. I placed a % for root user, created samusr account. No Joy. I’ve installed and administered several instances of SAM and MySQL in the last 20 years and thought I was proficient at overcoming problems...
Thank you for considering this problem and any suggestions you can give.