For years I’ve been connecting Navicat to LocalWP for WordPress development. Connecting with sockets stopped working when I upgraded to a Mac Studio with M2 Ultra chip. I found this post which got me back in business. Putting it here for my own peace of mind. Steps Allow `root` to connect via `127.0.0.1` Get the […]
Development
WP Database Cleanup
Orphaned postmeta: Orphaned comment meta Session Data: Delete post revisions: Delete transients: Delete unused tags:
WP Autoload Options
Autoloaded options total size: Top 20 autoload options by size:
Disable that Damn ‘Welcome to the Block Editor’ Message.
This requires the @wordpress/scripts package but I don’t have the time to get into that now.
Connect PhpStorm to Local MySQL on Mac.
There’s some info out there about connecting to MySQL via socket using something called junixsocket. All the instructions were pretty straight forward but I continued to get an error, something about socket length or some such thing. Turns out we need a user with access via 127.0.0.1 so we can connect via port as opposed […]
Superscript ordinal date numbers with PHP
Only need to escape the superscript tag when formatting a date string. March 2nd, 2020 date(‘F j\<\s\u\p\>S\<\/\s\u\p\>, Y’)