Terry,
mysql>>GRANT ALL ON Security.* to [EMAIL PROTECTED] Identified by
> 'password';
> Query OK, 0 rows affected(0,00 sec)
Try to rewrite that as follows:
GRANT ALL ON Security.* TO 'newbuddy'@'network.srv' ...
The dot in "network.srv" could otherwise cause problems. After
granting, do:
SHOW
12:57 PM
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Subject: Re: Permission Setup
Dear Stefan,
Sorry for incomplete information and also thank you for your help.
Here is the recent condition ..
---
mysql>status;
-
mysql V
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Terrance Win wrote:
Dear Stefan,
Sorry for incomplete information and also thank you for your help.
Here is the recent condition ..
---
mysql>status;
-
mysql Ver 12.18 Distrib 4.0.
L PROTECTED]>
Reply-To: Stefan Hinz <[EMAIL PROTECTED]>
To: "Terrance Win" <[EMAIL PROTECTED]>
CC: [EMAIL PROTECTED]
Subject: Re: Permission Setup
Date: Tue, 25 Mar 2003 21:00:00 +0100
Terry,
> I 've a problem with permission setup. In my newly install MySQL
&
Terry,
> I 've a problem with permission setup. In my newly install MySQL
> server; First, I log into as 'root' and create a database, lets say 'myDB'.
> Then I Grant a user name 'admin' with password to that database'myDB' in
>
Dear Experts,
I 've a problem with permission setup. In my newly install MySQL
server; First, I log into as 'root' and create a database, lets say 'myDB'.
Then I Grant a user name 'admin' with password to that database'myDB' in
hostname &#
