[barryccampbell]

Ok, here are the files you requested:

I did local and host with same password before sync.

I did host with different password before sync.

I did local and host after sync (synced from host to local).

I also included the php script I wrote to save, update, and login for this exercise.

On performing these dumps, I did notice the password hash on my local table was much bigger than the password hash on the host table.

I then looked at the table type. Apparently, using sqlyog to create both tables locally and on host, my local table sets up a default InnoDB table whereas the host table sets up a default MyISAM table.

After realizing this, I attempted to change the table type on my local machine to match the host. Still could not login. I dropped the local table, and synced, having the new table created to match the host. Still could not login.

Apparently, sqlyog is doing what it is supposed to do, because the data is matching exactly after a sync, but I still can't explain why the passwords are saved differently on the host vs local. I know this may be the end of this thread, because sqlyog is doing its job, but do you have an idea of why the passwords look differently on (supposedly) identical setups? If so, do you know how to fix it?

Thank you again. If you cannot help me with the previous questions, I understand. SQLyog is working correctly.

[barryccampbell]

Thanks for responding. Actually, it does have to do with the data synchronizing. Here is the current configuration:

Web Host:

A user inputs information into the web page with user name and password. Both are saved in mysql 5, with the password encrypted. The user can then log in with the user name and password entered from the web and login is successful.

Local Host:

User can enter information into the web page hosted locally for testing with user name and password. Both are saved in mysql 5, with the password encrypted. The user can then log in with that user name and password, locally on the testing server and login is successful.

When I run the Database Synchronization Wizard and pull all the information from the web host mysql to the local host mysql, I can't log in to the local web based testing page application using the password that works on the web host. The local host only recognizes passwords entered through the local testing server. The web host application only recognizes passwords entered through the web based application. Both applications are the same. Only problem I'm having is the password recognition from local to web, and vise versa. All other database calls from the application pulls and displays information exactly as it was entered into mysql through the application.

I want to have identical configurations on the local server and the web server including mysql tables and data, and web application using dreamweaver. I've accomplished that, except for that one field in the table that saves passwords. I'm planning for the day I need to transfer to another web hosting company, and I don't want each user to have to re-enter each password.

[barryccampbell]

Sorry, I wasn't very clear on the earlier post. My database has tables that has user entered information, one of which is passwords. The overall MySQL user tables are not affected by what is in the database tables from web entered information. The passwords entered through the user interface on the web do not give the web user access to anything but his information in the database table. That is the password information I am trying to duplicate on my local server for backup purposes, not the MySQL user tables.

That being said, I checked the old_passwords on both the host and the home server and they do not match. Host says “ON” and home says “OFF”. I don't know how to change that variable. Would that variable affect individual table data passwords entered from the web? Would changing that variable correct the problem I'm having?

My web application works both locally and on the host for accessing the database files copied from one to the other. It is just when a user attempts to enter his password through the web interface that the application does not recognize it.

Once again, sorry for the lack of information given. What I know about mysql is self taught, which, I'm sure, is the problem. I'm trying to learn as I go. Thank you for your help.

[barryccampbell]

thanks for responding. I did get the connection to work. I did what I recommend everyone do, I walked away, forgot about it, went back early this morning and it worked after the second try. 1&1 gives you a host name that must be used in the MySQL Host Address. Every other server I have used has localhost or mysql as the Host Address. After carefully READING the information provided, then using their given host name, then adding the username & password that was provided, the connection worked. Again, thanks for responding, and maybe this will help some other soul that fails to carefully READ the information the first time through.

Barry

[barryccampbell]

I have not been using mysql 5 for very long. I reinstalled everything about 3 weeks ago and started using the current version of mysql at that time. Before reinstall, I set up a duplicate db on another local machine, version 5. I was still using 4.1 on the current host. I sync'd the 2 db's using sqlyog 4.1. Dumped the entire system. Then synced the files back from the 2nd machine when I reinstalled mysql 5 on my newly clean system. That could be when my problems started, but I thought I had sync'd with Yahoo! at least once after reinstalling everything.

I appreciate the previous posts. You have shed light on my problem. I will read the articles and sync with the Yahoo! host the way it says. Maybe Yahoo! will upgrade soon, but I doubt it.

Thanks again.

[barryccampbell]

Thanks for responding. You're right mysql versions are quite different. 5.0.15 on my local machine vs. 3.23.49 on my remote host. I just upgraded, but I'm fairly certain that I did not have the problem using SQLyog 4.1. I upgraded to 4.2 then 5.0 and had the problem starting with them. I am certain I did not have the problem when using a later version of mysql 4. I am able to get my local db copied to the remote host, but the sync tool was so handy. Just curious if there was a workaround to make it work.

[Author]

Posts