CODEWITHSUNDEEP
mysqlsqldatabasesql-grantuser-data
R J.
R J.

Reputation: 1542

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

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

Upvotes: 6

Views: 4174

Answers (1)

jimp
jimp

Reputation: 17477

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.

Upvotes: 7

Related Questions