Thank you for stating something obvious that I was completely
overlooking. With normal tables I had created, I would never expect
related tables to be magically updated by something I did to one table.
Because I was dealing with a table in the mysql database that was
created by MySQL, I had assumed
I trust that you realize that you can never expect related tables to
be uodated in the mysql database if you using using SQL to manipulate
them directly. moving on..
I can't think of any mainstream systrm that generally allows usernames
to be changed.. I mean, sure, there is a trivial hack to do
I've discovered that I can type ...
use mysql;
show tables;
describe user;
update user set user='newName' where user='oldName'
However, this seems to have no effect on the user name in the privileges
table when I searched them.
The MySQL site says the alternative way to do this has the same pro
