1

I'm using Amazon Aurora Serverless MySQL cluster(MySQL 5.7) and I want to change the value of global variable default_authentication_plugin which is currently set to default ie. mysql_native_password

These are the commands I'm using to update the default authentication plugin

SET GLOBAL default_authentication_plugin = 'sha256_password'; 
SET @@GLOBAL.default_authentication_plugin = 'sha256_password';

I'm getting below error

enter image description here

From documentation, I can see the default_authentication_plugin is not a dynamic variable. enter image description here

Also, I have checked in the DB Cluster Parameter group it's not available there as well.

How do I change the value of default_authentication_plugin in this case. Can someone help me?

This question cannot be duplicate of How to change read-only permission to set new value of MySQL server system variable as I'm using Amazon Aurora Serverless where user don't have access to the config files of mysql

Vishal
  • 639
  • 7
  • 32
  • @shadow Can you please help me reopen the issue? My use-case is different than the question against which my question is marked as duplicate. User don't have access to file system incase of Amazon RDS Aurora Serverless – Vishal Jan 09 '21 at 13:36
  • Changed the duplicate target for a aws specific one. However, you are really on the wrong Q/A site, since SO is about programming, not about configuring databases. The dba sister site of SO is suitable for your question. – Shadow Jan 09 '21 at 14:05

0 Answers0