Divi WordPress Theme
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

WordPress fix Reply To: External access to WP database

Discussion in 'Misc WordPress Requests' started by catacaustic, Feb 19, 2018.

  1. catacaustic


    Reply To: External access to WP database, by catacaustic

    As far as I know, opening the connection only connects to the server, it doesn’t actually test to see that the user has permissions over that database. The access denied error comes because the user doesn’t have permissions set for that database when you try to run the query. I’d double-check the permissions to check that the MySQL use that you’re using has the required permissions over the tables that you’re trying to query.

    The way to find out is to run another query that’s about as generic as possible. Soemthing like:

    SELECT * FROM wp_posts

    Or even any of your own custom tables in that database. If you get an error, it would be permissions problems for that user. If you get a result, you’ll have a problem with the SQL statement in your initial query.

    Reply To: External access to WP database

Share This Page

Monarch Social Sharing Plugin