Databases
StackOverflow2013
Postsdbo
POAuthentication with old password no longer supported, use 4.1 style passwords
Body
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POAuthentication with old password no longer supported, use 4.1 style passwords
    text
    copied!<p>I have my website with hostgator and I want to access mysql database with C# windows application but when I tried to connect got this message: </p> <blockquote> <p>"Authentication with old password no longer supported, use 4.1 style password"</p> </blockquote> <p>I have tried given solution: </p> <pre><code>SET SESSION old_passwords=0; SET PASSWORD FOR user@host=PASSWORD('your pw here'); </code></pre> <p>first query executed successfully but I got the error "Access denied for user@host" when second query executed. I can't understand why there is this problem. I am using MySQL-connecter-net 6.6.5.</p> <p>I successfully connect my database with MySql workbench 5.2.47.</p> <p>Can anyone help me what I can do more?</p> <hr> <p>I have contact my hosting site and they make changes to my.cnf file to use 4.1 style password. and i am able to connect with mysql </p> <pre><code>mysql -u &lt;username&gt; -p &lt;password&gt; -h &lt;hostname&gt;; </code></pre> <p>but when i tried to connect with C# with mySQL connecter net 6.6.5 i again got this error.</p> <p>I am using Visual Studio 2012 with MySQL connector 6.6.5 on Windows 8 64 bit. this is the code i used to connect</p> <pre><code>using MySQL.Data.MySQLClient; private void button1_Click(object sender, EventArgs e) { string connStr = String.Format("server={0};port={1};uid={2};password={3};database={4}", txtserver.Text, txtPort.Text, txtUser.Text, txtPassword.Text, txtDatabase.Text); conn = new MySqlConnection(connStr); try { conn.Open(); MessageBox.Show("Test Connection Succeded"); } catch (MySqlException ex) { MessageBox.Show(ex.Message); } } </code></pre> <p>I can't understand where the problem is. Please Help me</p>
 

Querying!

 
Guidance
An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload