MySQL 4 Grant command

2008-03-05 Thread Garris, Nicole
OK, what is wrong with the following statement? MySQL 4.1 doesn't like
my syntax ...


mysql grant all privileges on *.* to [EMAIL PROTECTED] identified by
'myownpassword';


Re: MySQL 4 Grant command

2008-03-05 Thread Paul DuBois

At 4:12 PM -0800 3/5/08, Garris, Nicole wrote:

OK, what is wrong with the following statement? MySQL 4.1 doesn't like
my syntax ...


mysql grant all privileges on *.* to [EMAIL PROTECTED] identified by
'myownpassword';


% needs quotes around it.

I recommend always quoting the username and hostname:

'login3'@'%'


--
Paul DuBois, MySQL Documentation Team
Madison, Wisconsin, USA
MySQL AB, www.mysql.com

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