Anyone know how to connect to my Flarum mysql DB with Workbench?

MikeJones

I am on an aws instance and I am trying to connect using mysql workbench to my instance.

I set these parameters as follows:

Connection Method: standard tcp/ip over ssh ( I use ssh from the same computer so figured this was the best option)

SSH File Key: I used the same .ppk file I use for my SSH connection through Putty

MySQL Hostname: localhost (This is what it says in my config file for flarum)

MySQL Server Port: 3306 (Also taken from my config file

Username: same as I have in my flarum config

The error I get when testing the connection is:

Access denied fo 'none'. Authentication that can continue" public key

Any idea what I am missing?

ram0ng1

MikeJones I recomended use : HeidiSQL

clarkwinkelmann

Did you specify SSH hostname and SSH username ? (first two fields)

The "none" in the error should be the SSH username I think. Is it really your username or is it because the field was empty ?

I usually use 127.0.0.1 for the MySQL hostname instead of localhost, but maybe both can work.

MikeJones

clarkwinkelmann Did you specify SSH hostname and SSH username ? (first two fields)

yes, I used exactly what I use when I SSH into my server with putty.

MikeJones

ram0ng1 ooo I will definitely check this out. I didn't know there were any other options lol

luceos

A ppk key is not a ssh key; you will need to convert it first.

MikeJones

luceos Thanks that was it, I switched to the .pem and it connected like a gem!

Follow on question: If I create another table for something else on my website not related to flarum will there be issues with upgrading flarum?

cmcjacob

MikeJones If you mean having unrelated tables inside flarum's database - it shouldn't conflict as long as the table names don't conflict with any new potential table names flarum could add in an update migration. Many extensions add tables to flarum's DB without conflict.

If it's entirely unrelated to flarum I would consider creating the table in another database on the same server if needed.