How to Remove Permissions for a MySQL User on Linux via the Command Line

April 1, 2020 Liquid Web

In this video, we describe how to remove permissions for a MySQL user via the Linux command line.

Commands used:
mysql -u root -p
show grants for "testuser'@'localhost';
revoke create on *.* from "testuser'@'localhost';
flush privileges; 

The related article for this article can be found here: https://www.liquidweb.com/kb/remove-permissions-for-a-mysql-user-on-linux-via-command-line/

For more information about this and other topics, visit us at https://www.liquidweb.com/kb/ or
to learn more about our Dedicated server offerings, visit: https://www.liquidweb.com/products/dedicated/

Video by: Justin Palmer

About the Author

Liquid Web

Liquid Web powers online content, commerce, and potential for SMB entrepreneurs and the designers, developers and digital agencies who create for them. Sign up for our newsletter to stay up to date with our latest content.

More Content by Liquid Web
Previous Video
Change a Password for PostgreSQL on Linux via Command Line
Change a Password for PostgreSQL on Linux via Command Line

In this video, we describe how to change a password for PostgreSQL in Linux via the command line.

Next Video
How to Remove a MySQL User on Linux via the Command Line
How to Remove a MySQL User on Linux via the Command Line

In this video, we describe how to remove a MySQL user on Linux via the command line.

Learn What Qualities to Look for in Your Next Host in Our New Guide!

Download Now