Import file into MariaDB on Windows WSL

Asked Sep 16 '18 at 11:58

Active Sep 16 '18 at 11:58

Viewed 318 times

I'm trying to import a file into MariaDB on my WSL Subsystem on Windows, following this thread: https://stackoverflow.com/questions/17666249/how-to-import-an-sql-file-using-the-command-line-in-mysql

I have copied the .sql file to my home directory in WSL and hence my command looks like this:

$ mysql -u root -p sampledatabase < ~/databases/Datanmodell_init.sql

But I keep getting the following error:

ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using 
password: YES)

What am I doing wrong?

merci A

asked Sep 16 '18 at 11:58

aerioeus

1,348
1
16
41

Did you try with a normal user? – Biswapriyo Sep 16 '18 at 12:40
I have tried it with and without `sudo` - no difference. – aerioeus Sep 16 '18 at 13:08
The password is for MySQL's "root", not the OS. – Rick James Oct 05 '18 at 05:27
@Rick what do you mean by that? – aerioeus Oct 05 '18 at 09:47
The error message says you used the wrong password. – Rick James Oct 05 '18 at 18:00

Import file into MariaDB on Windows WSL

0 Answers0