Among other things, if you are getting this error, make sure to add “user” to your “database” through your cpanel. It is very easy to forget this steps, espeially if you are going through this configuration for the first time.

Select your choice of user and database then click the Add button to process your selections.

Step to add user

Next you will see the privilege selection screen. Selection your options or select ALL.

privilege selection

For many online store administrator, there is a need to add “Shipped” to the standard list of order status. This is because non of the default order status correctly tells customers that their order has been shipped. See complete default list in admin by going to Customers/orders -> Orders -> Edit Status.

Here are steps for adding a new order status value to the order status pull down menu. The same process can be used to add additional values to order status at any time.

1. Open your database in phpMyAdmin; select `orders_status`
2. Run this command:

INSERT INTO `orders_status` (`orders_status_id`, `language_id`, `orders_status_name`) VALUES (’222′, ‘1′, ‘Shipped’);

3. In case you need to add additional values, increment order_status_id to something like 223. Also language_id used here is for ‘english’, to get the correct language_id for your installation, I suggest you check the values in your admin by going to localization -> languages.