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]