'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
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Trevor Harris NuSphere Corp.
Instructor/Consultant 14 Oak Park
Bedford, MA 01730 USA
E-mail: [EMAIL PROTECTED] http://www.nusphere.com
Tel 781-280-4243
Fax 781-280-4901
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
-----Original Message-----
From: David Simcik [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, June 12, 2001 6:25 PM
To: Mysql
Subject: GRANT annoyance...
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 exactly does the IDENTIFIED BY 'user' statement do anyways? ;-)
I'm hoping this is rather trivial to correct!
Thanks!
DTS
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail
<[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
