0

I have MySQL database hosted on server. I want to create WCF web service of that database. Actually I want to comsume WCF service in Windows Store App. I am following these articles.

Using an Entity Framework Entity as a Windows Forms Data Source

Making a Connection

But I am getting error Authentication with old password no longer supported, use 4.1 style passwords. Then searched Stack Overflow and got this solution, but it is also not working for me.

Please guide me to solve this issue.

PS : Please don't down vote this question, I have googled and searched in Stack Overflow but didn't get solution :(

UPDATE 1

I have applied command via phpMyAdmin in SQL query textbox. I also followed this Mysql password hashing method old vs new, but getting same error that "you have no SUPER privilege."

Community
  • 1
  • 1
Farhan Ghumra
  • 15,180
  • 6
  • 50
  • 115
  • How did you issue these commands? (mysql console or some GUI ?) Also, what is the version of the MySQL server you are connecting to? – RandomSeed Apr 24 '13 at 15:16
  • I applied commands from phpMyAdmin. I first open database and then applied commnads from SQL query textbox. Server version in 5.5.28-29.3-log – Farhan Ghumra Apr 24 '13 at 15:22
  • It appears I had a wrong assumption in believing that issuing `SET SESSION old_passwords=0;` from PhpMyAdmin could cause an issue. I just tested and it really works fine. Please issue the following command: `SELECT user, host, password FROM mysql.user`. All values in the `password` column should begin with a `*` (star), is it the case? – RandomSeed Apr 24 '13 at 15:45
  • I am getting error `SELECT command denied to user 'XXXXXX'@'localhost' for table 'user'` while issuing command `SELECT user, host, password FROM mysql.user`, please my update 1. – Farhan Ghumra Apr 24 '13 at 15:52
  • Then I am afraid you will have ask to be granted the SUPER privilege, or ask the administrator to run these commands for you. I assume you received a warning when you ran the first `SET PASSWORD` command, didn't you? – RandomSeed Apr 24 '13 at 15:57
  • No, I didn't get problem. I have doubt that when I issue `SET SESSION old_passwords=0;` it has scope of only browser. So Visual Studio is throwing error still. – Farhan Ghumra Apr 24 '13 at 15:59

1 Answers1

0

I have not managed to solve the problem as the others who have responded, although I tried out everything that has been proposed. In the end it turned out that the server on which stood my DB is not updated phpMyAdmin since version 3.5.5, and is currently being used everywhere version 4.1.14 and it is a problem. The solution is to update your host phpMyAdmin or your own mySQL back to an earlier version in order to continue working on remote DB. You may need this knowledge in order to solve some doubts that have arisen. :)

Stanojkovic
  • 1,612
  • 1
  • 17
  • 24