Unable to restore database: existing crypted password is '(null)' for query

[zEitEr]

Hello,

When restoring accounts from possibly old Linux servers, we have an issue if no default user exists in MySQL DB:

existing crypted password is '(null)' for query:
SELECT password FROM mysql.user WHERE user='userbob' AND host='localhost'

Unable to restore database userbob&#95p.sql to userbob_p: ERROR 1045 (28000): Access denied for user 'userbob'@'localhost' (using password: NO)


Unable to restore database userbob&#95root.sql to userbob_root: ERROR 1045 (28000): Access denied for user 'userbob'@'localhost' (using password: NO)


Unable to restore database userbob&#95root&#53&#52.sql to userbob_root54: ERROR 1045 (28000): Access denied for user 'userbob'@'localhost' (using password: NO)


Unable to restore database userbob&#95server.sql to userbob_server: ERROR 1045 (28000): Access denied for user 'userbob'@'localhost' (using password: NO)


Unable to restore database userbob&#95test.sql to userbob_test: ERROR 1045 (28000): Access denied for user 'userbob'@'localhost' (using password: NO)


Unable to restore database userbob&#95userbob.sql to userbob_userbob: ERROR 1045 (28000): Access denied for user 'userbob'@'localhost' (using password: NO)

Probably we could have it fixed by assigning a new password or creating default user in MySQL DB with a new password on restore?