Page 1 of 1

Dump/import db on original comp ok, but not on another comp

PostPosted: 02. November 2018 20:38
by axiomcs
Xampp 5.6.24 on both comps. Original comp is Windows 2012 Server, the other is Windows 7.

Using cli on both.

These 2 commands work on the Windows 2012 Server
Dump command: mysqldump -u root -pPassword --opt --result-file=c:\path\to\folder\joomla_db.sql db_name
Import command: mysql -u root -pPassword -D db_name < c:\path\to\folder\joomla_db.sql

On the Windows 7 comp. the import command results in:
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)

Or in a similar fashion.
On the Windows 2012 Server,
I dumped the db per the above command.
I uninstalled xampp 5.6.24.
I installed xampp 7.2.11.
Started apache and mysql.
Did the import command from above and got the same result:
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)

Can anyone tell me why? Or offer suggestions?

Thanks

Re: Dump/import db on original comp ok, but not on another c

PostPosted: 02. November 2018 21:35
by Altrea
On your original machine you setted a password for the MySQL user root which has not been done on the other installations.