How to Create a New User in MySQL

[@darrenhind9948]

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.

[@DatabaseStar]

Thanks! Glad it helped.

[@mrboobs]

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

[@DatabaseStar]

Thanks for sharing! Glad it helped.

[@Rokect890]

Thanks for sharing. Short and helpful tutorial!

[@DatabaseStar]

Glad it was helpful!

[@sayedkazmi2844]

Thanks for sharing useful and helpful tips

[@DatabaseStar]

No problem!

[@hangc10]

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

[@DatabaseStar]

Yes, you can. You can click on the Administration panel on the left, then Users and Privileges, and add a new user there.

[@felixkimutai8478]

Thank you Sir.

[@DatabaseStar]

You’re welcome!

[@bamideleifeoluwajoshua3642]

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

[@DatabaseStar]

You should be able to sign into the main account still

[@younesselbaz9279]

thank you so much for your effort

[@DatabaseStar]

You’re welcome!

[@Ufgvcewghhjgfhj]

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

[@DatabaseStar]

Thanks!

[@1irezgaming_740]

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

[@DatabaseStar]

Oh that's good, if you got no error then it has worked for you.

[@cherryanns4343]

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

[@DatabaseStar]

This will create a user on the MySQL database, not on the network. If you want someone else to be able to connect to this database server, they can use the existing user or this new user.

[@TheC1tss]

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

[@DatabaseStar]

That's right, a new connection does not automatically create a new database in MySQL.

[@delta4135]

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?

[@DatabaseStar]

If everything works and you didn't get the error then it should be all good!

[@hemantkumardas3333]

Thanks sir 🙏

[@DatabaseStar]

You’re welcome!

[@b3ast324]

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?

[@b3ast324]

Please answer, I am really struggling with this

[@DatabaseStar]

Do you mean, creating some kind of app or website where users can have accounts and sign into their account? You would probably have some kind of users table that has an email address and password (which is stored as encrypted data). The app or website would then have the logic to look up the user details and check the password is correct. Does that answer your question?

[@b3ast324]

@@DatabaseStar Yes thank you so much!

[@Rakshita_Goutam]

Anyone please help me , New User create password koin hai

[@DatabaseStar]

Could you follow this video to create the password for the new user?

[@ayman4318]

Anything about postgresql??

[@DatabaseStar]

Not yet, but I can create a video in the future.

[@Thevol40k]

But funny thing is i cant execute any command.

[@DatabaseStar]

Can't execute any command in MySQL Workbench? Why not? Are you getting an error?

[@oubayheot8843]

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.

[@DatabaseStar]

Thanks for the tip!

[@rain_yy]

THANK YOUTROUTUTRU

[@DatabaseStar]

You're welcome