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:
[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 mysql on
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
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, Jonas
Ämne: Re: GRANT problem
thinking.
In one of your follow up posts I see that you have
with % 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
: 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. If I'm reading the manual correctly, you were right about not
hving to specify the host..the only