At 17:46 +0200 11/12/02, Octavian Rasnita wrote:
>Hi all,
>
>I've seen the following command line in a MySQL book, but it doesn't work on
>my computer running MySQL 3.2 on Windows 2000:
>
>grant all on database.* to user@% identified by 'password';
>
>It tells me that there is an error in this command.
What error?
Try placing the % character in quotes:
grant all on database.* to user@'%' identified by 'password';
>
>How can I use a wildcard in this command?
>Can I give access for more users with a single command?
>
>Thank you.
>
>Teddy,
>Teddy's Center: http://teddy.fcc.ro/
>Email: orasnita@stripped