Hi.
I want to GRANT privileges on two tables, but I dont know why error, but on one table it is ok. what is wrong?

GRANT SELECT ON mysql.db, mysql.user TO 'user'@'localhost' IDENTIFIED BY 'password';

I dont know why it is not working on two tables???

Hi.
any idea ???

what is the error message?

hi tanha,

standard SQL only allows one object per GRANT command. Possibly MySql also does not allow enumerative objects. If so, you should try

GRANT SELECT ON mysql.db TO 'user'@'localhost' IDENTIFIED BY 'password';
GRANT SELECT ON mysql.user TO 'user'@'localhost' IDENTIFIED BY 'password';

krs,
tesu

Thanks for the infor ..

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.