SitePoint Sponsor

User Tag List

Results 1 to 4 of 4
  1. #1
    SitePoint Member
    Join Date
    Mar 2012
    Posts
    4
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    "The selected user was not found in the privilege table."

    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?

  2. #2
    SitePoint Wizard guelphdad's Avatar
    Join Date
    Oct 2003
    Location
    St. Catharines, ON Canada
    Posts
    1,706
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    if you deleted a row from the mysql table you need to run FLUSH PRIVILEGES, if not the user hasn't really been removed.

  3. #3
    SitePoint Member
    Join Date
    Mar 2012
    Posts
    4
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    How?

    Quote Originally Posted by guelphdad View Post
    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.

  4. #4
    SitePoint Wizard guelphdad's Avatar
    Join Date
    Oct 2003
    Location
    St. Catharines, ON Canada
    Posts
    1,706
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    do that as mysql root user inside of mysql


Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •