Best unofficial Apache Server developers community |
|
I cannot seem to re-create a simple user I've deleted though I'm in MySQL as root. Special case: user 'jack' existed before, but I deleted it from mysql.user in order to recreate it. I see no vestiges of this in that table. If I do this command for some other, random username, say 'jimmy', it works fine (just as it originally did for 'jack'). What have I done to corrupt user 'jack' and how can I undo that corruption in order to re-create 'jack' as a valid user for this installation of MySQL? See short demonstration below. (Of course, originally, there was much time between the creation of 'jack' and his removal.) Much thanks to any comments or answers. Russ
posted via StackOverflow
|
|
 
|
try |
![]()  
|
Try doing a |
|
 
|
You shouldn't be manually deleting users that way. MySQL has
Best to use the tools provided rather than mucking around in the background. |