add a mysql user

grant all on *.* to 'dba'@'localhost' identified by 'dba123' with grant option;
username is dba and password is dba123

0
By: shantanuo
2020-02-19 10:56:07

What Others Think

It is easy - CREATE USER 'user'@'hostname'; Try this to give it access to the database dbTest: GRANT ALL PRIVILEGES ON dbTest.* To 'user'@'hostname' IDENTIFIED BY 'password'; Here it is works ok - $leadershiptroy.org
Gerald_Wall · 53 weeks and 6 days ago
You can do a lot with PHP and a SQL database. Create a page, like how to write a wikipedia page for your company index.php, and have it access a SQL database. Create a form on your PHP page that users can fill out, which will then be added to the database.
Aniyah · 53 weeks and 3 days ago
You are right PHP and SQL database is so much effective if you make a service for someone do my essay for me that can be so much helpful for the students they can have the best academic writing help and have the best service online in the UK.
Bradley5467 · 47 weeks and 2 days ago
It is too easy to try out the Mysql. it will be very helpful and easy for us to follow this if you could add an example program for this code that you have explained. So that we can also try to add grant permission. cbd benefits
zaiyamariya · 32 weeks and 3 days ago
great content! will recommend this site to my friends breast augmentation huntington beach ca
looneyhans · 25 weeks and 2 days ago
Pondering is SuperbPaper scam? To get an answer, read the review from a person who ordered a paper from their experts and shared the experience.
MonicaSavage · 23 weeks and 1 day ago
thanks again paintersbatonrougela.com
looneyhans · 20 weeks and 5 days ago
thanks for this article! waxingsacramento.com
Killersmile · 20 weeks and 2 days ago
gosh! what a great site! ive been having difficulties understanding this before..laser hair removal thanks for sharing this!
idasanka · 16 weeks ago
guitar lessons reno I think I need more information
yeoyeo · 14 weeks and 2 days ago
love this soo much! pray
sammm · 11 weeks and 2 days ago
Good article, but it would be better if in future you can share more about this subject. Keep posting financial advisor virginia beach
aegyjingoo · 2 weeks and 1 day ago

What do you think?

Any thoughts on this command? Does it work on your machine? Can you do the same thing with only 14 characters?

You must be signed in to comment.

What's this?

commandlinefu.com is the place to record those command-line gems that you return to again and again. That way others can gain from your CLI wisdom and you from theirs too. All commands can be commented on, discussed and voted up or down.

Share Your Commands



Stay in the loop…

Follow the Tweets.

Every new command is wrapped in a tweet and posted to Twitter. Following the stream is a great way of staying abreast of the latest commands. For the more discerning, there are Twitter accounts for commands that get a minimum of 3 and 10 votes - that way only the great commands get tweeted.

» http://twitter.com/commandlinefu
» http://twitter.com/commandlinefu3
» http://twitter.com/commandlinefu10

Subscribe to the feeds.

Use your favourite RSS aggregator to stay in touch with the latest commands. There are feeds mirroring the 3 Twitter streams as well as for virtually every other subset (users, tags, functions,…):

Subscribe to the feed for: