How to Create a New User in MySQL

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

[darrenhind]

Fantastic tutorial and teaching style, thank you. I'm a novice and was trying to connect a C# app to a local instance using root and getting all kinds of errors, creating a user profile for myself worked seamlessly, thanks again.

[Rokect]

Thanks for sharing. Short and helpful tutorial!

[sayedkazmi]

Thanks for sharing useful and helpful tips

[delta]

1:36 What if I did not get this error and instead got that connection was succesfully made? I got connection and everything seems to work.
Is naming my new user admin is the problem here?

[cherryanns]

Does this work for a user in a network other than my local Network. If not how to do so? Please help

[mrboobs]

watching this at 2am, after spending about 20 hours on a uni project
just figured id let yall know idk

[bast]

If you create a sign in platform, do you know how to create users so they are entered into the database and they can sign in?

[drhurds]

thanks. that helps a lot. may Allah bless you.

[irezgaming_]

I didn't get an error after creating a user, it connected successfuly, is there something wrong or done?

[hangc]

is there not a way to create user through a user friendly GUI?

[TheCtss]

strange it does not create database inside the connection...

[bamideleifeoluwajoshua]

it actually worked at first but couldnt go into my root where i have the schemas....i just lost a data😭😭😭😭😭😭😭😭😭😭.have been try to sign in to my localhost

[Rakshita_Goutam]

Anyone please help me, New User create password koin hai

[Thevolk]

But funny thing is i cant execute any command.

[oubayheot]

if someone wants to give all the priveliges to the new user use this : grant all privileges on *.* to 'username'@'localhost'; And Thank you Database Star for the help.