RE: Problem with Grant command

[Andrew Dumaresq]

I don't understand what you mean by this.  Where do I add that command?

Also I am logged into database as root (ie I used mysql mysql -u root -p
to connect).

Btw I did rtfm :)


Thanks
Andrew

 
Andrew Dumaresq
Technician / Administrator
Mathematics & Computing Science
Saint Mary's University
Phone: [phone]
Fax: [phone]
 

-----Original Message-----
From: Vasoczki Ferenc [mailto:ferenc_vasoczki@stripped] 
Sent: Tuesday, January 22, 2002 2:35 PM
To: 'Andrew Dumaresq'; mysql@stripped
Subject: RE: Problem with Grant command

It's correct, just insert at the end of line:
WITH GRANT OPTION;

rtfm

Vaso

-----Original Message-----
From: Andrew Dumaresq [mailto:Andrew.Dumaresq@stripped]
Sent: 2002. január 22. 19:31
To: mysql@stripped
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: [phone]
Fax: [phone]



---------------------------------------------------------------------
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 <mysql-thread97081@stripped>
To unsubscribe, e-mail
<mysql-unsubscribe-ferenc_vasoczki=gallup.hu@stripped>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php