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

Problems with the Windows version of XAMPP, questions, comments, and anything related.

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

Postby axiomcs » 02. November 2018 20:38

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
axiomcs
 
Posts: 11
Joined: 08. October 2018 21:13
XAMPP version: 3.2.2
Operating System: Windows Server 2012

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

Postby Altrea » 02. November 2018 21:35

On your original machine you setted a password for the MySQL user root which has not been done on the other installations.
We don't provide any support via personal channels like PM, email, Skype, TeamViewer!

It's like porn for programmers 8)
User avatar
Altrea
AF Moderator
 
Posts: 11926
Joined: 17. August 2009 13:05
XAMPP version: several
Operating System: Windows 11 Pro x64


Return to XAMPP for Windows

Who is online

Users browsing this forum: No registered users and 117 guests