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.

Review Suggested Edit

You can't approve or reject suggested edits because you haven't yet earned the Edit Posts ability.

~~How to temporarily disable a MySQL user?~~

How to temporarily disable for all MySQL users except the database administrator(s)?

Sometimes I will need to temporarily lock out other MySQL users when I am making large structure changes and want to make sure that nobody else is inputting or changing the data. The other use case is temporarily locking out a single user if you are sure if that user is being used anymore.

How can I do this without changing the passwords or permissions?

mysql

mysql user-management

Communities

Review Suggested Edit