List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:November 13 2002 12:18am
Subject:Re: Granting rights to more hosts, etc
View as plain text  
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

Thread
Granting rights to more hosts, etcOctavian Rasnita12 Nov
  • Re: Granting rights to more hosts, etcgerald_clark12 Nov
  • Re: Granting rights to more hosts, etcPaul DuBois13 Nov