I am a new NocoDB user and I am utterly baffled by the MySQL connection method.
I don’t use SQL all that much, but I am an experienced Linux admin, so I encounter SQLite often, MySQL fairly regularly, and Postgres occasionally. Backing up, restoring, moving, and establishing network connections are no big deal.
I installed MariaDB, restored a database I want to examine, then got the NocoDB binary. It starts and I can get to the point of adding a datasource.
I see this:
[database connection stuff]
And at this point I am completely lost. If I set the Base Name to “mytestdb” it auto-populates Database as “mytestdb_noco”. I can see mytestdb_noco from command line but in the web interface I do not see any of the MANY tables in that database. I’ve tried various permutations of the database name in Database: and Base Name:
There is nothing about handling SQL databases that I could find in the web site’s Getting Started. I joined the Discord and maybe it’s my client, but I only see the four basic channels on login. Nothing in this forum seems really SQL specific either. There’s one official NocoDB YouTube video on this task but what it shows looks like a prior version of the system.
I am supposed to show NocoDB to a small group of people who want to explore this database later this week. Where do I go to learn how to even make a basic database connections?