I deleted the user "ijdbuser" from the MySQL table. Now, when I try to re-create ijdbuser and give it access to the ijdb database, there is an error. Looking at the ijdb database, the ijdbuser still appears in the privilege list, yet there is also a message "The selected user was not found in the privilege table." How to I clean up this situation so I can re-add my ijdbuser?

guelphdad
—
2012-07-14T19:39:25Z —
#2

if you deleted a row from the mysql table you need to run FLUSH PRIVILEGES, if not the user hasn't really been removed.

Gnurps
—
2012-07-14T20:23:57Z —
#3

guelphdad said:

if you deleted a row from the mysql table you need to run FLUSH PRIVILEGES, if not the user hasn't really been removed.

How does one run FLUSH PRIVILEGES?Thanks.

guelphdad
—
2012-07-14T22:05:12Z —
#4

do that as mysql root user inside of mysql

Mittineague
—
2014-09-20T19:44:28Z —
#5

This topic is now archived. It is frozen and cannot be changed in any way.