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!


Amiga demos

my favourite memory of the Amiga 500 with Three floppy drives (ehem)     

Spaceballs: 9 fingers

The Asian (Japanese?) characters are flicked up to the screen as part of the memory management routines in order to present a visual experience to fill in the gaps caused by the CPU was busy moving blocks of memory around. It’s fun to watch how some of these sequences are longer than others and how they seem to convey a sense of urgency. 

Consider also there were no such things as video codecs. This was basically all written in straights home code. 

And the soundtrack was written as a mod file, essentially a music script file, which is a dedicated sound chip which could be coded in advance and run in parallel. 

And the whole thing fit on 3 floppy disks, 880 Kilobyte each. I had my (ehem) 3 floppy drives on a daisy chain and was basically rocking it.  

Lotus Notes 8.5 Is Using Obselete Timezone codes

As part of this week’s email debacle, I had to manually forward a bunch of meeting requests from my LN account to my Outlook account.

In doing this, I discovered a time-zone abbreviation that not even, my go-to for time-zone converting, recognised.

Some Google-Fu turned up this page from IBM, which describes these time-zones. The search also turned up this Bugzilla bug report, wherein I learnt:

RFC 2822 clearly says time zone like ZE5B is obsolete

Which should come as no surprise.

Lotus Notes Search Fail

One of the strengths of Lotus Notes is that it is fundamentally a database, with bullet proof synchronisation.

One of the downfalls of Lotus Notes is that it is fundamentally a database with an aggressive hatred of its users.

Here is a classic example. To create a custom searches, you are presented with this drop-down list of the available fields you can search on.

Lotus Notes - Search by field selector

Look at the size of the scroll handle! There are literally hundreds (thousands?) of fields to select from. Good luck getting the right one.