• Home >>
  • MySQL 8 Native Password Support

MySQL 8 Native Password Support

Many users upgrading to MySQL 8 encounter connection issues with SAM Broadcaster Pro due to updated authentication protocols. By default, MySQL 8 uses caching_sha2_password, which is more secure but not compatible with SAM Broadcaster Pro’s legacy authentication mechanism.

Fortunately, there’s a solution: switching to native password authentication. Here’s how to do it step-by-step.

 

✅ Prerequisites
  • MySQL 8 installed and running
  • Administrative access to MySQL
  • SAM Broadcaster Pro (latest version recommended)

🔐 Replace samuser, localhost, StrongPassword123!, and samdb with your actual username, host, password, and database name.

🔧Step 1: Create a MySQL User with Native Password

  • Log in to MySQL as root (or a user with admin privileges).
  • Create your user and assign native password authentication: 
				
					CREATE USER 'samuser'@'localhost' IDENTIFIED WITH mysql_native_password BY 'StrongPassword123!';
  • Grant the necessary privileges: 
				
					GRANT ALL PRIVILEGES ON samdb.* TO 'samuser'@'localhost';
  • Refresh the access rights 
				
					FLUSH PRIVILEGES;

🔁 Step 2: Verify the Authentication Method

  • Check the plugin: 
				
					SELECT user, host, plugin FROM mysql.user WHERE user = 'samuser';

Expected result:

user host plugin
samuser
localhost
mysql_native_password
  • If the plugin is caching_sha2_password, update it manually: 
				
					ALTER USER 'samuser'@'localhost' IDENTIFIED WITH mysql_native_password BY 'StrongPassword123!';

🛠 Step 3: Configure SAM Broadcaster Pro

  • Launch SAM Broadcaster Pro.
  • Go to Config → Database Setup.
  • Enter:
  • Host: localhost or your server IP
  • Port: 3306 (default)
  • Database: samdb
  • Username: samuser
  • Password: StrongPassword123!
  • Test the connection settings and save your settings.

🧠 Extra Tips

  • ✅ Use a strong password, and avoid using root credentials.
  • 🔐 Set firewall rules to only allow trusted IPs if connecting remotely.
  • 💾 Back up your database before performing user changes.

📌 Conclusion

While SAM Broadcaster Pro doesn’t natively support MySQL 8’s default authentication, switching to mysql_native_password is a safe and effective workaround. By following the steps above, your broadcasting setup can remain stable and secure while benefiting from MySQL 8’s performance improvements.

SPACIAL