Recovering MySQL root password in MAMP

There are endless guides out there on how to do this. This is what I found:

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.
$> /Applications/MAMP/Library/bin/mysql

# 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.

Outlook 2013 Search Folders – How to filter by folder

Just a short note to hopefully help others:

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.

Outlook 2013 pop-up to Customize the Search Folder
Outlook 2013 pop-up to Customize the Search Folder

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.

Like this:

Outlook 2013 pop-up to enter advanced Search Criteria
Outlook 2013 pop-up to enter advanced Search Criteria

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!

 

Dog Sitting

Zeus

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.

Zeus Lounging 1

Zeus Lounging 2

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?

The Results of Walking Zeus

Pizza on the grill

We love pizza here in the Hawkes household. Like, really love it. Like, so much that I’m seriously considering building a wood fired pizza oven.

Until then, we’ve started experimenting with  making dough, and various ways to cook it. Our tried and true marinara sauce is a real champion here.

Before I broke the pizza stone (boo!) we did it on the gas grill. It turned out great!

Pizza on the stone.
Pizza on the stone. We used cornmeal to stop it from sticking to the peel, but I didn’t like the taste of crunchiness of the corn meal on the bottom of the cooked crust. So, I’m looking for alternatives

Cooked Pizza
Voila! Alfresco pizza, fresh from the grill.

Chef's aide
Chef’s aide

 

Cedar Plank Salmon with Teriyaki marinade

I had done this before, but this time I did it on the Charcoal grill.

Salmon fillets on the plank.
Salmon fillets on the plank.

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…

The finished product.
The finished product.

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.

Chicken Parmesan – Pub Comfort Food.

Homemade marinara sauce, good provolone and mozzorella cheese, fresh basil and panic crumb. Served pub style, with a cold beer. Yum.

Chicken Parmesan 1
Chicken Parmesan. Chicken has been panic breaded, and lightly fried. Top with marinara and cheese and bake.

Chicken Parmesan 2
Chicken Parmesan out of the oven. Next time, go heavier on the fresh basil. It got lost in all the cheese.

Chicken Parmesan 3
Chicken Parmesan has to be served with fries. These are oven baked from frozen. One day, I’ll have a fryer….