I was able to connect to the other server without any issues.  Somehow having a problem connecting to this particular server.  I have installed a mysql client on my presto server and tested connection using mysql client and got connected without any problems, so I know it is not host issue.

 I am running out of ideas. And need help with what else I can check or debug ideas.  Look at the message presto thinks that my user does not have privileges, but that is not the case since I am able to connect that user via mysql client on the same presto host.

thanks so much.

Here are my catalog

connector.name=mysql

connection-url=jdbc:mysql://hostname.domain.com:3306?enabledTLSProtocols=TLSv1.2&autoReconnect=true&useSSL=false

autoReconnect=true&useSSL=false

connection-user=*****

connection-password=***

2022-04-19T16:47:40.205-0400 DEBUG Query-20220419_204735_00001_6fn6v-176 com.facebook.presto.execution.QueryStateMachine Query 20220419_204735_00001_6fn6v failed

com.facebook.presto.spi.PrestoException: Could not create connection to database server. Attempted reconnect 3 times. Giving up.

at com.facebook.presto.plugin.jdbc.BaseJdbcClient.getTableNames(BaseJdbcClient.java:193)

at com.facebook.presto.plugin.jdbc.JdbcMetadata.listTables(JdbcMetadata.java:113)

at com.facebook.presto.spi.connector.classloader.ClassLoaderSafeConnectorMetadata.listTables(ClassLoaderSafeConnectorMetadata.java:260)

at com.facebook.presto.metadata.MetadataManager.listTables(MetadataManager.java:570)

at com.facebook.presto.connector.informationSchema.InformationSchemaMetadata.lambda$calculatePrefixesWithTableName$7(InformationSchemaMetadata.java:304)

at java.util.stream.ReferencePipeline$7$1.accept(ReferencePipeline.java:269)

at java.util.Iterator.forEachRemaining(Iterator.java:116)

at java.util.Spliterators$IteratorSpliterator.forEachRemaining(Spliterators.java:1801)

at java.util.stream.AbstractPipeline.copyInto(AbstractPipeline.java:482)

at java.util.stream.AbstractPipeline.wrapAndCopyInto(AbstractPipeline.java:472)

at java.util.stream.ReduceOps$ReduceOp.evaluateSequential(ReduceOps.java:708)

at java.util.stream.AbstractPipeline.evaluate(AbstractPipeline.java:234)

at java.util.stream.ReferencePipeline.collect(ReferencePipeline.java:566)

at com.facebook.presto.connector.informationSchema.InformationSchemaMetadata.calculatePrefixesWithTableName(InformationSchemaMetadata.java:308)

at com.facebook.presto.connector.informationSchema.InformationSchemaMetadata.getTableLayouts(InformationSchemaMetadata.java:242)

at com.facebook.presto.metadata.MetadataManager.getLayout(MetadataManager.java:396)

at com.facebook.presto.sql.planner.iterative.rule.PickTableLayout.pushPredicateIntoTableScan(PickTableLayout.java:306)

at com.facebook.presto.sql.planner.iterative.rule.PickTableLayout.pushPredicateIntoTableScan(PickTableLayout.java:251)

at com.facebook.presto.sql.planner.iterative.rule.PickTableLayout$PickTableLayoutForPredicate.apply(PickTableLayout.java:137)

at com.facebook.presto.sql.planner.iterative.rule.PickTableLayout$PickTableLayoutForPredicate.apply(PickTableLayout.java:102)

at com.facebook.presto.sql.planner.iterative.IterativeOptimizer.transform(IterativeOptimizer.java:168)

at com.facebook.presto.sql.planner.iterative.IterativeOptimizer.exploreNode(IterativeOptimizer.java:141)

at com.facebook.presto.sql.planner.iterative.IterativeOptimizer.exploreGroup(IterativeOptimizer.java:106)

at com.facebook.presto.sql.planner.iterative.IterativeOptimizer.exploreChildren(IterativeOptimizer.java:191)

at com.facebook.presto.sql.planner.iterative.IterativeOptimizer.exploreGroup(IterativeOptimizer.java:108)

at com.facebook.presto.sql.planner.iterative.IterativeOptimizer.exploreChildren(IterativeOptimizer.java:191)

at com.facebook.presto.sql.planner.iterative.IterativeOptimizer.exploreGroup(IterativeOptimizer.java:108)

at com.facebook.presto.sql.planner.iterative.IterativeOptimizer.optimize(IterativeOptimizer.java:95)

at com.facebook.presto.sql.planner.LogicalPlanner.plan(LogicalPlanner.java:196)

at com.facebook.presto.sql.planner.LogicalPlanner.plan(LogicalPlanner.java:184)

at com.facebook.presto.execution.SqlQueryExecution.lambda$doAnalyzeQuery$2(SqlQueryExecution.java:448)

at com.facebook.presto.common.RuntimeStats.profileNanos(RuntimeStats.java:129)

at com.facebook.presto.execution.SqlQueryExecution.doAnalyzeQuery(SqlQueryExecution.java:446)

at com.facebook.presto.execution.SqlQueryExecution.analyzeQuery(SqlQueryExecution.java:432)

at com.facebook.presto.execution.SqlQueryExecution.start(SqlQueryExecution.java:368)

at com.facebook.presto.$gen.Presto_0_272_d93d0d8____20220419_204602_1.run(Unknown Source)

at com.facebook.presto.execution.SqlQueryManager.createQuery(SqlQueryManager.java:266)

at com.facebook.presto.dispatcher.LocalDispatchQuery.lambda$startExecution$8(LocalDispatchQuery.java:197)

at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)

at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)

at java.lang.Thread.run(Thread.java:750)

Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Could not create connection to database server. Attempted reconnect 3 times. Giving up.

at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)

at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)

at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)

at java.lang.reflect.Constructor.newInstance(Constructor.java:423)

at com.mysql.jdbc.Util.handleNewInstance(Util.java:425)

at com.mysql.jdbc.Util.getInstance(Util.java:408)

at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:919)

at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:898)

at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:887)

at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:861)

at com.mysql.jdbc.ConnectionImpl.connectWithRetries(ConnectionImpl.java:2095)

at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2020)

at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:768)

at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:47)

at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)

at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)

at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)

at java.lang.reflect.Constructor.newInstance(Constructor.java:423)

at com.mysql.jdbc.Util.handleNewInstance(Util.java:425)

at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:385)

at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:323)

at com.facebook.presto.plugin.jdbc.DriverConnectionFactory.openConnection(DriverConnectionFactory.java:82)

at com.facebook.presto.plugin.jdbc.BaseJdbcClient.getTableNames(BaseJdbcClient.java:180)

... 40 more

Caused by: java.sql.SQLException: Access denied for user 'nc '@'eco-spark-worker09.rtp.openeng.netapp.com' (using password: YES)

at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:965)

at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3933)

at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3869)

at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:864)

at com.mysql.jdbc.MysqlIO.proceedHandshakeWithPluggableAuthentication(MysqlIO.java:1707)

at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1217)

at com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2189)

at com.mysql.jdbc.ConnectionImpl.connectWithRetries(ConnectionImpl.java:2036)

... 52 more