I'm trying to install the new version 4.30 locally with mysql 8.0.19. In the installation process I set the following line to connect to the db: Database=nopcommerce;Port=3307;Data Source=127.0.0.1;User Id=root; Password=xxxxxx
Installation begin and in mysql database I have 121 Tables and 1 Function but installation return: Setup failed: Fatal error encountered during command execution.
Hope all is well with you. Just need some guidance on the location of the connection string for MySQL. I had to re-install MySQL due to I had forgotten the Admin password I created. (I did try to reset the password manually per online suggestions, but none worked.) If you can let me know where I can find the connection string for MySQL that would be great. I know in previous versions, the connection string was stored in appsettings.txt. Since we have moved from Entity Framework, I know the string is stored in another location. My goal is to get the installer page so I can the enter connection string and recreate the database.
Thanks for your help and much success in your nopCommerce deployments! GDD Bless
Hope all is well with you. Just need some guidance on the location of the connection string for MySQL. I had to re-install MySQL due to I had forgotten the Admin password I created. (I did try to reset the password manually per online suggestions, but none worked.) If you can let me know where I can find the connection string for MySQL that would be great. I know in previous versions, the connection string was stored in appsettings.txt. Since we have moved from Entity Framework, I know the string is stored in another location. My goal is to get the installer page so I can the enter connection string and recreate the database.
Thanks for your help and much success in your nopCommerce deployments! GDD Bless
Hi rgtDev
You will find the connection string in the App_Data folder, in the file dataSettings.json
If you wish to 'reset' nopCommerce and start at the installer page afresh, you can delete the dataSettings.json file (you may also need to delete the plugins.json file in the same location)
Makes sense to delete the dataSettings.json file so the installer page displays. That is the same process when we had appSettings.txt file. Now, why didn’t I think of that?
Thanks again for your help JonQuick. Much success in your NopCommerce deployments.