question

DiegoFerreira-6356 avatar image
0 Votes"
DiegoFerreira-6356 asked OuryBa-MSFT commented

problem with setting require_secure_transport=OFF

When i try to insert data into my table using node JS, i get a response telling me that i need to have global require_secure_transport=OFF.
When i try to run the query: "set global require_secure_transport=OFF", i get the error: Error Code: 1227. Access denied; you need (at least one of) the SUPER privilege(s) for this operation.
When i run the query: "GRANT CREATE ROUTINE ON mydb. TO 'someuser'@'somehost'" ,i get the error: "GRANT CREATE ROUTINE ON mydb. TO 'someuser'@'somehost'"
I've been trying to solve this issue for 3 days, ans I would appreciate help.

azure-database-mysql
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

OuryBa-MSFT avatar image
0 Votes"
OuryBa-MSFT answered OuryBa-MSFT commented

Hi @DiegoFerreira-6356 Welcome to Microsoft Q&A and Thank you for posting your question.
Error Code : 1227
Access denied; you need (at least one of) the SUPER privilege(s) for this operation.

For single server, you will need to disable SSL from portal. For flexible server, you will need to set require_secure_transport server parameter to OFF.



Regards,
Oury

· 2
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi @DiegoFerreira-6356 , Please see my comment above. Let me know if you need further assistance or have additional queries.
Regards,
Oury

0 Votes 0 ·

Hi @DiegoFerreira-6356 , Please see my comment above. Let me know if you need further assistance or have additional queries.
Regards,
Oury

0 Votes 0 ·