Re: Granting rights to more hosts, etc

2002-11-12 Thread Paul DuBois
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.

Re: Granting rights to more hosts, etc

2002-11-12 Thread gerald_clark
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'; grant all on database.* to 'user'@'%' identified by 'password'; It tell

Granting rights to more hosts, etc

2002-11-12 Thread Octavian Rasnita
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. How can I use a wildcard in this command? Can I giv