WHERE user = 'doe' and host = 'localhost' Ĭode language: SQL (Structured Query Language) ( sql ) B) Using MySQL RENAME USER to rename multiple user accounts exampleįirst, create two user accounts and CREATE USER BY 'Super!pass1' Third, query data from the er to verify the rename: SELECT host, user FROM er ![]() Second, use the RENAME USER to rename user RENAME USER language: SQL (Structured Query Language) ( sql ) A) Using MySQL RENAME USER to rename one user exampleįirst, create a new user called CREATE USER BY 'Super!pass1' Let’s take some examples of using the MySQL RENAME USER statement. If you rename the old user, then you will get an error if you execute the stored procedure. And this stored procedure executes in the definer security context. However, it does not drop or invalidate database objects that are dependent on old users.įor example, assuming that you have a stored procedure whose the DEFINER attribute specifies the old user. The RENAME USER transfers all privileges of the old users to the new users. If you want to rename multiple user accounts at once, you use the following syntax: RENAME USER The new name must not exist or you will get an error. Second, specify the new user name after the TO keyword. ![]()
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |