Member Avatar for tanha

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???

  • 3 Contributors
  • 4 Replies
  • 84 Views
  • 1 Week Discussion Span
  • Latest Post Latest Post by tanha
Member Avatar for tanha

Hi.
any idea ???

Member Avatar for mwasif

what is the error message?

Member Avatar for tesuji

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

Member Avatar for tanha

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.