Databases
StackOverflow2013
Postsdbo
POMysql password hashing method old vs new
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POMysql password hashing method old vs new
    primarykey
    data
    text
    <p>I'm trying to connect to a mysql server at dreamhost from a php scrip located in a server at slicehost (two different hosting companies). I need to do this so I can transfer new data at slicehost to dreamhost. Using a dump is not an option because the table structures are different and i only need to transfer a small subset of data (100-200 daily records) The problem is that I'm using the new MySQL Password Hashing method at slicehost, and dreamhost uses the old one, So i get </p> <pre><code>$link = mysql_connect($mysqlHost, $mysqlUser, $mysqlPass, FALSE); Warning: mysql_connect() [function.mysql-connect]: OK packet 6 bytes shorter than expected Warning: mysql_connect() [function.mysql-connect]: mysqlnd cannot connect to MySQL 4.1+ using old authentication Warning: mysql_query() [function.mysql-query]: Access denied for user 'nodari'@'localhost' (using password: NO) </code></pre> <p>facts: </p> <ul> <li>I need to continue using the new method at slicehost and i can't use an older php version/library</li> <li>The database is too big to transfer it every day with a dump</li> <li>Even if i did this, the tables have different structures</li> <li>I need to copy only a small subset of it, in a daily basis (only the changes of the day, 100-200 records)</li> <li>Since the tables are so different, i need to use php as a bridge to normalize the data</li> <li>Already googled it</li> <li>Already talked to both support stafs</li> </ul> <p>The more obvious option to me would be to start using the new MySQL Password Hashing method at dreamhost, but they will not change it and i'm not root so i can't do this myself.</p> <p>Any wild idea?</p> <p>By VolkerK sugestion:</p> <pre><code>mysql&gt; SET SESSION old_passwords=0; Query OK, 0 rows affected (0.01 sec) mysql&gt; SELECT @@global.old_passwords,@@session.old_passwords, Length(PASSWORD('abc')); +------------------------+-------------------------+-------------------------+ | @@global.old_passwords | @@session.old_passwords | Length(PASSWORD('abc')) | +------------------------+-------------------------+-------------------------+ | 1 | 0 | 41 | +------------------------+-------------------------+-------------------------+ 1 row in set (0.00 sec) </code></pre> <p>The obvious thing now would be run a mysql> SET GLOBAL old_passwords=0; But i need SUPER privilege to do that and they wont give it to me</p> <p>if I run the query</p> <pre><code>SET PASSWORD FOR 'nodari'@'HOSTNAME' = PASSWORD('new password'); </code></pre> <p>I get the error</p> <pre><code>ERROR 1044 (42000): Access denied for user 'nodari'@'67.205.0.0/255.255.192.0' to database 'mysql' </code></pre> <p>I'm not root...</p> <p>The guy at dreamhost support insist saying thet the problem is at my end. But he said he will run any query I tell him since it's a private server. So, I need to tell this guy EXACTLY what to run. So, telling him to run</p> <pre><code>SET SESSION old_passwords=0; SET GLOBAL old_passwords=0; SET PASSWORD FOR 'nodari'@'HOSTNAME' = PASSWORD('new password'); grant all privileges on *.* to nodari@HOSTNAME identified by 'new password'; </code></pre> <p>would be a good start?</p>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. USOMG Ponies
    1. USThe Disintegrator
    plurals
    1. PL
      singulars
      1. LTLinked
    1. PL
      singulars
      1. LTLinked
    2. PL
      singulars
      1. LTLinked
    3. PL
      singulars
      1. LTLinked
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    2. PO
      singulars
      1. PTAnswer
    3. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POMysql password hashing method old vs new
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. POMysql password hashing method old vs new
      1. This table or related slice is empty.
      1. VTUpMod
    3. VO
      singulars
      1. POMysql password hashing method old vs new
      1. This table or related slice is empty.
      1. VTUpMod
    1. CO`SET SESSION old_passwords=0` should suffice, there's no need to change the global setting for this one-shot solution (otherwise they could simply restart the mysqld without that option). I've tested it on my local 5.1.37 server. To confirm that a new hash is really "new" let the support guy run the query `SELECT \`Host\`, Length(\`PASSWORD\`) FROM mysql.user WHERE \`User\`='nodari'`. Remeber: 41 is good, 16 is old=bad ;-)
      singulars
      1. POMysql password hashing method old vs new
      1. USVolkerK
    2. COOh, and I'd try it without the grant thing first. It shouldn't be necessary for your existing account. It probably doesn't hurt either but introduces a new question: "Does 'identified by' obey exactly the same rules as PASSWORD()?" Most likely, but you never know ;-)
      singulars
      1. POMysql password hashing method old vs new
      1. USVolkerK
    3. COit's not a one time thing, i will need to do this in a daily basis during a time... And i asume than in the next reboot this old_password thing will be back to bite me in the ass
      singulars
      1. POMysql password hashing method old vs new
      1. USThe Disintegrator
 

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