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?
Thank you!! for your time in answering this