There are precedence rules and these are discussed in the manual.
http://dev.mysql.com/doc/mysql/en/Connection_access.html
Since you are granting at the database level you will see the changes in the
db table and not the user table.
-Original Message-
From: Cam
To: Mysql List
Sent: 7/30/04
[EMAIL PROTECTED] wrote:
> hi,
> I am having problems with mysql.
> 1. I downloaded mysql on to my system.
> 2.installed it
> 3. ran the server using the command prompt
> C:\mysql\bin\mysqld --console
> it gave me the results that i could start using the service.
> 4. i started mysq
e all set.
>
> Nat
>
> -Original Message-
> From: Rory McKinley [mailto:[EMAIL PROTECTED]
> Sent: Thursday, October 23, 2003 6:21 AM
> To: Datatal AB - Gauffin, Jonas
> Cc: [EMAIL PROTECTED]
> Subject: Re: GRANT problem
>
>
> Ok.
>
> I'm stumped
as host, so specify localhost for you user,
and you should be all set.
Nat
-Original Message-
From: Rory McKinley [mailto:[EMAIL PROTECTED]
Sent: Thursday, October 23, 2003 6:21 AM
To: Datatal AB - Gauffin, Jonas
Cc: [EMAIL PROTECTED]
Subject: Re: GRANT problem
Ok.
I'm stumped.
Sent: Thursday, October 23, 2003 12:05 PM
Subject: SV: GRANT problem
it works if I specify the host. Why doesn't % work as host?
> -Ursprungligt meddelande-
> Från: Rory McKinley [mailto:[EMAIL PROTECTED]
> Skickat: den 23 oktober 2003 11:56
> Till: Datatal AB - Gauffin, Jo
Hi Jonas
Not sure if this will help - in your GRANT statement do you not need to
specify a host for the user e.g. GRANT.. to datatal @
your_host_name.?.
Rory McKinley
Nebula Solutions
+27 82 857 2391
[EMAIL PROTECTED]
"There are 10 kinds of people in this world,
those who understand bina
