Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>edit: This only applies if you are in control of the MySQL server... if you're not take a look at <a href="https://stackoverflow.com/q/1892607/1341006">Mysql password hashing method old vs new</a></p> <p>First check with the SQL query</p> <pre><code>SHOW VARIABLES LIKE 'old_passwords' </code></pre> <p>(in the MySQL command line client, <a href="http://www.heidisql.com/" rel="nofollow noreferrer">HeidiSQL</a> or whatever front end you like) whether the server is set to use the old password schema by default. If this returns <code>old_passwords,Off</code> you just happen to have old password entries in the <code>user</code> table. The MySQL server will use the old authentication routine for these accounts. You can simply set a new password for the account and the new routine will be used. </p> <p>You can check which routine will be used by taking a look at the <code>mysql.user</code> table (with an account that has access to that table)</p> <pre><code>SELECT `User`, `Host`, Length(`Password`) FROM mysql.user </code></pre> <p>This will return <em>16</em> for accounts with old passwords and <em>41</em> for accounts with new passwords (and 0 for accounts with no password at all, you might want to take care of those as well).<br> Either use the user management tools of the MySQL front end (if there are any) or</p> <pre><code>SET PASSWORD FOR 'User'@'Host'=PASSWORD('yourpassword'); FLUSH Privileges; </code></pre> <p>(replace <code>User</code> and <code>Host</code> with the values you got from the previous query.) Then check the length of the password again. It should be <em>41</em> now and your client (e.g. mysqlnd) should be able to connect to the server.</p> <p>see also the MySQL documentation: * <a href="http://dev.mysql.com/doc/refman/5.0/en/old-client.html" rel="nofollow noreferrer">http://dev.mysql.com/doc/refman/5.0/en/old-client.html</a><br> * <a href="http://dev.mysql.com/doc/refman/5.0/en/password-hashing.html" rel="nofollow noreferrer">http://dev.mysql.com/doc/refman/5.0/en/password-hashing.html</a><br> * <a href="http://dev.mysql.com/doc/refman/5.0/en/set-password.html" rel="nofollow noreferrer">http://dev.mysql.com/doc/refman/5.0/en/set-password.html</a></p>
    singulars
    1. This table or related slice is empty.
    1. POCannot connect to MySQL 4.1+ using old authentication
      singulars
      1. PTQuestion
    1. PTAnswer
    1. UStuomassalo
    1. USVolkerK
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. POCannot connect to MySQL 4.1+ using old authentication
      singulars
      1. PTQuestion
    1. This table or related slice is empty.
    1. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    3. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    1. COThanks for the detailed answer. I was able to connect with a gui client, and old_passwords is indeed "ON". I thought I had something when i "set old_password = OFF", but when i started a new session it was back on again.
      singulars
      1. PO
      1. USB T
    2. COOops, I didn't realize that you're not in control of the server (some kind of latent text blindness). In that case I think Charles is right. Or... maybe not all of the servers at bluesql.net are configured to use short password hashes. And maybe, if you ask them, you can be transferred to another server.
      singulars
      1. PO
      1. USVolkerK
    3. COGreat answer. I needed to do `SET old_passwords = 0;` to get this to work, taken from Elliot Yap's answer below.
      singulars
      1. PO
      1. UShomerjam
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

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