How to Create/Rename/Alter/Drop new user in MySQL 8 Database [Practically]

Learn how to use Create, Rename, Alter & Drop user SQL statements to manage users in MySQL 8 database.

After you install MySQL 8 database on your computer, you should learn how to manage users in MySQL database. You can add new MySQL user using create statement. You can rename MySQL user or change MySQL user password using alter statement. And finally you can delete MySQL user using drop statement.

Here, in this tutorial, we will learn these 4 important MySQL commands to manage users on MySQL 8 database. The example covers easy to understand & follow SQL commands. Try the examples practically on your computer and let me know if it works. If you have any doubts or encounter errors or didn't understand something, You can ask me questions in the comments section of this video.

# Chapters #

0:00 Introduction
0:33 View MySQL 8 database uses and their privileges
03:40 Create new user in MySQL 8 database
08:50 Confirm if we are logged in to a specific user account in MySQL
10:27 Assign privileges to newly added users in MySQL 8 database
12:00 MySQL database perform a flush privileges operation
13:41 Rename user name in MySQL 8 database
15:38 MySQL 8 Alter command to change user account password
17:47 Remove or Delete an existing user from MySQL 8 database
19:17 End message, ask questions, like & subscribe

#MySQL8 #Create #Rename #Alter #Drop #Users #PnTutorials

[RABWA]

thanks a lot, quite informative and useful, is it possibel to use this syntax ALTER USER 'ankur' IDENTIFIED BY '123'. , I removed the '@', '%'. ?