How do I create a flexible sql Server in my bash terminal? (Terminal Freezes)

Veljko Belic 0

Hello there,
I have an issue creating a flexible sql server in my bash Terminal in VS Code. I am doing the Java module "[Deploy a Spring Boot app to Azure App Service]", the first exercise in this module "Create Azure resources and a java Spring application". Below/Above this text you can see which code I have to copy in my bash shell.

Screenshot 2024-09-04 at 10.09.12

When I enter this code is the output an error which indicates, that I have to migrate to flexible server what you can see on the other screenshot of my terminal. But when I create a flexible server three warnings are printed and the execution stops but ending with nothing it is like freezed (I waited hours but nothing has changed). I also tried it several times but it stops always on the same line.

Screenshot 2024-09-04 at 10.21.22

Hopefully anyone could help me to continue with this exercise.

Sai Raghunadh M 150 Reputation points Microsoft Vendor

2024-09-06T17:57:34.8333333+00:00
Hi@Veljko Belic,

Thanks for the question and using MS Q&A platform.

As you are creating flexible server and you are getting errors, there may be possibilities for few things,

Make sure that you have given correct Resource Group name and that Resource group exists.

Make sure that you have updated version of Azure CLI in your VS code.

Next follow the below steps to create flexible Mysql server in bash terminal using Azure CLI.

Open VS code and then go to Terminals and select Azure CLI (Bash)

The terminal will be set up in VS code and then click on open

After you open, it will redirect to External Azure Portal and you will enter into Cloud shell. Then, you have to login into Azure with command (Az login).

Next click on the device login link and enter the code. (Code will be different for different users).

Next after entering the code, click on Next.

After signing in, close the window,

After you close the sign in window in CLI you will get subscription details. If you want you can select subscription or press "Enter" for no changes.

Enter the details of your own, (Username, Password etc.).

Try changing the location to "West US". So that you may not get any Errors.

After setting up the Location, password, username etc, Press "Enter".

Then, your Mysql flexible server will be created and you can check under resources in resource group.

Click on the Mysql server that you created.

I hope this information helps, please do let us know if you have any Queries.
Sai Raghunadh M 150 Reputation points Microsoft Vendor

2024-09-08T09:38:38.4366667+00:00

Hi@Veljko Belic,

We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. In case if you have any resolution please do share that same with the community as it can be helpful to others. Otherwise, will respond with more details and we will try to help.
Sai Raghunadh M 150 Reputation points Microsoft Vendor

2024-09-09T09:53:04.1066667+00:00

Hi@Veljko Belic,

We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. In case if you have any resolution please do share that same with the community as it can be helpful to others. Otherwise, will respond with more details and we will try to help.
Veljko Belic 0 Reputation points

2024-09-11T08:12:35.99+00:00

Hi there I will try it today and give you information if it succeeded.

UPDATE!

I wanted to choose the right terminal (Azure Cloud Shell Bash) but Visual Studio gave me two errors when I click on the mentioned shell. I hope you can help me further.
Veljko Belic 0 Reputation points

2024-09-12T07:47:03.66+00:00

I tried to create again the flexible server on the cloud shell on Azure portal but again the terminal "freezes".
Sai Raghunadh M 150 Reputation points Microsoft Vendor

2024-09-12T07:53:18.9233333+00:00

Hi @Veljko Belic,

Can you please provide the screenshots?
Sai Raghunadh M 150 Reputation points Microsoft Vendor

2024-09-12T08:44:46.7166667+00:00

Hi @Veljko Belic,

Please give "code ." command in windows PowerShell, it will redirect you to the terminal in vs code.
Sai Raghunadh M 150 Reputation points Microsoft Vendor

2024-09-13T09:15:46.98+00:00

Hi@Veljko Belic,

We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. In case if you have any resolution please do share that same with the community as it can be helpful to others. Otherwise, will respond with more details and we will try to help.
Veljko Belic 0 Reputation points

2024-09-13T12:03:56.1933333+00:00

Hi, I click on new Terminal. Instead of opening a new terminal it just displays this error message.
Sai Raghunadh M 150 Reputation points Microsoft Vendor

2024-09-16T18:22:29.4166667+00:00

Hi @Veljko Belic,

Can you please try uninstalling and reinstalling the Azure Resource Groups extension and make sure all your VS Code extensions are up to date.
Sai Raghunadh M 150 Reputation points Microsoft Vendor

2024-09-17T17:37:34.7866667+00:00

Hi@Veljko Belic,

We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. In case if you have any resolution please do share that same with the community as it can be helpful to others. Otherwise, will respond with more details and we will try to help.
Veljko Belic 0 Reputation points

2024-09-18T06:20:00.8933333+00:00

Hi,

to resolve the issue I uninstalled my VS Code and all Extensions. I installed it again and also the required extensions but the error occurs again. I hope you can provide a way to solve the error. I also do not understand what the error message wants to display.
Sai Raghunadh M 150 Reputation points Microsoft Vendor

2024-09-18T09:52:49.2966667+00:00

Hi @Veljko Belic,

As per the error, the issue is related to permissions, and it is in a private path. please check the Permissions.
Sai Raghunadh M 150 Reputation points Microsoft Vendor

2024-09-19T09:54:41.9466667+00:00

Hi@Veljko Belic,

We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. In case if you have any resolution please do share that same with the community as it can be helpful to others. Otherwise, will respond with more details and we will try to help.