When I run:
---mysql> SET PASSWORD FOR 'garrett'@'localhost' = PASSWORD('abc123');
I get:
---ERROR 1133 (42000): Can't find any matching row in the user table
Also, when I run:
---mysql> UPDATE mysql.user SET Password=PASSWORD('abc123') WHERE User='garrett' AND Host='localhost';
I get:
---Query OK, 0 rows affected (0.00 sec)
---Rows matched: 0 Changed: 0 Warnings: 0
So then to test this I exit and login as my user name, garrett
mysql -u garrett -p
Enter password: abc123
---ERROR 1045 (28000): Access denied for user 'garrett'@'localhost' (using password: YES)
Any ideas?