I'm in the process of importing data manually from a plesk install into ISPConfig3. I just imported my mysql databases and locked myself out of mysql, and resetting the mysql root password doesn't seem to to work. I'm on ubuntu 14.04, using the tutorials on this site to build the setup. The problem seems to be that on the previous server, root could not login from localhost, so that grant was never setup. When you skip the grant tables, it won't let you modify them (duh). So loading mysql when skipping them, allows you to change the password, but you still don't have permission to login as root from localhost. I can login as a custom account called admin, but it has no grant permissions. Anyone have an idea of how to modify the grant table without knowing how to login as root? Thanks much!