Jeff,
I'm in the process of working with some grants, so I tried the following and
it worked fine.
grant all privileges on *.* to sec5 identified by 'sec' with grant option;
SHOW GRANTS FOR sec5 produced the following:
mysql show grants for sec5;
+---
+
| Grants for [EMAIL PROTECTED] |
+---
+
| GRANT ALL PRIVILEGES ON *.* TO 'sec5'@'%' IDENTIFIED BY PASSWORD
'789677c92632ab41' WITH GRANT OPTION |
+---
---
-+
1 row in set (0.00 sec)
- Original Message -
From: Jeff Ritchie [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, April 27, 2004 4:35 PM
Subject: Still getting problems creating a new super user on version 4 under
WinXP
GRANT ALL PRIVILEGES ON *.* TO 'username'@'localhost'
IDENTIFIED BY 'password' WITH GRANT OPTION;
Excuted in a MySQL console returns the following SQL error
ERROR 1064:you have an error in your SQL syntax.
check the manual that corresponds to you MYSQL server version for the right
syntax to use near 'password with grant option' at line 1
Copied and pasted the command direct from the manual and still ain't working
:(
HELP!!!
Cheers,
Jeff
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
