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 it had some special "magical" status, that behind the scenes routines would synchronize this table with others if I found the right key (command) to do so. They're just normal tables, aren't they?
Anyway, it's DELETE and CREATE for me from now on. Thank you. On Tue, 2007-05-01 at 19:51 -0400, Michael Dykman wrote: > 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 it on > not-so-secure unix systems but it's still far from common practice. I > recommend that you take the easy road and just delete/create. > > > > On 5/1/07, John Kebbel <[EMAIL PROTECTED]> wrote: > > 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 problem: > > "RENAME USER does not automatically migrate any database objects that > > the user created, nor does it migrate any privileges that the user had > > prior to the renaming. This applies to tables, views, stored routines, > > triggers, and events. " > > > > Is there some kind of shortcut to a privilege swap, or am I better off > > just deleting users and recreating them with the new name. > > > > _______________ > > Sorry to deluge this mailing list with so many requests, but I'm trying > > to build my knowledge base for a CMDEV and I spend hours painting myself > > into corners with MySQL every night and weekend day. > > > > > > -- > > MySQL General Mailing List > > For list archives: http://lists.mysql.com/mysql > > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > > > > > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
