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!
my favourite memory of the Amiga 500 with Three floppy drives (ehem)
Spaceballs: 9 fingers http://youtu.be/Nln80hiP5AY
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.