It's correct, just insert at the end of line: WITH GRANT OPTION; rtfm
Vaso -----Original Message----- From: Andrew Dumaresq [mailto:[EMAIL PROTECTED]] Sent: 2002. január 22. 19:31 To: [EMAIL PROTECTED] Subject: Problem with Grant command Hello, I have what I consider to be a very strange problem, I log in into mysql on my localhost I can select from and manually modify tables using insert select and delete, but I cannot do Grant. I typed the following command: GRANT ALL PRIVILEGES ON *.* TO root@localhost IDENTIFIED BY 'my password in here'; to this command the system responds: ERROR 1045: Access denied for user: 'root@localhost' (Using password: YES) I realize this command is redundant, but it proves my point. I am using a RedHat 7.2 server with RedHat kernel version 2.4.7 Any help would be greatly appreciated. Thanks Andrew Dumaresq Technician / Administrator Mathematics & Computing Science Saint Mary's University Phone: (902)420-5893 Fax: (902)420-5035 --------------------------------------------------------------------- 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