Duane Dunston wrote:

Hello,

We have a problem where someone entered a hostname into the database with a capital letter in the hostname for a set of users. We want all lowercase entries. We use a web program to update the database. There was a bug in my web application where I didn't force the hostname string to lowercase letters, which has been corrected.

We deleted the host entries for the user but when we added the hostnames back with lowercase letters, it still shows up as capital letters only for the users that were entered initially. If we enter a new user for one of the hosts with a lowercase hostname it works fine, meaning the hostname is lowercase for any new user not entered initially.

Are you using replication?

Even if we add in the hostname via the console for the users initially entered, the capital hostname reappears after we apply the changes. It seems those hostnames with capital letters are cached.

Is there a way to flush the database cache or permanently remove those cached capital hostname entries for each user?