I am migrating my phpmaker2023 project to 2024. After the ‘automatic’ part of the conversion, it looks like something changed with the database connection.
After generating the project, an access denied error is thrown: Access denied for user '<username hash>'@'localhost' (using password: YES)
When reconnecting to the database via database → connect, I lose all the custom configuration but I don’t get the Access Denied error any longer.
Do I have to change the database connection settings when migrating to phpmaker2024? All of this worked in the previous version of the project (phpmaker2023)
If you see hashed username, you might have encrypted user name before but it cannot be decrypted now. You may double check your Encrypt user name and password and Encryption key for data protection settings, make sure they have not been changed after converting the project.
Hello, I double checked the settings. I updated Xampp etc. Keep getting the same error message.
When I reconnect the database it works, but I lose all settings. What is the substantive difference between synchronizing and reconnecting?
As the warning said, if you connect again in an existing project, you overwrite the existing settings. You should use synchronization, which update your project with the existing tables/fields in your database. As suggested:
You may also open your old and new project files in a text editor and compare the “EncryptUsernamePassword” and “EncryptionKey” settings. Make sure they are the same.