CODEWITHSUNDEEP
mysqlwordpress
camelCaseCowboy
camelCaseCowboy

Reputation: 986

Database named "Wordpress" present in SSH but missing in MySQL Workbench

I am trying to configure my Linux server to create a staging environment for my Wordpress Multisite. I am trying to access the wp_options table to be able to make changes, but I'm getting a garbled mess of dashes when I attempt to "SELECT * FROM WP_OPTIONS".

To counter this, I am attempting to use MySQL Workbench to see if it tidies up the mess. However, while I see the database entitled "wordpress" when I SSH into the server (I'm using Google Cloud Platform as my host), I do NOT see the database when I use MySQL Workbench!

I'm running sudo when activating mysql in SSH, and I'm logging in as "root" when using MySql workbench, so the permissions should be the same.

Below is the comparison between the SSH and what I'm seeing after running a "SHOW DATABASES;" command between them:

enter image description here

enter image description here

How can I get the wordpress database to show up in MySQL Workbench???

Edit 1: I have ruled out that this is a permissions issue- using SELECT_CURRENTUSER(); I see that I am logged in as the exact same account in both (root@%), so despite having the EXACT same permissions I am getting different tables showing.

Upvotes: 0

Views: 138

Answers (1)

Kris Chase
Kris Chase

Reputation: 137

You should consider logging in through your root session and then updating your permissions to view the database as the correct user, from whatever server you'd like.

GRANT ALL PRIVILEGES ON <Database Name>.* TO '<Username>'@'%';

Upvotes: 3

Related Questions