You can use this script to migrate mysql databases to a new server while keeping the users, passwords and rights. It will show you what databases to migrate (based on ...

SELECT CONCAT("CREATE USER '", user, "'@'",host,"' IDENTIFIED WITH mysql_native_password BY '", password, "'" ) FROM mysql.user where user not in ('root'); ...

Remembering to always back up a MySQL server can be difficult, but fortunately, there’s a script that can automate ... type their administration password. You could also hold down Ctrl, Alt and T to ...