Which command grants or removes other users’ privileges in MySQL?
Question
Which command grants or removes other users’ privileges in MySQL?
Solution
The command that grants or removes other users' privileges in MySQL is the GRANT and REVOKE command.
Here's how to use them:
- GRANT Command: This command is used to give users access to the database. The syntax is as follows:
GRANT privilege_type ON database_name.table_name TO 'username'@'localhost';
In this command, privilege_type is the type of privilege you want to grant (like SELECT, INSERT, UPDATE, DELETE, etc.), database_name is the name of your database, and table_name is the name of your table.
- REVOKE Command: This command is used to take back the access given to users. The syntax is as follows:
REVOKE privilege_type ON database_name.table_name FROM 'username'@'localhost';
In this command, privilege_type is the type of privilege you want to revoke, database_name is the name of your database, and table_name is the name of your table.
Remember to replace 'username'@'localhost' with the actual username and host where the user is connecting from. Also, after executing GRANT or REVOKE commands, you should run the FLUSH PRIVILEGES; command to make sure the changes take effect.
Similar Questions
Which command grants or removes other users’ privileges in MySQL?SUDOSWITCHGRANT OPTIONCHANGE OWNER
Which MySQL command enables a user to delete tables or databases?
Q8.Stored procedures with which of the following option have access privileges that are same as the MySQL user who defined the stored procedure?*1 pointSQL SECURITY DEFINERSQL SECURITY USERSQL SECURITY INVOKERSQL SECURITY CREATOR
QuestionA Linux server administrator wants to elevate their privileges. Which of the following commands makes elevating an account possible? (Select all that apply.)A.suB.passwdC.sudoD.chown
Which action allows the DBA to grant specific privileges to user accounts?Question 1Answera.Privilege revocationb.Account suspensionc.Privilege grantingd.Account creation
Upgrade your grade with Knowee
Get personalized homework help. Review tough concepts in more detail, or go deeper into your topic by exploring other relevant questions.