Mark Sargent wrote:

Hi All,

trying to create a new user with the below,

GRANT ALL PRIVILEGES ON *samhain* TO 'samhain'@'localhost' IDENTIFIED BY 'passwd' WITH GRANT OPTION;

but, it gives a syntax error message. mysql version is 4.1.12. What is wrong with the syntax.? Cheers.

Mark Sargent.

The problem is with *samhain*. You probably meant samhain.*, as Martijn has already suggested. GRANT syntax is described in the manual <http://dev.mysql.com/doc/mysql/en/grant.html>.

Michael

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to