java.sql.SQLException: Authentication using username/password requires SSL to be enabled
Hi @dipankarbhattacharyy
Post "Diagnostic Info" from Admin > Troubleshooting.
Which version of Presto are you using?
As the errors says, you need to use SSL if you want to use username/password.
presto-server-0.271 also the local mysql connection also not working
database type: mysql
display name: local
port 3306
database name: mysql
user: root
and then password
error
Could not connect to address=(host=localhost)(port=3306)(type=master) : Socket fail to connect to host:localhost, port:3306. Connection refused (Connection refused)
but sql workbench can connect
Post "Diagnostic Info" from Admin > Troubleshooting.
If you are using Docker, then localhost
refers to the container, not the Docker host.
Thanks,worked.