Problem with the GRANT statement on 5.22
Hi,
I am running 5.22 on Linux and I ran into a weird issue.
Basicly anytime I run this command:
GRANT INSERT ON table `test`.`junk_table` TO 'root'@'%'
It creates a new root@% user account with no password and this then causes problems
with other commands going forward. I then have to manually delete the bogus entry.
Is this a known bug? Or am I just doing something wrong with the grant statement?
I thought grant was only supposed to create a new account if you use the IDENTIFIED BY PASSWORD option?
Thanks,
Tony Caduto
AM Software Design
Home of Lightning Admin for MySQL and Postgresql
Subject
Views
Written By
Posted
Problem with the GRANT statement on 5.22
3440
October 23, 2006 10:18AM
2403
October 23, 2006 11:31AM
2277
October 23, 2006 11:49AM
2408
October 23, 2006 01:15PM
2201
October 23, 2006 02:02PM
2083
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.