📝 Get my free SQL Cheat Sheets: [ Ссылка ]
🎓 Master SQL Fundamentals: [ Ссылка ]
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.
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
