Articles, notes and random thoughts on Software Development and Technology
I posted a while back about running mysql in a Docker container on an Apple Silicon MacBook. It’s been a while since I’ve run mysql locally, and it seems the mysqlsh client is now preferred over the previous mysql client. With mysqlsh, after connecting, to issue a ‘use’ command to select a db, use ‘\use …
It’s been a while since I’ve run MySQL server on my MacBook Pro (see past notes here , here and more here) and since I got my new M1 MBP I haven’t installed it yet. Rather than doing a native install, I want to run it as a Docker container so I can throw it …
Continue reading “Running MySQL in a Docker container on MacOS”
It’s been 2 years since I migrated this site from a native install on a VPS to another VPS running Docker. I covered my migration in a number of posts, the first of which is here: The surprising thing (maybe? maybe not?) is that the site has been up and running for the past 2 …
Continue reading “2 years later: 2 years of running WordPress and MySQL on Docker in a VPS”
When creating a new Datasource on Weblogic 12.1.3 to MySQL 8.0.15, I got this error: Unable to load authentication plugin ‘caching_sha2_password’.com.mysql.jdbc.SQLError.createSQLException(SQLError.java:910) A quick search found this question, and the solution is to switch the password encryption back to the approach used in prior MySQL versions with: ALTER USER ‘youruserid’@’localhost’ IDENTIFIED WITH mysql_native_password BY ‘newpassword’;