User | mysql.r2schools.com

MySQL ERROR 1045 (28000): Access denied for user ‘root’@’localhost’ (using password: YES)

In this article, we will solution for below error.

>MySQL ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)

Solution:
Continue reading MySQL ERROR 1045 (28000): Access denied for user ‘root’@’localhost’ (using password: YES)

ERROR 1698 (28000): Access denied for user ‘root’@’localhost’

In this article, we will see solution for below error.

ERROR 1698 (28000): Access denied for user 'root'@'localhost'

Continue reading ERROR 1698 (28000): Access denied for user ‘root’@’localhost’

How to show user privileges in MySQL

In this article, we will find how to show user privileges in MySQL.

We can check the privileges granted to user in MySQL by using command show grants command.

How to show user privileges in MySQL

Continue reading How to show user privileges in MySQL

How to reset password for user in Azure MySQL Server

In this article, we will see how to reset password for user in Azure MySQL Server. We can reset password for a user in Azure MySQL same as on-premise MySQL server.

We have two methods to reset password for a user in Azure MySQL Server.
1. Using ALTER USER command.
2. By using MySQL Workbench tool.

Reset password for user in Azure MySQL Server using ALTER USER command:

1. Connect to Azure MySQL server and run the below command to reset password for user james.

ALTER USER james@couponmysql IDENTIFIED BY 'James@123';

How to reset password for user in Azure MySQL Server

Reset password for user in Azure MySQL Server using MySQL Workbecnh

1. Connect to Azure MySQL server using MySQL Workbench.
2. Click on Administration tab from left menu.
3. Then click Users and Privileges

4. Then click on a user from the User and Privileges list.

5. Then click on apply.

So in this article, we have seen two different methods (gui and alter user command) to reset password for a user in Azure MySQL Server.

Azure MySQL FATAL Invalid Username specified Please check the Username and retry connection

In this article, we are going to find out solution for below error.

FATAL: Invalid Username specified. Please check the Username and retry connection. The Username should be in format.

Reason for Azure MySQL FATAL Invalid Username specified Please check the Username and retry connection Continue reading Azure MySQL FATAL Invalid Username specified Please check the Username and retry connection

How to connect to Azure MySQL Database with new user from Workbench

In this article, we will see how to connect to Azure MySQL Database with new user from Workbench.

Steps to connect to Azure MySQL Database with new user from Workbench:

1. Connect to Azure portal, then click on Azure MySQL Server. From left menu click on connection security. Then, provide name for your firewall, IP address as show below. Then click on Save.

2. Open MySQL workbench.
3. Click on + symbol as as marked in the below image.
Continue reading How to connect to Azure MySQL Database with new user from Workbench

How to create user in Azure MySQL database

In this article, we will see how create user in Azure MySQL database. We are going to create user in Azure MySQL server by using two ways.

1. Using GUI methods.
2. Using Create user statement.

1. Create User in Azure MySQL Database using Create User command:

Syntax to create MySQL User:
Continue reading How to create user in Azure MySQL database

MySQL ERROR 1819 (HY000): Your password does not satisfy the current policy requirements

In this article we are going to see solution for following error. Which occurs in MySQL when tried to create a user or change the password of MySQL user.

MySQL ERROR 1819 (HY000): Your password does not satisfy the current policy requirements.

MySQL ERROR 1819 (HY000): Your password does not satisfy the current policy requirements

Continue reading MySQL ERROR 1819 (HY000): Your password does not satisfy the current policy requirements

How to find the list of user accounts in MySQL

In this article, we will see how to find the list of user accounts in MySQL.

We dont have command like show databases or show tables to check the list users accounts in MySQL Server. We cant the list of user account using mysql.user table.

Find the list of user accounts in MySQL:
Continue reading How to find the list of user accounts in MySQL

How to Lock and Unlock MySQL User Account

Lock and unlock is administrator day to day activity. ALTER USER privileges required to lock and unlock MySQL Server User. In the following example, we provided the check the status of MySQL User, lock and unlock the User account.

1. Create MySQL User.

CREATE USER harry IDENTIFIED BY 'Harry@321';

2. Check the status of the MySQL Server whether it is locked or not by running the query.
Continue reading How to Lock and Unlock MySQL User Account