MySQL Forums
Forum List  »  Security

Advanced Search
New Topic

Re: Problem with the GRANT statement on 5.22
Posted by: Tony Caduto
Date: October 23, 2006 11:49AM

Yes, but it should not if there is already a user root@%.
The prolem is it's creating another instance of the same user without a password, which technically should not be possible because the user and host fields are the Primary Key. I have seen this happen on a couple of different servers all running 5.22.

It should only add a user if you use the IDENTIFIED BY PASSWORD option.

Thanks,

Tony

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Views
Written By
Posted
Problem with the GRANT statement on 5.22
3522
Tony Caduto
October 23, 2006 10:18AM
Re: Problem with the GRANT statement on 5.22
2441
Bob Field
October 23, 2006 11:31AM
Re: Problem with the GRANT statement on 5.22
2323
Tony Caduto
October 23, 2006 11:49AM
Re: Problem with the GRANT statement on 5.22
2461
Bob Field
October 23, 2006 01:15PM
Re: Problem with the GRANT statement on 5.22
2238
Tony Caduto
October 23, 2006 02:02PM
Re: Problem with the GRANT statement on 5.22
2132
Bob Field
October 23, 2006 02:26PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.