How to put a password on a specific mysql database?

V

vasIvas2015-10-04 15:50:46

MySQL

vasIvas, 2015-10-04 15:50:46

I can't understand the following. I have a mysql server that I am connecting to -
> mysql -u root
I connected and created some_db database. And now how to set a password with a login and privileges on this some_db? How to do it via console?

Reply

Answer the question

In order to leave comments, you need to log in

2 answer(s)

D

Dimonchik, 2015-10-04
@vasIvas

in general, https://xakep.ru/2009/06/02/48406/
but for your question, most likely, https://www.digitalocean.com/community/tutorials/m...

R

Ruslan Fedoseev, 2015-10-04
@martin74ua

in mysql, the password is not assigned to the database, but to the user. And already the user is given certain access to the database, perhaps more than one. And more than one user can access the database.
Here's how the one who has the GRANT right to the base will say - it will be so. By default, only root has access.