Hello,
I want to connect to MYSQL/mariaDB database with the DevArt Excel Add-in.
I use the same input as in MYSQL Workbench. In workbench it works, devart excel add-in refuses connection with the error code "Access denied for user....."
The seeting I use under Manage Connection are
Connection Parameters: Host, Port, User Id, Password and Connection Name
Under advanced:
SSH Authentication Type - PublicKey
SSH Host, SSH Port, SSH Private Key, SSH Strict Host Key Checking - False, SSH user.
Any idea how can I establish a working connection?
Connect to MariaDB with SSH
-
- Devart Team
- Posts: 2420
- Joined: Wed 02 Nov 2011 09:44
Re: Connect to MariaDB with SSH
The "Access denied for user....." error means that you have successfully connected to an SSH server but failed MySQL authentication. Please make sure that you specify a valid values for the user id and password parameters.msweijd wrote:devart excel add-in refuses connection with the error code "Access denied for user....."
-
- Devart Team
- Posts: 2420
- Joined: Wed 02 Nov 2011 09:44
Re: Connect to MariaDB with SSH
We could not reproduce the issue. We can successfully connect to a MariaDB database via SSH server. The "Access denied for user....." error means, that you successfully connect to SSH server, however, you have invalid pair of user id and password for the MariaDB database. Please make sure you use correct password and user id for MariaDB connection.