Can't find database - Githubissues

TablePlus / DBngin

DB Engine

https://dbngin.com

995 stars 19 forks source link

Can't find database #71

Closed djmtype closed 3 years ago

djmtype commented 3 years ago

Please fill out the detail below, it helps me investigate the bug:

Driver (Ex: PostgreSQL 10.0): MySQL 5.7.23
DBngin build number: 3.4
macOS version: 11.5.2
The steps to reproduce this issue: I know there's a quicklink to the database from DBngin to TablePlus. However, if I open TablePlus and try to access it from there by entering my database name on port 3306, with username root and no password, it says it can't be found. This means when I try to install Strapi with MySQL option, it won't work.

Start DBngin
Activate or enable the database I previously set up using DBngin
Open TablePlus
Create new connection
Choose MySQL
Add the same database name set up in DBngin
Add 127.0.0.1 as host
Add username as "root"
Leave password empty
Set up same port number as in DBngin
Test Connection

Get unknown database error

huyphams commented 3 years ago

Hi @djmtype Could you show me the connection form in TablePlus?

djmtype commented 3 years ago

Maybe a better question is where on MacOS does DBngin store its databases?

djmtype commented 3 years ago

Screen Shot 2021-09-05 at 1 17 49 PM

huyphams commented 3 years ago

How did you create that database? the strapi?

djmtype commented 3 years ago

@huyphams I created it using DBngin.

huyphams commented 3 years ago

I don't think that you did it right. The name is the label for that server, it's not the database.

You must connect to the database and create it by command create database or click the database button and create it from GUI. Then you will be able to connect it with strapi

You can leave the database field empty in order to connect to the server.

djmtype commented 3 years ago

I'm not sure it matters but the MySQL build DBngin downloads/installs is Intel-based instead of ARM.

huyphams commented 3 years ago

You can create a database within TablePlus by clicking the database button in the image below:

djmtype commented 3 years ago

I don't think that you did it right. The name is the label for that server, it's not the database.

You must connect to the database and create it by command create database or click the database button and create it from GUI. Then you will be able to connect it with strapi

You can leave the database field empty in order to connect to the server.

Ok, thanks, I completely misinterpreted the instructions. By creating the connection, I also thought it was setting up a database. I've been living in Local (by Flywheel) too long.