GRANT ALL PRIVILEGES ON *.* TO me @'host.domain' IDENTIFIED BY
'mypassword';

Is giving me a syntax error..
I'm on mac os x 10.6
I wonder if this has something to do with how I started mysql?
sudo /usr/local/mysql/bin/mysql

Can the password be the same for the same user logging in from a
different workstation?
Is the space necessary before the @? are the 's necessary around
host.domain if it's not an IP address?
Are 's necessary around the password....
I've tried everything and i just can't get it to work.

El 13/01/2011 4:14, SpreadTooThin escribió/wrote:
Not this query. If the real query you are using is triggering a syntax
error, it's because you have a password like "o'brian" and you aren't
escaping it properly.


It's a fascinating hypothesis but, as far as I know, the SQL syntax
supported by MySQL is the same for all system users.


Why couldn't you repeat passwords? It wouldn't be a safe system if you a
message like "password abcdef is already in use by another user"...

You don't have to guess:

http://dev.mysql.com/doc/refman/5.1/en/grant.html


--
-- http://alvaro.es - Álvaro G. Vicario - Burgos, Spain
-- Mi sitio sobre programación web: http://borrame.com
-- Mi web de humor satinado: http://www.demogracia.com
--

On Wed, 12 Jan 2011 19:14:35 -0800 (PST), SpreadTooThin
<bjobrien62 (AT) gmail (DOT) com> wrote:

And it tells you where.

GRANT ALL PRIVILEGES ON *.* TO 'me'@'host.domain'

There is no reason to run it as root.

No, check the syntax description in the manual.

Just use them. Always.

Check the syntax description in the manual. If it states
password is a string literal, you need single quotes.

--
( Kees Nuyt
)
c[_]

Hi,

i'd install MySQLWorkbench und use the server administration there (Accounts, manage users).

It makes things a lot easier to understand even if you want to use command line SQL-commands later.

kind regards,

Bodo

http://dev.mysql.com/downloads/workbench/5.2.html