Stack Overflow has many answers, and this one helped a little bit. It lead me to this link, where the solution was to properly REVOKE and DROP the user and recreate. But, I was too chicken to drop the root user…
Here is my answer:
# stop the MySQL server. Can also do this from MAMP control panel.
$> killall -9 mysql
# start MySQL server and request it to not load in permissions
$> /Applications/MAMP/Library/bin/mysql --skip-grant-tables &
# launch mysql client. No password will be required.
# now that you are connected to the server, request it to load permissions
mysql> flush privileges;
Query OK, 0 rows affected (0.01 sec)
# now reset the root password
mysql> ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY ’newpassword';
The key part of that last statement is the mysql_native_password part. All of the above linked solutions use this instead:
mysql> ALTER USER 'root'@'localhost' IDENTIFIED BY 'newpassword’;
But this was failing for me, with the error:
ERROR 1396 (HY000): Operation ALTER USER failed for 'root'@'localhost'
The official documentation says that if this fails, try modifying the underlying table directly:
mysql> UPDATE mysql.user SET authentication_string = PASSWORD('newpassword')
-> WHERE User = 'root';
Query OK, 0 rows affected, 1 warning (0.00 sec)
Rows matched: 1 Changed: 0 Warnings: 1
Warning (Code 1681): 'PASSWORD' is deprecated and will be removed in a future release.
Which, as you can see, didn’t work either. So there you are. This is what worked for me on MAMP v6.3, macOS Big Sur, MySql 5.7.32.
If you are creating a “Search Folder” in Outlook, and are using custom criteria, and one of them is “In Folder” with the condition “Does not Contain”, you must list all your keywords in a single criterion.
For example, I have a Search Folder called “Weekly Threads” to help me review the email activity from the week when writing my weekly report.
On the advanced tab, you can add the filter expressions you want. I don’t want to see anything from my Junk or Deleted Items folders, and I was struggling to get my Search Folder to work.
I stumbled across this article, which describes how to use Search Folders, within which was a description on how the author of that article filtered out mail from multiple folders.
Until now, I hadn’t been able to get it to work, and resorted to filtering out by sender. Now, I have the answer! You must put all the folder search terms into one, single search criterion for the filter to work.
I find it strange, or at best non-intuitive that you while you can use multiple criteria for things like “From”, you must use only one criterion for the “In Folder” field. But, it works, so on to the next thing!
Meet Zeus, the next-door neighbour’s dog. We dog-sat for them while they were away in Montreal. Ella was super excited, and Lisa and I really enjoyed having a dog in the house.
Zeus is super-chill, and lounges around for most of the day.
But he *LOVES* his walks, and we went for some Epic walks in the neighbourhood. My step counter was very healthy! Can you guess which day we gave him back?
I had done this before, but this time I did it on the Charcoal grill.
I wasn’t sure where to place the board, to get enough smoke without burning it too fast. The board had been soaked, but that might not do much good it turns out. In the end, I aligned the board edges to hang over the coal baskets by about 2 cm, which might have been too much…
It was so good. Almost too good. The extra smoke from the charcoal, plus the burning plank, resulted in smoked salmon, instead of baked salmon with a slight cedar taste.
Everyone agreed it was excellent, but one couldn’t have too much of it, or too often.