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.
--
MySQL General
Hi,
trying to create a new user with the below,
GRANT ALL PRIVILEGES ON *samhain* TO 'samhain'@'localhost'
IDENTIFIED BY 'passwd' WITH GRANT OPTION;
That should be 'samhain.*', not '*samhain*'.
Regards,
Martijn
--
The information contained in this communication and any attachments is
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
Hello.
If you want wildcards you could use something like this:
grant all privileges on `%samhain%`.* to [EMAIL PROTECTED] identified
by 'passwd' with grant option;
Mark Sargent [EMAIL PROTECTED] wrote:
Hi All,
trying to create a new user with the below,
GRANT ALL