More a MySQL question than Drupal

Posted by jfha73 on May 15, 2012 at 10:37pm

I was trying to move my current Drupal 7.14 from MySQL 5.1 on Windows to MySQL 5.5 on Linux, everything looked good until I tried to login, it doesn't recognize any password I put for any user, has anybody encounter this before?

I tried doing a:

UPDATE user SET pass=PASSWORD('mypassword') WHERE user="anyuser"

To see if this works, but it did not.

Any ideas?

Comments

Hey guys, I just tried this

Posted by jfha73 on May 17, 2012 at 8:40pm

Hey guys,

I just tried this to see if it works:

Created a clean install of Drupal 7 in the Linux system, I assign User1 a password, then I replaced the password of User1 in the one that is not working with the one from the clean working one, but still doesn't work, what can be wrong? the only differences are:

Mysql 5.1 on Windows <-> MySQL 5.5 on Linux
Drupal on Windows machine is an upgrade from D6

What can I do to solve this problem?

Thanks

mysql

Posted by sdramos on May 18, 2012 at 10:17pm

fisrt case, if you change password in mysql, dont forget to modify password in file settings.php.
second case, maybe user of Drupal is blocked.

Answer to case number 1: I'm

Posted by jfha73 on May 21, 2012 at 1:44pm

Answer to case number 1: I'm not talking about the user tat connects to the database, I'm talking about a drupal user, or at least that's the only password I see in settings.php

Answer to case number 2: the users I tried are all active.

Also happening with Drupal 6

Posted by jfha73 on May 21, 2012 at 2:10pm

I have never encounter something like this, I just tried to do the same with a Drupal 6 site instead and the same exact thing happened, no user can login to the site.

I don't know how Drupal encrypts users passwords, but it's definitely not working when you upgrade the database, in my case from MySQL 5.1 on Windows to MySQL 5.5 on Linux

I never had this problem going from MySQL 5.1 on Linux to MySQL 5.1 on Linux and I think I even tried it from 5.1 on Windows to 5.1 on Linux or the opposite way with no problems.

It is confirmed

Posted by jfha73 on May 21, 2012 at 3:18pm

I just tried to move my site from MySQL 5.1 on Windows to MySQL 5.1 on Linux and it worked, so something must have changed in MySQL 5.5 that breaks the ability to move a Drupal site from MySQL 5.1 to MySQL 5.5

Make sure that apache

Posted by DanChadwick on January 27, 2013 at 1:22am

Make sure that apache mod_rewrite is enabled. If it isn't and Clean URLs is on, the server will receive an empty $_POST array for any form, including the log-in form.