MySQL Archives – Remons TechNotes

RaSQL: a database manager for web developers, with MCP support

I’ve always been a fan of Sequel Pro. A straightforward SQL management tool, useful for local work, but also for managing production data over SSH.

Unfortunately, Sequel Pro has been abandoned a long time ago. It has served me well up to earlier this year, when Apple moved away from Rosetta2 on Macos 27, and now it no longer works.

Sequel ACE has had too many issues for me, breaking my workflow, I don’t like paying for software, especially a subscription, when I know there are free but more importantly BETTER alternatives out there.

So I set out to build my own. I wrote it in Swift, for myself, but ran into difficulties soon. I enlisted Claude to help out, we got far, but still too many problems, even basic ones like panel sizing/table alignment. Basic stuff. Internet no help, Claude no help, so, down the drain.

Very recently, I gave Claude another go, but this time, no interference from me, just prompts to guide it to the solution I need, I want, not what the universe is requiring of me.

So, LocalWP first, MySQL. Nothing more, nothing less.

Next version included SSH connectivity and other Database types, read-only mode for production databases.

And now version 0.2.0 is available and it has MCP support. YOU decide how agents can interact with the data, settings per database. Read Only? fine. Ask on each write? done. Use TouchID or Password on each write? You got it.

This is what Claude has to say, when I asked it to create a blog-post and screenshots about it

Continue reading “RaSQL: a database manager for web developers, with MCP support”

Sequel Pro can’t connect to Local’s MySQL 8? MySQL Fixes AddOn to the rescue [A LocalWP Addon].

The Problem

Connect a classic client (for example Sequel Pro, older Sequel Ace, older JDBC tools) to a Local site running MySQL 8 and you’re greeted with authentication errors about caching_sha2_password.

(I talked about this already, here)

The classic clients speak mysql_native_password; MySQL 8 defaults to the new plugin, and on 8.4+ the old plugin isn’t just non-default, but (and in my opinion, this is a bug of omission) it ships disabled.

Meanwhile Local’s own connections work fine, so from Local’s point of view there is no bug. From MY point of view, sitting in front of a client that can’t connect to my own database; there very much is. Continue reading “Sequel Pro can’t connect to Local’s MySQL 8? MySQL Fixes AddOn to the rescue [A LocalWP Addon].”

A quick note regarding MySQL error about caching_sha2_password.so not being able to be loaded

For local database manipulation I still use Sequel Pro. Why? Well, all the derivatives (Like Sequel Ace) have a smaller feature set, and alternatives (like MySQL WorkBench) are too complex, and even limited. (How hard is it to provide a socket based connection, or an SSH tunnel TCP connection…)

Anyhoo, a quick note to myself for fixing the error

Double-check that the socket path is correct and that you have the necessary privileges, and that the server is running.

MySQL said: Authentication plugin ‘caching_sha2_password’ cannot be loaded: dlopen(/usr/local/mysql/lib/plugin/caching_sha2_password.so, 0x0002): tried: ‘/usr/local/mysql/lib/plugin/caching_sha2_password.so’ (no such file), ‘/System/Volumes/Preboot/Cryptexes/OS/usr/local/mysql/lib/plugin/caching_sha2_password.so’ (no such file), ‘/usr/local/mysql/lib/plugin/caching_sha2_password.so’ (no such file) Continue reading “A quick note regarding MySQL error about caching_sha2_password.so not being able to be loaded”

Handy script: lbf

[Edit: This script is defunct since Local rebuilt the application and ditched the virtual machine. This script works only with the old “Local by Flywheel” and not with the “Local Lightning” app. For the latter, see my lbl script]

Local (by Flywheel) is great, but for a terminal type of person as I am, I find it way more convenient to SSH into a VM and use the WP-CLI to perform WordPress tasks. With a platform like Vagrant, one has the

vagrant ssh

command to shell into the virtual environment.

With Local, you can do this with the push of a button in Local, but as said, I like the terminal better.

lbf ssh

is waaaaay faster than going to the Local app, find the site, click the SSH button.

But wait, there is much more ;) Continue reading “Handy script: lbf”