Jonoh89
Jonoh89

Reputation: 35

MySQL over SSH "access denied for user 'root'@'localhost' (using password yes)"

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

Answers (0)

Related Questions