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]
-- - michael dykman - [EMAIL PROTECTED] - All models are wrong. Some models are useful. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
