Error Removing Anonymous Accounts

Error Removing Anonymous Accounts

am 11.03.2010 17:21:00 von Carlos Williams

I installed MySQL 5 today and started by setting up root passwords for
all three root accounts:

mysql> select User, Password, Host, Create_priv from user;
+------+-------------------------------------------+-------- ---+-------------+
| User | Password | Host | Create_priv |
+------+-------------------------------------------+-------- ---+-------------+
| root | *3B657EF5C969760D3CF4E42931FDCE507F26D2A1 | localhost | Y |
| root | *3B657EF5C969760D3CF4E42931FDCE507F26D2A1 | ghost | Y |
| root | *3B657EF5C969760D3CF4E42931FDCE507F26D2A1 | 127.0.0.1 | Y |
| | | localhost | N |
| | | ghost | N |
+------+-------------------------------------------+-------- ---+-------------+

Now my question is when I follow this 'Anonymous Account Removal' guide:

http://dev.mysql.com/doc/refman/5.0/en/default-privileges.ht ml

I get the following error:

mysql> DROP USER '';
ERROR 1396 (HY000): Operation DROP USER failed for ''@'%'

Any help is greatly appreciated!

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql-2@m.gmane.org

RE: Error Removing Anonymous Accounts

am 11.03.2010 17:29:20 von Rolando Edwards

REVMRVRFIEZST00gbXlzcWwudXNlciBXSEVSRSB1c2VyPScnOw0KRkxVU0gg UFJJVklMRUdFUzsN
Cg0KUm9sYW5kbyBBLiBFZHdhcmRzDQpNeVNRTCBEQkEgKENNREJBKQ0KDQox NTUgQXZlbnVlIG9m
IHRoZSBBbWVyaWNhcywgRmlmdGggRmxvb3INCk5ldyBZb3JrLCBOWSAxMDAx Mw0KMjEyLTYyNS01
MzA3IChXb3JrKQ0KMjAxLTY2MC0zMjIxIChDZWxsKQ0KQUlNICYgU2t5cGUg OiBSb2xhbmRvTG9n
aWNXb3J4DQpyZWR3YXJkc0Bsb2dpY3dvcmtzLm5ldA0KaHR0cDovL3d3dy5s aW5rZWRpbi5jb20v
aW4vcm9sYW5kb2Vkd2FyZHMNCg0KDQotLS0tLU9yaWdpbmFsIE1lc3NhZ2Ut LS0tLQ0KRnJvbTog
Q2FybG9zIE1lbm5lbnMgW21haWx0bzpjYXJsb3N3aWxsQGdtYWlsLmNvbV0g DQpTZW50OiBUaHVy
c2RheSwgTWFyY2ggMTEsIDIwMTAgMTE6MjEgQU0NClRvOiBNeVNRTA0KU3Vi amVjdDogRXJyb3Ig
UmVtb3ZpbmcgQW5vbnltb3VzIEFjY291bnRzDQoNCkkgaW5zdGFsbGVkIE15 U1FMIDUgdG9kYXkg
YW5kIHN0YXJ0ZWQgYnkgc2V0dGluZyB1cCByb290IHBhc3N3b3JkcyBmb3IN CmFsbCB0aHJlZSBy
b290IGFjY291bnRzOg0KDQpteXNxbD4gc2VsZWN0IFVzZXIsIFBhc3N3b3Jk LCBIb3N0LCBDcmVh
dGVfcHJpdiBmcm9tIHVzZXI7DQorLS0tLS0tKy0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0t
LS0tLS0tLS0tLS0tLS0rLS0tLS0tLS0tLS0rLS0tLS0tLS0tLS0tLSsNCnwg VXNlciB8IFBhc3N3
b3JkICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgIHwgSG9zdCAg ICAgIHwgQ3JlYXRl
X3ByaXYgfA0KKy0tLS0tLSstLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0t
LS0tKy0tLS0tLS0tLS0tKy0tLS0tLS0tLS0tLS0rDQp8IHJvb3QgfCAqM0I2 NTdFRjVDOTY5NzYw
RDNDRjRFNDI5MzFGRENFNTA3RjI2RDJBMSB8IGxvY2FsaG9zdCB8IFkgICAg ICAgICAgIHwNCnwg
cm9vdCB8ICozQjY1N0VGNUM5Njk3NjBEM0NGNEU0MjkzMUZEQ0U1MDdGMjZE MkExIHwgZ2hvc3Qg
ICAgIHwgWSAgICAgICAgICAgfA0KfCByb290IHwgKjNCNjU3RUY1Qzk2OTc2 MEQzQ0Y0RTQyOTMx
RkRDRTUwN0YyNkQyQTEgfCAxMjcuMC4wLjEgfCBZICAgICAgICAgICB8DQp8 ICAgICAgfCAgICAg
ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICB8IGxvY2Fs aG9zdCB8IE4gICAg
ICAgICAgIHwNCnwgICAgICB8ICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAg
ICAgIHwgZ2hvc3QgICAgIHwgTiAgICAgICAgICAgfA0KKy0tLS0tLSstLS0t LS0tLS0tLS0tLS0t
LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tKy0tLS0tLS0tLS0tKy0tLS0t LS0tLS0tLS0rDQoN
Ck5vdyBteSBxdWVzdGlvbiBpcyB3aGVuIEkgZm9sbG93IHRoaXMgJ0Fub255 bW91cyBBY2NvdW50
IFJlbW92YWwnIGd1aWRlOg0KDQpodHRwOi8vZGV2Lm15c3FsLmNvbS9kb2Mv cmVmbWFuLzUuMC9l
bi9kZWZhdWx0LXByaXZpbGVnZXMuaHRtbA0KDQpJIGdldCB0aGUgZm9sbG93 aW5nIGVycm9yOg0K
DQpteXNxbD4gRFJPUCBVU0VSICcnOw0KRVJST1IgMTM5NiAoSFkwMDApOiBP cGVyYXRpb24gRFJP
UCBVU0VSIGZhaWxlZCBmb3IgJydAJyUnDQoNCkFueSBoZWxwIGlzIGdyZWF0 bHkgYXBwcmVjaWF0
ZWQhDQoNCi0tIA0KTXlTUUwgR2VuZXJhbCBNYWlsaW5nIExpc3QNCkZvciBs aXN0IGFyY2hpdmVz
OiBodHRwOi8vbGlzdHMubXlzcWwuY29tL215c3FsDQpUbyB1bnN1YnNjcmli ZTogICAgaHR0cDov
L2xpc3RzLm15c3FsLmNvbS9teXNxbD91bnN1Yj1yZWR3YXJkc0Bsb2dpY3dv cmtzLm5ldA0KDQo=

Re: Error Removing Anonymous Accounts

am 11.03.2010 17:32:10 von Carlos Williams

On Thu, Mar 11, 2010 at 11:29 AM, Rolando Edwards
wrote:
> DELETE FROM mysql.user WHERE user='';
> FLUSH PRIVILEGES;

That worked and I thank you however I am wondering why the MySQL guide
was incorrect? Perhaps it's right but I did something wrong. Any
thoughts?

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql-2@m.gmane.org

RE: Error Removing Anonymous Accounts

am 11.03.2010 21:56:14 von Gavin Towey

DQpEUk9QIFVTRVIgJydAJ2xvY2FsaG9zdCc7DQoNCklmIHlvdSB1c2UgdGhl IGNvcnJlY3QgR1JB
TlQvUkVWT0tFIGFuZCBDUkVBVEUvRFJPUCBjb21tYW5kcyBpdCdzIG5vdCBu ZWNlc3NhcnkgdG8g
dXBkYXRlIHRoZSB0YWJsZXMgYW5kIHJ1biBGTFVTSCBQUklWSUxFR0VTLiAg SU1PIG1hbmlwdWxh
dGluZyB0aG9zZSB0YWJsZXMgZGlyZWN0bHkgaXMgYSBiYWQgaGFiaXQuDQoN Ci0tLS0tT3JpZ2lu
YWwgTWVzc2FnZS0tLS0tDQpGcm9tOiBDYXJsb3MgTWVubmVucyBbbWFpbHRv OmNhcmxvc3dpbGxA
Z21haWwuY29tXQ0KU2VudDogVGh1cnNkYXksIE1hcmNoIDExLCAyMDEwIDg6 MzIgQU0NClRvOiBN
eVNRTA0KU3ViamVjdDogUmU6IEVycm9yIFJlbW92aW5nIEFub255bW91cyBB Y2NvdW50cw0KDQpP
biBUaHUsIE1hciAxMSwgMjAxMCBhdCAxMToyOSBBTSwgUm9sYW5kbyBFZHdh cmRzDQo8cmVkd2Fy
ZHNAbG9naWN3b3Jrcy5uZXQ+IHdyb3RlOg0KPiBERUxFVEUgRlJPTSBteXNx bC51c2VyIFdIRVJF
IHVzZXI9Jyc7DQo+IEZMVVNIIFBSSVZJTEVHRVM7DQoNClRoYXQgd29ya2Vk IGFuZCBJIHRoYW5r
IHlvdSBob3dldmVyIEkgYW0gd29uZGVyaW5nIHdoeSB0aGUgTXlTUUwgZ3Vp ZGUNCndhcyBpbmNv
cnJlY3Q/IFBlcmhhcHMgaXQncyByaWdodCBidXQgSSBkaWQgc29tZXRoaW5n IHdyb25nLiBBbnkN
CnRob3VnaHRzPw0KDQotLQ0KTXlTUUwgR2VuZXJhbCBNYWlsaW5nIExpc3QN CkZvciBsaXN0IGFy
Y2hpdmVzOiBodHRwOi8vbGlzdHMubXlzcWwuY29tL215c3FsDQpUbyB1bnN1 YnNjcmliZTogICAg
aHR0cDovL2xpc3RzLm15c3FsLmNvbS9teXNxbD91bnN1Yj1ndG93ZXlAZmZu LmNvbQ0KDQoNClRo
aXMgbWVzc2FnZSBjb250YWlucyBjb25maWRlbnRpYWwgaW5mb3JtYXRpb24g YW5kIGlzIGludGVu
ZGVkIG9ubHkgZm9yIHRoZSBpbmRpdmlkdWFsIG5hbWVkLiAgSWYgeW91IGFy ZSBub3QgdGhlIG5h
bWVkIGFkZHJlc3NlZSwgeW91IGFyZSBub3RpZmllZCB0aGF0IHJldmlld2lu ZywgZGlzc2VtaW5h
dGluZywgZGlzY2xvc2luZywgY29weWluZyBvciBkaXN0cmlidXRpbmcgdGhp cyBlLW1haWwgaXMg
c3RyaWN0bHkgcHJvaGliaXRlZC4gIFBsZWFzZSBub3RpZnkgdGhlIHNlbmRl ciBpbW1lZGlhdGVs
eSBieSBlLW1haWwgaWYgeW91IGhhdmUgcmVjZWl2ZWQgdGhpcyBlLW1haWwg YnkgbWlzdGFrZSBh
bmQgZGVsZXRlIHRoaXMgZS1tYWlsIGZyb20geW91ciBzeXN0ZW0uIEUtbWFp bCB0cmFuc21pc3Np
b24gY2Fubm90IGJlIGd1YXJhbnRlZWQgdG8gYmUgc2VjdXJlIG9yIGVycm9y LWZyZWUgYXMgaW5m
b3JtYXRpb24gY291bGQgYmUgaW50ZXJjZXB0ZWQsIGNvcnJ1cHRlZCwgbG9z dCwgZGVzdHJveWVk
LCBhcnJpdmUgbGF0ZSBvciBpbmNvbXBsZXRlLCBvciBjb250YWluIHZpcnVz ZXMuIFRoZSBzZW5k
ZXIgdGhlcmVmb3JlIGRvZXMgbm90IGFjY2VwdCBsaWFiaWxpdHkgZm9yIGFu eSBsb3NzIG9yIGRh
bWFnZSBjYXVzZWQgYnkgdmlydXNlcyBvciBlcnJvcnMgb3Igb21pc3Npb25z IGluIHRoZSBjb250
ZW50cyBvZiB0aGlzIG1lc3NhZ2UsIHdoaWNoIGFyaXNlIGFzIGEgcmVzdWx0 IG9mIGUtbWFpbCB0
cmFuc21pc3Npb24uIFtGcmllbmRGaW5kZXIgTmV0d29ya3MsIEluYy4sIDIy MCBIdW1ib2x0IGNv
dXJ0LCBTdW5ueXZhbGUsIENBIDk0MDg5LCBVU0EsIEZyaWVuZEZpbmRlci5j b20NCg==