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]
