2 messages in com.mysql.lists.mysqlRe: Privileges
FromSent OnAttachments
Enrique Gonzalvo09 Mar 2000 11:06 
sin...@mysql.com10 Mar 2000 06:02 
Subject:Re: Privileges
From:sin...@mysql.com (sin@mysql.com)
Date:03/10/2000 06:02:46 AM
List:com.mysql.lists.mysql

Enrique Gonzalvo writes:

I'm trying to set privileges to a user this way: grant all privileges on database_name to name@"%" identified by 'pass' with
grant option and I get the error: parse error near '@'%' identified by 'pass' with grant option What's the problem?

Hi!

GRANT syntax in MySQL for database privileges requires specifying tables.

If you want to grant the same rights for all tables, run this command:

grant all privileges on database_name.* to name@"%" identified by 'pass' with grant option

Regards,

Sinisa

+----------------------------------------------------------------------+ | TcX ____ __ _____ _____ ___ == mys@tcx.se | | /*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Sinisa Milivojevic | | /*/ /*/ /*/ \*\_ |*| |*||*| mailto:sin@mysql.com | | /*/ /*/ /*/\*\/*/ \*\|*| |*||*| Larnaka, Cyprus | | /*/ /*/ /*/\*\_/*/ \*\_/*/ |*|____ | | ^^^^^^^^^^^^/*/^^^^^^^^^^^\*\^^^^^^^^^^^ | | /*/ \*\ Developers Team | +----------------------------------------------------------------------+