hi i have problem in crating user ids and passwords in mysql on linux.do help me out with syntax for it made my job restless deepa
GRANT SELECT, UPDATE, INSERT, WHATEVER ON database.table (could use database.*) TO username@the.host.theyll.be.comming.from (can use username@localhost) IDENTIFIED BY 'password';
That should do the trick
Andreas