is there a way to set password for each db in MySQL?

Question

Is there a any way to set password for each database in MySQL server . if there , give some suggestions.

Crowell

passwd for db or passwd for user ? – Androcles

you have the answer from Jimp – Androcles

Answer 1

You cannot set passwords on MySQL databases. You can set passwords for users with privileges granted per database, table, etc.

CREATE USER Syntax

CREATE USER 'jeffrey'@'localhost' IDENTIFIED BY 'mypass';

GRANT Syntax

GRANT ALL ON db1.* TO 'jeffrey'@'localhost';
GRANT SELECT ON db2.invoice TO 'jeffrey'@'localhost';
GRANT USAGE ON *.* TO 'jeffrey'@'localhost' WITH MAX_QUERIES_PER_HOUR 90;

That should help get you started.

Able