How to Create a MySQL User on Linux via Command Line

May 11, 2020 Liquid Web

In this video, we describe how to Create a MySQL User on Linux via the Commandline.

Commands used:
mysql -u root -p
create user 'testuser'@'localhost' identified by 'somepassword';
SELECT User,Host FROM mysql.user;

The related article for this article can be found on our KB.

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
How to Add or Remove a PPA in Ubuntu 18.04
How to Add or Remove a PPA in Ubuntu 18.04

In this video, we describe how to add or remove a PPA in Ubuntu 18.04.

Next Video
Importing Databases and Tables with PhpMyAdmin
Importing Databases and Tables with PhpMyAdmin

In this video, we describe how to import databases and tables using PhpMyAdmin.

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

Download Now