this my new bench with old data restore given error
eipl@eiplerp:~/frappe-bench$ bench frappe --restore restore xxxxxx_xxxxxx_database.sql
MySQL root password:
Traceback (most recent call last):
File “/home/eipl/frappe-bench/env/bin/frappe”, line 9, in
load_entry_point(‘frappe==4.14.0’, ‘console_scripts’, ‘frappe’)()
File “/home/eipl/frappe-bench/apps/frappe/frappe/cli.py”, line 53, in main
return run(fn, parsed_args)
File “/home/eipl/frappe-bench/apps/frappe/frappe/cli.py”, line 81, in run
out = globals().get(fn)(*args.get(fn), **args)
File “/home/eipl/frappe-bench/apps/frappe/frappe/cli.py”, line 67, in new_fn
return fn(*args, **new_kwargs)
File “/home/eipl/frappe-bench/apps/frappe/frappe/cli.py”, line 386, in restore
_install(db_name, source_sql=source_sql, quiet=quiet, force=force)
File “/home/eipl/frappe-bench/apps/frappe/frappe/cli.py”, line 317, in _install
admin_password = admin_password, verbose=verbose, force=force, site_config=site_config, reinstall=reinstall)
File “/home/eipl/frappe-bench/apps/frappe/frappe/installer.py”, line 31, in install_db
create_database_and_user(force, verbose)
File “/home/eipl/frappe-bench/apps/frappe/frappe/installer.py”, line 48, in create_database_and_user
if force or (db_name not in dbman.get_database_list()):
File “/home/eipl/frappe-bench/apps/frappe/frappe/model/db_schema.py”, line 359, in get_database_list
return [d[0] for d in self.db.sql(“SHOW DATABASES”)]
File “/home/eipl/frappe-bench/apps/frappe/frappe/database.py”, line 79, in sql
self.connect()
File “/home/eipl/frappe-bench/apps/frappe/frappe/database.py”, line 49, in connect
use_unicode=True, charset=‘utf8’)
File “/home/eipl/frappe-bench/env/local/lib/python2.7/site-packages/MySQLdb/init.py”, line 81, in Connect
return Connection(*args, **kwargs)
File “/home/eipl/frappe-bench/env/local/lib/python2.7/site-packages/MySQLdb/connections.py”, line 193, in init
super(Connection, self).init(*args, **kwargs2)
_mysql_exceptions.OperationalError: (1045, “Access denied for user ‘root’@‘localhost’ (using password: YES)”)
You are using a wrong mysql password.
Check the root mysql password entered and retry with the correct password is what this error say AFAIK.