add a mysql user

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

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 - $
Gerald_Wall · 24 weeks and 1 day 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 · 23 weeks and 6 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 · 17 weeks and 4 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 · 2 weeks and 5 days 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? 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.


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: