MySQL not working

All,

I hate MySQL issues, none of the HOWTOs ever get close to solving your problems. So on the New Server (old server but upgraded to 18.04 LTS) I get MySQL install, but nothing works because there are 20 users that have to be create.

I have the users and their "CREATE" statements in a .sql file and normally you run the cmd:

Code:mysql -u root -p < myuserfile.sqlAnd it's done!

But no nothing but errrors and working on this for over 24 hrs, find this HOWTO at:

Quote:

https://serverfault.com/questions/48...-for-root-user

So I run it! Now cannot even login to MySQL and getting errors:

Quote:

ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)

This is why I hate NySQL errors as non of the HOWTOs work! They always make the proble worse!

Need some real help here!

TBNK