Using nopCommerce with MySQL

Nopcommerce 4.3 was released and with it, the ability to use a MySQL database. In this post I’ll be showing you how to configure your nopCommerce 4.3 with a MySQL database.

Like many applications, nopCommerce is installed in two steps. First, you install the nopCommerce application into your site and then you complete the software configuration by providing information through an Installation Wizard that you access through your web browser.

You can use our Application Installer to install nopCommerce 4.3 in your site. Follow the instructions in the first part of this Knowledge Base article to get the initial nopCommerce install done but you won’t need to create a new MS SQL database. The rest of the information in this blog post will give instructions on how to create a MySQL database and how to complete the nopCommerce Installation screen.

Now that you have installed nopCommerce in you site, we want to pull up the nopCommerce Installation screen to finish configuring nopCommerce. Assuming that your domain is not yet resolving to Winhost, you can complete the nopcommerce configuration using the Secondary URL we provide you. Here is how to find the Secondary URL.

• Log into the Winhost control panel
• Click on the Sites tab.
• Click on your Site account.
• Find “Secondary Web URL” under the Site Info section

Enter the Secondary URL into your web browser. You will be presented with the nopCommerce Installation screen. In this screen, you will provide specific information about your store and hosting account to finish configuring the application.

Enter the following information into the nopCommerce Installation screen.

• Your nopCommerce Admin user email (Note: This could be the same Admin user for Winhost or a different email address)
• nopCommerce Admin User Password (Note: Don’t use the same password as your Winhost control panel)
• Confirm the Password

Next, you need to create a MySQL database through the Winhost control panel. Here are step-by-step instructions.

• Login into the Winhost control panel.
• Click on the Sites tab.
• Click on your Site account.
• Click on MySQL icon.
• Click on Add
• Enter the Database Name you wish to use
• Enter the Database User
• Enter the MySQL Storage Quota
• Click on Create button

Now, you need to specify that you will use MySQL as your database and tell the nopCommerce application where the database is and how to access it. So, go back to the nopCommerce Installation screen and have the Winhost Control Panel MySQL section open in another browser tab so you can go back and forth to get and enter your information.

In the Database Information Section of the nopCommerce Installation screen, click on the Dropdown menu and select MySQL as shown below:

• Leave the Create Database and raw connection string unchecked.
• Enter the Database Server setting from the Winhost control panel into the Server Name field in the nopCommerce Installation screen.
• Enter the Database Name setting from the Winhost control panel into the Database Name field in the nopCommerce Installation screen.
• Enter the Database User from the Winhost control panel into the SQL Username field in the nopCommerce Installation screen.
• Enter the Database Password for your MySQL database into the SQL Password field in the nopCommerce Installation screen.

Click on the Install button and wait for the installation to complete. This will take a few minutes.

Enjoy

Visit Winhost to learn more about our nopCommerce hosting solution