Issue: Azure DB MySQL - phpMyAdmin

Question

Issue: Azure DB MySQL - phpMyAdmin

AHMAD HASSAN 256

Hi everyone,

I’ve already set up our WordPress from the marketplace, and the plan is Standard general-purpose production apps (P1V2 1 Core, 3.5 GB RAM, 250 GB storage) including phpMyAdmin but when I try to login domain.com/phpmyadmin required credentials and after entering the credential shows the error Cannot log in to the MySQL server.

Any idea to resolve this issue

User's image

Sai Raghunadh M 4,635 Reputation points Microsoft External Staff Moderator

2024-09-16T12:05:53.77+00:00
Hi @ AHMAD HASSAN,

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

The issue is might be with your password. login to your MySQL server with CLI and update the root password.

To log in to your MySQL server with the CLI, use the following command:

mysql -u root -

To update the root password, use the following command:

SET PASSWORD FOR 'root'@'localhost' = PASSWORD('YOUR NEW PASSWORD HERE');

Please replace 'YOUR NEW PASSWORD HERE' with your desired password.

I hope this information helps, please let us know if you have any further queries.
Sai Raghunadh M 4,635 Reputation points Microsoft External Staff Moderator

2024-09-17T17:09:58.9133333+00:00

Hi @ AHMAD HASSAN,

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 4,635 Reputation points Microsoft External Staff Moderator

2024-09-18T18:37:41.39+00:00

Hi @ AHMAD HASSAN,

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.

Your answer

Sai Raghunadh M 4,635 Reputation points Microsoft External Staff Moderator

2024-09-16T12:05:53.77+00:00

Hi @ AHMAD HASSAN,

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

The issue is might be with your password. login to your MySQL server with CLI and update the root password.

To log in to your MySQL server with the CLI, use the following command:

mysql -u root -

To update the root password, use the following command:

SET PASSWORD FOR 'root'@'localhost' = PASSWORD('YOUR NEW PASSWORD HERE');

Please replace 'YOUR NEW PASSWORD HERE' with your desired password.

I hope this information helps, please let us know if you have any further queries.
Sai Raghunadh M 4,635 Reputation points Microsoft External Staff Moderator

2024-09-17T17:09:58.9133333+00:00

Hi @ AHMAD HASSAN,

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 4,635 Reputation points Microsoft External Staff Moderator

2024-09-18T18:37:41.39+00:00

Hi @ AHMAD HASSAN,

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.

Share via

Issue: Azure DB MySQL - phpMyAdmin

Your answer