I have just installed Dremio in my laptop and trying to connect to MySQL database. MySQL has the default user “root”.
When i try this from Dremio - User Interface - MYSQL source - it shows up the below error message
Form entry: Host: localhost Port: 3306 Authentication: Tried both options User: root and given password
Failure while configuring source [mysql]. Info: Unavailable: Could not connect: Access denied for user ‘root’@‘localhost’ (using password: NO)
I tried, changing the localhost to my computer name, IP address. but no luck.
Am i missing any basics here?
Hi,
I have created another user called “newuser” and granted all required permissions to schema.
In fact, I have made this user as DBA. I am just working with a sample database.
I am able to connect using Mysql workbench, but not able to connect from Dremio.
I have attached the word document with screenshots. Could you help or point anything that I am missing?
I still have problem with MySQL connection even if SSL is disabled.
There’s failure with configuring source and a server log file’s record says there’s no password passed
<<Caused by: java.lang.Exception: Unavailable: Could not connect: Access denied for user ‘root’@‘localhost’ (using password: NO)>>
Is there any remedietion for this ?
Regards,
Tom