Welcome to Software Development on Codidact!
Will you help us build our independent community of developers helping developers? We're small and trying to grow. We welcome questions about all aspects of software development, from design to code to QA and more. Got questions? Got answers? Got code you'd like someone to review? Please join us.
Post History
The easiest way to temporarily disable a MySQL user is to the change the value of the Host column in the mysql.user table to an invalid host. UPDATE mysql.user SET HOST = 'blocked' WHERE #your cond...
Answer
#2: Post edited
by
Charlie Brumbaugh
·
2020-08-31T16:21:42Z (about 4 years ago)
- The easiest way to temporarily disable a MySQL user is to the change the value of the Host column in the mysql.user table to an invalid host.
- ```
- UPDATE mysql.user SET HOST = 'blocked' WHERE #your condition here
- ```
To do this through MySQLWorkbench, go to Management -> Users and Privileges -> Click on the user name and set the 'Limit to Hosts Matching:' field to 'blocked'.- This makes the user unable to connect and is easily reversed.
- The easiest way to temporarily disable a MySQL user is to the change the value of the Host column in the mysql.user table to an invalid host.
- ```
- UPDATE mysql.user SET HOST = 'blocked' WHERE #your condition here
- ```
- To do this through MySQLWorkbench,
- - go to Management
- - Users and Privileges
- - Click on the user name
- - set the 'Limit to Hosts Matching:' field to 'blocked'.
- This makes the user unable to connect and is easily reversed.
#1: Initial revision
by
Charlie Brumbaugh
·
2020-08-31T16:11:16Z (about 4 years ago)
The easiest way to temporarily disable a MySQL user is to the change the value of the Host column in the mysql.user table to an invalid host. ``` UPDATE mysql.user SET HOST = 'blocked' WHERE #your condition here ``` To do this through MySQLWorkbench, go to Management -> Users and Privileges -> Click on the user name and set the 'Limit to Hosts Matching:' field to 'blocked'. This makes the user unable to connect and is easily reversed.