> GRANT ALL PRIVILEGES ON *.* TO tue@"%" IDENTIFIED BY 'apassword' WITH GRANT OPTION;
Ah but that doesn't work.... this is what worries me because I have a book on mysql that uses syntax like this and it generates an error on my system. This is a Red Hat 7.2 system, stock with Red Hat distributed upgrades. For example: [root@crab root]# uname -a Linux crab.ocean.yonderway.com 2.4.9-13 #1 Tue Oct 30 19:32:27 EST 2001 i686 unknown [root@crab root]# rpm -q mysql mysql-3.23.41-1 [root@crab root]# mysql Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 55 to server version: 3.23.41 Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql> grant all privileges on *.* to foo@% identified by 'foobar' with grant option; ERROR 1064: You have an error in your SQL syntax near '% identified by 'foobar' with grant option' at line 1 mysql> --------------------------------------------------------------------- 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
