I spent several hours on the forums tonight reading through the threads of people having problems with such and couldn't get any of the fixes to work. Could someone please elaborate on why so many people have problems with it.

I wasn't able to get it working use the above command either. I think I finally got it working using :

The first command should work without problems. If you have problems with the second one, it's because there is another hostname than server1.example.com in the mysql.users table. You can forget about this now and correct it later with phpMyAdmin. Restart MySQL afterwards.

Thanks for the reply, but it makes me question if it truly is a copy-paste tutorial then since I did everything the same as the guide except for the IP. I even named it server1.example.com and used yourrootsqlpassword as the password.

Based upon the number of threads regarding this topic, it might be a good idea to explain in the tutorials that this should be expected and how to fix it. Or not even have them issue the second password change until phpmyadmin is installed.

In any case, the guides are a tremendous asset to newbies like me. I frequently see them linked to in other forums.