News
Seven days of Black Friday madness — great deal from Serverspace!
Serverspace Black Friday
RF
September 14, 2023
Updated September 13, 2023

How To Remove or Delete a MySQL User Account?

Databases Linux

Introduction

In the modern infrastructure of IT—product, we should use system for operating data: get, pull, update, save, restore and more. For that purpose we can use software which can suggest popular Excel, MySQL, PostgreSQL and etc, but what is the difference between that product?

There exist several compelling rationales for employing databases, even when alternatives such as Excel are available.

  • Scalability: Databases are purpose-built for accommodating extensive datasets. Although Excel can store substantial data, its performance and manageability may deteriorate as the dataset expands.
  • Performance: Databases are optimized for swift data access and retrieval, whereas Excel's performance tends to degrade, especially with sizable datasets.
  • Security: Databases offer robust security features to safeguard data against unauthorized access, a level of protection not found in Excel.
  • Reliability: Databases are engineered for reliability and availability, whereas Excel can be more error-prone and susceptible to data corruption.
  • Flexibility: Databases are versatile, capable of managing a wide array of data types, whereas Excel has limitations regarding the types of data it can handle effectively.
  • Integration: Databases seamlessly integrate with various applications, making them a more suitable choice for integration compared to Excel, which often lacks such compatibility.

In summary, databases provide a multitude of advantages over Excel in terms of scalability, performance, security, reliability, flexibility, and integration. If you need to store and manage substantial volumes of data or prioritize data security and dependability, opting for a database is the superior choice. In that instruction we will consider base action for admin: drop user.

Action for deletion

We will look at the MySQL like already installed software database with admin permission. Firts of all, we need to login into the MySQL system by typing command below:

mysql -u root -p -h localhost
Login
Screenshot №1 — Login

Let's check current state of user in our database system by the command below:

SELECT user, host FROM mysql.user;

And we can see result below, please highlight spelling of syntax in the DBMS, in many of tutorials you can see how to authors write SELECT or SHOW by the capital letters. But it's no matter what type of writing you use SELECT or select. The names of databases, tables and columns depend on the case. Be aware at the moment of typing query. However, we can see table  with our created users.

All users
Screenshot №2 — All users

Let's remove privileges and delete account from DBMS by the two command below:

revoke all on *.* from 'ff'@'localhost';
Revoke
Screenshot №3 — Revoke

And then type that command for deletion account after revoke permission:

drop 'ff'@'localhost';
Drop
Screenshot №4 — Drop

Conclusion

In that instruction we have learned how to delete user in MySQL DBMS! It's important in the evolving landscape of IT, understanding the distinctions between data management tools becomes crucial, ensuring that the right choice is made to meet specific business needs and objectives.

Vote:
4 out of 5
Аverage rating : 4.7
Rated by: 3
1101 CT Amsterdam The Netherlands, Herikerbergweg 292
+31 20 262-58-98
700 300
ITGLOBAL.COM NL
700 300

You might also like...

We use cookies to make your experience on the Serverspace better. By continuing to browse our website, you agree to our
Use of Cookies and Privacy Policy.