Reputation: 35
I have a remote server hosting an application with a MySQL Database attached. I am trying to write a program to automated a process on the server. This required me to make a connection over SSH then connect and query the MySQL database.
Using Putty I can make a connection and connect to the database using the command "mysql -u root -p blah"
and query all I wish.
However, from my .NET application when I try to make a connection using sharpSSH and a connection string to MySQL I get the error :
"access denied for user 'root'@'localhost' (using password yes)"
Can it be an permission issue if I can connect using Putty or could it be a issue with one of the tools I am using?
The guide I followed can be found here - http://georgelantz.com/2007/09/10/access-mysql-through-ssh-tunnel-in-a-windows-net-application/
Upvotes: 1
Views: 2157