Hi Dan,

I've got it all working on my Mac via Homebrew.

There was a minor hiccup with the default root user which was an easy fix - see below

If you still have MySQL installed I suggest uninstalling it - if installed from Oracle's install package maybe use their uninstaller or you could use these:

Remove MySQL completely per The Tech Lab

Restart your computer just to ensure any MySQL processes are killed
try to run mysql, it shouldn't work

Brew install MySQL per user Sedorner from StackOverflow

run the commands Brew suggests, add MySQL to launchctl so it automatically launches at startup
MvSQL should now work and be running all the time as expected

I had a Javascript error when I tried creating a new module - like so:

But can be fixed by going to phpMyAdminn or via the shell at a MySQL prompt (note root with no password)


I hope that all works for you. I think setting up a stack with Xampp is much easier but doing it via brew is more powerful. You get to choose the versions you want to run very easily, so upgrading php or testing an old version is simple. I have Apache and MySQL running as a service, I don't need to run the server after restarting my Mac.

Cheers,
Simon

You've been quiet Dan... I hope you are getting somewhere with your install of MySQL?

I checked this site and it seems installing MySQL from Homebrew on a MacBook Pro with Apple silicon should work > https://doesitarm.com/formula/mysql/

and on Homebrew formulae > https://formulae.brew.sh/formula/mysql

Nothing fancy here other than the install command:

Hello Simon,
Spring has sprung here. Busy cleaning up the yard and such.
I have everything running.
Getting the TYPEERROR: CONN.QUERY IS NOT A FUNCTION
when trying to create a new app.
When modifying an app, getting from MM, if the app does not have a database, it installs correctly.
If MM app has a database I get TYPEERROR CONN.DESTROY IS NOT A FUNCTION.

I have to believe that it has something to do with the mysql to trongate username and password.

We're in Autumn here and have already trimmed back trees and cleaned up a fair bit but it's always on going.

I suggest trying the following SQL statements to refresh your privileges.


That's a strange error you're getting. Working without a database, then fails with.

So, trying different things in the Trongate app.
My problem is definitely a connection to the database.
I have tried localhost as well as 127.0.0.1
I changed mysql to no password
Query Builder hangs up
Module Relations. I get an Error: Unable to connect to database. Please check your settings and try again.

This definitely indicated that trongate is looking for the database is a certain file or folder.
Could this be a path issue for trongate?

It's not Trongate but Node.js that does the database connections.

Did you try uninstalling mySQL and reinstalling as i guided above??

If the problem persists, I'd try Mariadb in its place.

If that fails, try a Xampp install, not the vm version though

Solved. Must have been some file somewhere.
Uninstalled and Reinstalled a few times.
Installed Mariadb through Homebrew.
Did not us mysql_secure_installation.
Just did an ALTER USER to set the root password
Thanks, Simon
Apple Silicon chip is so new not much out there in help yet.

So great to here its all working with MariaDB. I prefer it over MySQL anyway ?