Skip to content

Tag: azure

Microsoft Azure database admin user creation

I deployed azure MySQL 5.7 database in azure. I can’t create another admin user with admin permission with the serveradmin login. When I tried below command GRANT ALL PRIVILEGES ON . TO ‘sammy’@’localhost’ WITH GRANT OPTION; I am getting error serveradmin@ip don’t have enough permissions even though I am user server admin login. Is this because of Microsoft Azure database

Why Synapse is not working with my query?

I’m trying to use a query in Synapse Analytics from Azure, and when I use it I got the next error: at Source ‘AgenciesInventoryQueryFromSynapsestg’: Parse error at line: 1, column: 47: Incorrect syntax near ‘WITH’. That’s weird for me cause I tested the query in Microsoft SQL Server Management before to add it to Synapse, and it works perfectly