You will eventually want to create a new user in a MySQL database so you don’t need to use the root account anymore.

Whether you’re running MySQL locally or using it on a server somewhere, you can (and should) create a new user.

In this video, I’ll explain the command to use to create a new user and specify a password, the privileges you need, and how to create a new connection in MySQL Workbench for this new user.

For more information on creating a new user, check out my guide here: https://www.databasestar.com/mysql-create-user/

Timestamps:
00:00 Why create a new user
00:35 The command in MySQL Workbench
01:14 Login as new user
02:05 Give privileges to new user
03:49 Connect as new user and run SQL

/// RESOURCES
Get my free SQL Cheat Sheets for Oracle, SQL Server, MySQL, and Postgres here: https://www.databasestar.com/get-sql-cheat-sheets/
SQL Roadmap: an overview of SQL topics, which is a great place to start: https://www.databasestar.com/sql-roadmap/
Contact me here for questions, sponsorship requests, and more: https://www.databasestar.com/contact/
Want to take your database and SQL skills to the next level? Sign up for Database Star Academy, the online platform for database development and SQL. Check it out here: https://www.databasestar.com/dsa/