> >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
('abc') WHERE User='root'
-> AND Host='whichever host you want to match';
>-Original Message-
>From: Paul DuBois [mailto:[EMAIL PROTECTED]]
>Sent: Wednesday, June 13, 2001 10:47 AM
>To: David Simcik; Mysql
>Subject: Re: GRANT ANNO
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'
> > >
> > > - th
Sent: 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 th
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 y
On Wed, 13 Jun 2001, Benjamin Pflugmann wrote:
> 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.
> > - da
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@"%"
> -
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_
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 tab
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 '% IDE
'IDENTIFED BY ...' option set the password for your user, ('root' in this
case). Your problem, however, is that the %-sign needs to be protected with
quotes:
mysql> GRANT ALL PRIVILEGES ON *.* TO root@'%' IDENTIFIED BY 'user' WITH
GRANT OPTION;
HTH
~
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 '% IDEN
12 matches
Mail list logo
