Announcement

Collapse
No announcement yet.

1227 - Access denied; you need the SHOW DATABASES privilege for this operation

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • 1227 - Access denied; you need the SHOW DATABASES privilege for this operation

    My host is Network Solutions. When I open a connection, Navicat said error "1227 - Access denied; you need the SHOW DATABASES privilege for this operation". I can’t see any database within the connection, but my user account has enough privilege for this action. How can i see the databases?

  • #2
    Please follow the steps below -
    1. Close your connection. Then, right-click it and choose Connection Properties.
    2. Click to Advanced tab.
    3. Check "Use advanced connections".
    4. Click "Add DB to List" button.
    5. Enter your database name in the pop up.
    6. You can see the database is added into the list.
    7. Repeat steps 4 and 5 again to add another database if necessary.
    Click OK to close the connection properties settings. Double-click your connection to see if you can access your database.

    Comment

    Working...
    X