On Sat, 15 Jun 2002, Sergey Bondar wrote: > OS Linux Red Hat 7.2 > MySql 3.23.41 > > Hi All! > That is my steps. > > With root privileges > I doing: > GRANT ALL ON mydb.* TO client@localhost identified by "pwd"; > I got: > OK
The user needs the file privilege. Granting all on mydb.* does not give this privilege because the file privilege is a global privilege. To do this: GRANT FILE ON *.* TO... This will give the user access to files on the server, so you may want to think twice about giving them this privilege. http://www.mysql.com/doc/G/R/GRANT.html Regards, Jason [EMAIL PROTECTED] --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php