11/8/2023 0 Comments Mysql delete user syntaxDelete a User from an Ubuntu Server in Just 3 Steps.How to Delete User Account In Ubuntu?.You can run the SELECT query on the “ er” table to view the updated users and their hosts. Upon completion of the aforementioned steps, you can see that I have deleted an active user from the MySQL server. user: Name of the database table to run the query. FROM: Indicates the table name to run SQL.User, Host: Column names selected from the specified table.SELECT: Query to view data from MySQL tables.Now, log in to your root user account of MySQL server using the command below. You can follow the steps below to do the same. To do so I will retrieve the hostname of the corresponding user from the MySQL User Table called “ er”. In this example, I will delete the MySQL user named “ jerry”. Then you can run the “ DROP USER” SQL command along with the desired username and its hostname. To delete an idle MySQL user from Ubuntu, you will need to log in to the MySQL server as the MySQL root user. Case 01: Delete an Idle MySQL User Account in Ubuntu In this section, I will demonstrate both cases of deleting MySQL users in Ubuntu. Secondly, you may need to remove a user whose process is currently running or who is logged in/ active on the server. Firstly, you may want to delete an idle user available on the server. While deleting the MySQL users, you may come across two cases. The command will drop the corresponding user information row from MySQL’s user table which will result in removing the user from the server. Once you have access to the server you can remove available users using the basic SQL command DROP USER. Deleting a MySQL user in Ubuntu requires logging in to the MySQL server as the server’s root user.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |