GRANT ALL error - newbee

I'm attempting to set up a Linux Apache Mysql PHP (LAMP) system for the
first time. On my internal network (behind firewall) I have a computer
(cruncher) that is acting as the web server. Another computer
(supercrunch) is being used as the home for Dupal6. I connected to the
cruncher system from supercrunch with "mysql -u root -h cruncher -p".
This seemed to work fine. But, one of the setup statements follows along
with the result. I can't find the error. Help!

mysql> GRANT ALL PRIVILAGES ON *.* TO 'gary@supercrunch' IDENTIFIED BY
'' WITH GRANT OPTION;
ERROR 1064 (42000): You have an error in your SQL syntax; check the
manual that corresponds to your MySQL server version for the right
syntax to use near 'PRIVILAGES ON *.* TO 'gary@supercrunch' IDENTIFIED
BY 'qatip' WITH GRANT OPTION' at line 1

Leaving out the quotes makes no difference.

Gary R


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql-2@m.gmane.org

Re: GRANT ALL error - newbee

--0016364d1bd7d6dc9e04904fb448
Content-Type: text/plain; charset=UTF-8

On Wed, Sep 15, 2010 at 12:10 PM, Gary Roach wrote:

> I'm attempting to set up a Linux Apache Mysql PHP (LAMP) system for the
> first time. On my internal network (behind firewall) I have a computer
> (cruncher) that is acting as the web server. Another computer (supercrunch)
> is being used as the home for Dupal6. I connected to the cruncher system
> from supercrunch with "mysql -u root -h cruncher -p". This seemed to work
> fine. But, one of the setup statements follows along with the result. I
> can't find the error. Help!
>
> mysql> GRANT ALL PRIVILAGES ON *.* TO 'gary@supercrunch' IDENTIFIED BY
> '' WITH GRANT OPTION;
> ERROR 1064 (42000): You have an error in your SQL syntax; check the manual
> that corresponds to your MySQL server version for the right syntax to use
> near 'PRIVILAGES ON *.* TO 'gary@supercrunch' IDENTIFIED BY 'qatip' WITH
> GRANT OPTION' at line 1
>
> Leaving out the quotes makes no difference.
>
> Gary R
>
> Gary, if that is the actual command, you've misspelled PRIVILEGES.

HTH,

David

--0016364d1bd7d6dc9e04904fb448--

RE: GRANT ALL error - newbee

PRIVILAGES should read PRIVILEGES

-----Original Message-----
From: Gary Roach [mailto:gary719_list1@verizon.net]
Sent: Wednesday 15 September 2010 19:11
To: mysql@lists.mysql.com
Subject: GRANT ALL error - newbee

I'm attempting to set up a Linux Apache Mysql PHP (LAMP) system for the
first time. On my internal network (behind firewall) I have a computer
(cruncher) that is acting as the web server. Another computer
(supercrunch) is being used as the home for Dupal6. I connected to the
cruncher system from supercrunch with "mysql -u root -h cruncher -p".
This seemed to work fine. But, one of the setup statements follows along
with the result. I can't find the error. Help!

mysql> GRANT ALL PRIVILAGES ON *.* TO 'gary@supercrunch' IDENTIFIED BY
'' WITH GRANT OPTION;
ERROR 1064 (42000): You have an error in your SQL syntax; check the
manual that corresponds to your MySQL server version for the right
syntax to use near 'PRIVILAGES ON *.* TO 'gary@supercrunch' IDENTIFIED
BY 'qatip' WITH GRANT OPTION' at line 1

Leaving out the quotes makes no difference.

Gary R


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=azzopardi@eib.org


------------------------------------------------------------ --------

Les informations contenues dans ce message et/ou ses annexes sont
reservees a l'attention et a l'utilisation de leur destinataire et peuvent etre
confidentielles. Si vous n'etes pas destinataire de ce message, vous etes
informes que vous l'avez recu par erreur et que toute utilisation en est
interdite. Dans ce cas, vous etes pries de le detruire et d'en informer la
Banque Europeenne d'Investissement.

The information in this message and/or attachments is intended solely for
the attention and use of the named addressee and may be confidential. If
you are not the intended recipient, you are hereby notified that you have
received this transmittal in error and that any use of it is prohibited. In
such a case please delete this message and kindly notify the European
Investment Bank accordingly.
------------------------------------------------------------ --------



--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql-2@m.gmane.org