Answers.Body: <p>This problem was solved via the related question on Stack Overflow here: <a href="https://stackoverflow.com/a/1576473/1586560">Cannot connect to MySQL 4.1+ using old authentication</a></p>
  
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2015-08-23T06:13:04.990Z
Answers.LastActivityDate: 2015-08-23T06:13:04.990Z
Answers.LastEditDate: 2017-05-23T12:38:53.957Z
Answers.UserDisplayName: Ben Parizek
Body: <p>i've got this error: </p>
  
  <blockquote>
    <p>[error] [exception.CDbException] SQLSTATE[HY000] [2000] mysqlnd
    cannot connect to MySQL 4.1+ using the old insecure authentication.
    Please use an administration tool to reset your password with the
    command SET PASSWORD = PASSWORD('your_existing_password'). This will
    store a new, and more secure, hash value in mysql.user. If this user
    is used in other scripts executed by PHP 5.2 or earlier you might need
    to remove the old-passwords flag from your my.cnf file</p>
  </blockquote>
  
  <p>i've already set a new password in the webspace, but the error is the same.</p>
  
  <p>Is there any other way to solve this problem?</p>
  
Comments.ContentLicense: CC BY-SA 3.0
Comments.CreationDate: 2015-08-14T11:57:21.100Z
Comments.Text: If someone has the same problem. Here is the answer:
  http://stackoverflow.com/questions/1575807/cannot-connect-to-mysql-4-1-using-old-authentication
Comments.UserDisplayName: Jonathan Schiffner
Comments.ContentLicense: CC BY-SA 3.0
Comments.CreationDate: 2015-08-14T15:27:54.867Z
Comments.Text: Can you add that as an official answer?
Comments.UserDisplayName: Brad Bell
Comments.ContentLicense: CC BY-SA 3.0
Comments.CreationDate: 2017-05-09T23:36:02.267Z
Comments.Text: Hey Jonathan, would you mind either accepting Ben's answer (if that solved the problem) or adding your own here and accepting it?
Comments.UserDisplayName: Matt Stein
Tags: <database><error-message>
Title: db password problem
ThreadText: # db password problem
  
  (Asked by: username_0 on 2015-08-14)
  
  i've got this error:
  
  > [error] [exception.CDbException] SQLSTATE[HY000] [2000] mysqlnd
  > cannot connect to MySQL 4.1+ using the old insecure authentication.
  > Please use an administration tool to reset your password with the
  > command SET PASSWORD = PASSWORD('your\_existing\_password'). This will
  > store a new, and more secure, hash value in mysql.user. If this user
  > is used in other scripts executed by PHP 5.2 or earlier you might need
  > to remove the old-passwords flag from your my.cnf file
  
  i've already set a new password in the webspace, but the error is the same.
  
  Is there any other way to solve this problem?
  
  **Tags:** database, error-message
  
  > **Comments:**
  > **username_0**: If someone has the same problem. Here is the answer: http://stackoverflow.com/questions/1575807/cannot-connect-to-mysql-4-1-using-old-authentication  
  > **username_1**: Can you add that as an official answer?  
  > **username_2**: Hey username_0, would you mind either accepting Ben's answer (if that solved the problem) or adding your own here and accepting it?  
  
  ---
  
  ## 1 answers
  
  ### Answer by username_3 on 2015-08-23. Score: 3 | Accepted answer
  
  This problem was solved via the related question on Stack Overflow here: [Cannot connect to MySQL 4.1+ using old authentication](https://stackoverflow.com/a/1576473/1586560)
  
  
  ---
  
  