Thank you all for your original suggestions, but I'm still having problems.
I copied this verbatim from the MySQL docs and tried it on two seperate
servers:
mysql GRANT ALL PRIVILEGES ON *.* TO monty@%
-IDENTIFIED BY 'some_pass' WITH GRANT OPTION;
ERROR 1047: Unknown
Hello.
Only a minor correction:
On Tue, Jun 12, 2001 at 09:35:19PM -0230, [EMAIL PROTECTED] wrote:
[...]
GRANT ALL ON 'database'.'table' TO 'user'@'host' IDENTIFIED BY 'password'
- the PRIVILEGES keyword is redundant.
- database can be * for all databases.
- table can be * for all tables
Thank you all for your original suggestions, but I'm still having problems.
I copied this verbatim from the MySQL docs and tried it on two seperate
servers:
mysql GRANT ALL PRIVILEGES ON *.* TO monty@%
-IDENTIFIED BY 'some_pass' WITH GRANT OPTION;
ERROR 1047: Unknown command
At 10:16 AM -0500 6/13/01, David Simcik wrote:
Thank you all for your original suggestions, but I'm still having problems.
I copied this verbatim from the MySQL docs and tried it on two seperate
servers:
mysql GRANT ALL PRIVILEGES ON *.* TO monty@%
-IDENTIFIED BY 'some_pass'
Hello.
On Wed, Jun 13, 2001 at 10:16:36AM -0500, [EMAIL PROTECTED] wrote:
Thank you all for your original suggestions, but I'm still having problems.
I copied this verbatim from the MySQL docs and tried it on two seperate
servers:
mysql GRANT ALL PRIVILEGES ON *.* TO monty@%
-
described on page 421 of your book to get around that.
-Original Message-
From: Paul DuBois [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, June 13, 2001 10:47 AM
To: David Simcik; Mysql
Subject: Re: GRANT ANNOYANCE REVISITED
At 10:16 AM -0500 6/13/01, David Simcik wrote:
Thank you all for your
: Wednesday, June 13, 2001 11:15 AM
To: David Simcik
Cc: Mysql
Subject: Re: GRANT ANNOYANCE REVISITED
Hello.
On Wed, Jun 13, 2001 at 10:16:36AM -0500, [EMAIL PROTECTED] wrote:
Thank you all for your original suggestions, but I'm still having
problems.
I copied this verbatim from the MySQL docs
Hi.
On Wed, Jun 13, 2001 at 02:55:07PM -0230, [EMAIL PROTECTED] wrote:
On Wed, 13 Jun 2001, Benjamin Pflugmann wrote:
On Tue, Jun 12, 2001 at 09:35:19PM -0230, [EMAIL PROTECTED] wrote:
[...]
GRANT ALL ON 'database'.'table' TO 'user'@'host' IDENTIFIED BY 'password'
- the PRIVILEGES
Trying to grant super-user level permissions on my root account, but I keep
getting back an error:
mysql GRANT ALL PRIVILEGES ON *.* TO root@% IDENTIFIED BY 'user' WITH GRANT
OPTION;
ERROR 1064: You have an error in your SQL syntax near '% IDENTIFIED BY
'user' WITH GRANT OPTION' at line 1
What
At 5:25 PM -0500 6/12/01, David Simcik wrote:
Trying to grant super-user level permissions on my root account, but I keep
getting back an error:
mysql GRANT ALL PRIVILEGES ON *.* TO root@% IDENTIFIED BY 'user' WITH GRANT
OPTION;
ERROR 1064: You have an error in your SQL syntax near '% IDENTIFIED
On Tue, 12 Jun 2001, David Simcik wrote:
Trying to grant super-user level permissions on my root account, but I keep
getting back an error:
mysql GRANT ALL PRIVILEGES ON *.* TO root@% IDENTIFIED BY 'user' WITH GRANT
OPTION;
ERROR 1064: You have an error in your SQL syntax near '%
11 matches
Mail list logo