To create a second user calledadmin2with the same privileges as the administrator, you can use the following statement:
D.CREATE USER admin2 IDENTIFIED BY 'Password'; GRANT ALL PRIVILEGES ON *.* TO admin2 WITH GRANT OPTION;
This creates the useradmin2and grants all privileges, along with the ability to grant those privileges to other users.
[:MySQL User Account Management]
Contribute your Thoughts:
Chosen Answer:
This is a voting comment (?). You can switch to a simple comment. It is better to Upvote an existing comment if you don't have anything to add.
Submit