MySQL CREATE USER - GRANT Privileges // Tips from a Self Taught Developer

In this tutorial, as a self-taught developer, I explain how to insert a user into the MySQL database, with all privileges required to become a "superuser". I also show you how you can remove the user from the database with the DROP command.
MySQL - CREATE USER with GRANT Privileges in Terminal // Tips from a Self Taught Developer
#mysql #php #programming #SelfTaughtDeveloper #davidsvideos

[@devashishsaxena8354]

just spent half a day searching how to create new user on mysql, but perfected it in minutes from this video. Thank you for your help.

[@thornwebdesign]

Great to hear!

[@Halom8co]

This video is so good, thank you for your help 5 years later!

[@thornwebdesign]

My pleasure

[@enriquedb666]

Thanks so much, i needed to grant PROCESS privileges i didnt know how to doit...saved my day.

[@thornwebdesign]

You're very welcome! I'm thrilled to hear that my tutorial helped you with granting PROCESS privileges and saved your day. 😊
If you have any more questions or if there's anything else related to MySQL or any other topic you'd like to learn about, feel free to ask. Learning and helping each other is what it's all about!

[@lucascortooms3457]

YOU SAVED ME SO MUCH TIME. Thank god i've been looking for 3 hours now. Nice tutorial man.

[@Rac00n]

I know it's an old video but thank you. I just started learning mysql and this helped a ton

[@thornwebdesign]

My pleasure, thanks for the feedback.

[@playboycity]

Thanks that was great you have helped me solve a problem of removing a user which had been bugging me for months

[@dereknugent5897]

Many thanks very handy revision... Very much appreciated!

[@marcopierrefernandezburgos3116]

Thank you for you very explicit instructions.

[@techwithdenzel]

Awesome, I 'm also starting off as self-taught.

[@thornwebdesign]

That's great to hear that you're starting off as a self-taught learner too! It's an exciting journey filled with endless possibilities. 😃
I'm curious to know, what specific area of self-taught learning are you diving into? Are there any particular challenges or topics you're keen to explore, or any resources you've found particularly valuable on your self-education path? Let's chat about your experiences and share insights!

[@nazmulhossain9440]

Thank you very much. I am very happy watched for this video.

[@thornwebdesign]

Thanks for your feedback

[@masny683]

Hi, im from poland, thank you for help me. Love you! really this help me. ;)

[@paracha3]

Very detailed and concise.

[@johnstephengabula5795]

thanks for the video, waiting for a link to the next video

[@thornwebdesign]

Coming soon!

[@yuriyelkin580]

David, thanks!

[@thornwebdesign]

Many thanks

[@ExD3aD]

Thanks so much. God bless you!

[@vishnu4486]

Thanks you very much bro...❤️

[@thornwebdesign]

You're welcome 😊

[@INDIGITALPOINTindigitalpoint]

thank you for your time

[@basilzimba5273]

Well explained. Thank you very much.

[@thornwebdesign]

Thanks for the nice comment, and also for the feedback, I am glad that you liked it.

[@advancewebdevelopment9802]

Super

[@thornwebdesign]

Thanks

[@avocadolujan1072]

Great your contents!! Keep it up!!

[@thornwebdesign]

Your encouragement keeps me going. 🚀

[@aviontics]

good tutorial

[@vinodpal2780]

thank u sir, very much helpfull video

[@mohankrishna3825]

Thank you. You voice is just sounded like Jason Santham.

[@thornwebdesign]

Blimey, cheers for the compliment, mate! You reckon I should audition for the next action flick alongside Jason Statham? 🎬🤣

[@jeremydeubanks]

Extremely helpful. Thank you !

[@saptarshimondal9063]

Thank you very much

[@thornwebdesign]

My pleasure, glad you liked it.

[@bibhutibhusansahoo3350]

Yes, It is helpful. worked for me thanks

[@thornwebdesign]

Glad to hear that

[@mismis3153]

You Just saved me big time thank you very much

[@thornwebdesign]

My pleasure.

[@WolfSolo1]

Thank you a lot for the detailed tutorial and information.

[@thornwebdesign]

My pleasure, thanks for the feedback.

[@GabrielAHOG]

Thank you!

[@thornwebdesign]

Stay tuned for more content, and thanks for being a part of our community!

[@sandwichtube]

Thanks this solved my problem. I’m not sure why all of the websites I visited used different commands that didn’t work.

[@thornwebdesign]

My pleasure.Maybe I should do a new one.

[@ThaReportar]

awesome tutorial ! helped me a lot ! Thanks

[@KoljaMineralka]

You need a separate chapter on best practices for db user administration, when create and use read only user etc or user for use by scripts only

[@thornwebdesign]

Thank you for watching my video on MySQL user administration and for your thoughtful comment. I'm delighted to see your interest in best practices for database user management, including the creation of read-only users and users for script usage.
Your suggestion is a fantastic idea, and I wholeheartedly agree that these topics deserve a dedicated chapter. It's crucial to understand the finer details of user privileges and the secure management of database access. Rest assured, I will be creating a separate chapter to address these best practices, catering to the needs of both beginners and experienced developers.
In the meantime, keep an eye on my channel for more in-depth content on database administration and other related topics. Your input is invaluable, and it motivates me to keep delivering high-quality, informative content.
Thank you for being a part of our learning community, and stay tuned for more insights and tutorials!
Warm regards,
David

[@gilbertgmoney7386]

Thanks for the video. I learned a few things. Will you please do a video where you explain host...local host...etc. I'm confused with that topic. Thanks Again.

[@xicheung7867]

User:james - he's so badass. Lol. Great tutorial.

[@DefinitelyNotAGeek]

very good video, you help me to much :D

[@coolpickings]

learning kali apache2 mysql and hvwa many thanks from a noob :D

[@thornwebdesign]

My pleasure,

[@mohamedrifthy6222]

nice tutorial but your explanation is very fast i couldn't understand but nice. And i have a question can you explain me?
The question is "How to make my database in more secure?" AND what are the security types in MySQL database?

[@katon361]

thank you very much!!!

[@thornwebdesign]

My pleasure

[@BC99]

Thanks

[@thornwebdesign]

Your welcome

[@briandacallos4234]

thanks it really helped me !

[@thornwebdesign]

My pleasure

[@nawin00001]

I like this video david thank you

[@danz5760]

THANK YOU!

[@thornwebdesign]

My pleasure

[@VaheGharibyan]

I am looking for a topic about privileges. Is it possible to set grant privileges for a column ?
From a user dependencies, sql return not all columns.
Like a table grant api * . * , is possible set column privileges like that * . * . *

[@carlosgaleanohn]

TY your video help me so much!

[@thornwebdesign]

Thanks for the feedback, it's my pleasure.

[@smitachoudhuri8924]

thank you.

[@thornwebdesign]

Thank you very much for the feedback.

[@dominiclapitan8466]

This is so helpful. Thank you!

[@thornwebdesign]

My pleasure

[@Matthew.1994]

how can i let others outside from my internet (not LAN, just via internet) connect to the database? they always tget that they are not allowed to connect. how can i make a global user where all people, that i give my programm (created with visual studio), can connect ?

[@lualsilva]

Hi, im from Brazil, thank you help me with: "error 1410 (4200): you are not allowed to create a user with grant"

[@DennisAllard]

Apparently if you do not supply the -u option to the mysql command, the default value is the user name of the logged-in OS user?

[@thornwebdesign]

That's correct

[@rajatsaha891]

Hi David,
When I'm trying to GRANT ALL to a new user created, from root it's showing "You are not allowed to create a user with Grant". Can you help?

[@thornwebdesign]

Maybe this could help?
stackoverflow.com/questions/50177216/how-to-grant-all-privileges-to-root-user-in-mysql-8-0

[@gingerbreadman3108]

what if my terminal says that mysql dosent exist?

[@batmandarknite3972]

thank you :)

[@MartinKangPlus]

thanks

[@niiadjeisowah]

Hello @david, after creating the user, how do you set the password ?

[@naxbinkhan9346]

idenified by 'password'

[@baltazar0007]

password was the password he made

[@thornwebdesign]

sorry for the late response. Either way thanks for the feedback and sorry for not answering, I hope that you found the answer.

[@yesmangunera9574]

ERROR 1133 (42000): Can't find any matching row in the user table

[@thornwebdesign]

Hmm,

[@the_abduvakhob]

class

[@thornwebdesign]

very grateful for your thoughts.

[@jeetu7459]

ERROR 1044 (42000): Access denied for user ''@'localhost' to database 'david_home'

[@ThePerrocraft]

Check username and password.
quote:
"mysql -udavid -p"
Enter your password:"yourpasswordhere"

[@mkhan6021]

Can database root user change password for David?

[@thornwebdesign]

The root user or any user can do everything if it has the correct grant privileges.

[@BlueSpirit006]

Could someone tell me how to connect with this terminal to another hosting

[@thornwebdesign]

Could you explain it a bit further. Do you mean how to connect to a remote mysql server with a terminal?

[@BlueSpirit006]

I mean i have a game hosting, it's called samp and it works with mysql and it's has it's own base and everything

[@vilenationgaming]

I followed this and it appears that I was able to add a user and set permissions (not sure how to view permissions) but when I try to log into the workbench with the new user account I get Access Denied for user 'username'@'servername' (using password: YES). Can you help?

[@thornwebdesign]

Yes, watch the video again

[@vilenationgaming]

@@thornwebdesign I did. Still getting error.
WHen using select host, user from mysql.user; I see the user and when using SHOW GRANTS FOR 'USER'@'localhost'; I see the permissions.
But when trying to access the MYSQL workbench GUI, I get the error above.

[@georgev1980]

how would i view password of a user in mysql

[@mobiletraderkpk]

select user,password from mysql.user;

[@naxbinkhan9346]

select authentication_string from mysql.user ;
but the password is in increpted form

[@kabiras.2274]

thanksssss

[@Cimex090]

what's the password for mysql -p ?

[@scherezade-sdh4168]

+Cimex090 If you're using XAMPP, just set it manually.

[@chaweb1234]

doesnt work

[@thornwebdesign]

What exactly does not work?

[@Mocka-yf4ez]

lots of adds

[@thornwebdesign]

Not going to apologise for it, but the bills have to get paid. Watch all my videos will help. Thanks for the feedback.

[@ollyonearth]

Thanks so much. God bless you!

[@avocadolujan1072]

Great your contents!! Keep it up!!

[@thornwebdesign]

I'm here to help, and your feedback is greatly appreciated.