Page 1 of 1

Strange error in PHP MyAdmin

PostPosted: 02. March 2012 00:46
by newbieapache
When I attempt to delete a user in the Privileges tab by checking the check box beside the user's name and then pressing "go" in the "Remove selected users" section of the page, it complains that there are too many characters in the user's name...but there aren't, and it displays the user's name with strange HTML entities appended to the name. I'm not sure where the entities are coming from, but they are definitely what is lengthening the name beyond the 16 character or so limitation.

For example, I created a user named simply "g". When I attempt to remove the user using the graphical interface, it reports:

#1470 - String 'glocalhost' is too long for user name (should be no longer than 16)

The string should rightly just be the letter 'g', right?

Likewise, if I create a user named 'harry' and then attempt to delete him by the same graphical method, it reports similarly:

#1470 - String 'harrylocalhost' is too long for user name (should be no longer than 16)

On the other hand, if I issue this SQL command in the SQL Query tab:

Code: Select all
drop user harry@localhost;

...then it works just fine. Likewise for dropping user 'g'.

I'm using XAMPP version 1.7.7 and Windows XP sp3.

What could be causing this problem?

Many thanks,